SQL state [72000]; error code [1009]; ORA-01009: 必需的参数缺失 ;missing mandatory parameter
当应用出现如下异常：
StatementCallback; uncategorized SQLException for SQL [select nvl(flow_Step,0) as flow_Step from ec_Acc_Fee where zone_Code like '01%' and user_Id=1004259812]; SQL state [72000]; error code [1009]; ORA-01009: 必需的参数缺失 ; nested exception is java.sql.SQLException: ORA-01009: 必需的参数缺失
原因是驱动程序对sql里的括号或者注释、插入语支持有问题，可以 ：
1、Setting 'hibernate.use_sql_comments=false' in hibernate.properties fixes the problem.
2、升级jdbc Driver到ojdbc14_g.jar（oracle 10.2.0.1.0）
环境：
Spring version:
1.2
Hibernate version:
3.0.3
JDK version:
1.4 (same problem w/1.5)
Name and version of the database you are using:
Oracle 9.2.0.1.0
oracle.jdbc.driver.OracleDriver (ojdbc14.zip)