hibernate3 c3p0连接池 db2V8 操作sql语句报错

hjysuccess 2008-10-06 07:04:54

Hibernate: select this_.adminId as adminId0_0_, this_.IpassId as IpassId0_0_, this_.adminStatus as adminSta3_0_0_, this_.extend1 as extend4_0_0_, this_.extend2 as extend5_0_0_, this_.extend3 as extend6_0_0_, this_.extend4 as extend7_0_0_ from uuas.admin_tab this_ where this_.IpassId=? and this_.extend1=? and this_.adminStatus=?
2008-10-06 18:40:16,203 WARN [http-8000-Processor25] util.JDBCExceptionReporter (JDBCExceptionReporter.java:71) - SQL Error: -204, SQLState: 42704
2008-10-06 18:40:16,218 ERROR [http-8000-Processor25] util.JDBCExceptionReporter (JDBCExceptionReporter.java:72) - DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: UUAS.ADMIN_TAB
2008-10-06 18:40:16,218 WARN [http-8000-Processor25] util.JDBCExceptionReporter (JDBCExceptionReporter.java:71) - SQL Error: -727, SQLState: 56098
2008-10-06 18:40:16,218 ERROR [http-8000-Processor25] util.JDBCExceptionReporter (JDBCExceptionReporter.java:72) - DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-204;42704;UUAS.ADMIN_TAB
2008-10-06 18:40:16,218 WARN [http-8000-Processor25] util.JDBCExceptionReporter (JDBCExceptionReporter.java:71) - SQL Error: -727, SQLState: 56098
2008-10-06 18:40:16,234 ERROR [http-8000-Processor25] util.JDBCExceptionReporter (JDBCExceptionReporter.java:72) - DB2 SQL error: SQLCODE: -727, SQLSTATE: 56098, SQLERRMC: 2;-204;42704;UUAS.ADMIN_TAB
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1533)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)

hibernate.hbm.xml 配置
<property name="show_sql">true</property>
<property name="default_schema">uuas</property>
<property name="connection.url">
jdbc:db2://192.168.101.240:50000/uuas
</property>
<property name="connection.username">db2inst1</property>
<property name="connection.password">db2inst1</property>
<property name="connection.driver_class">
com.ibm.db2.jcc.DB2Driver
</property>
<property name="dialect">org.hibernate.dialect.DB2Dialect</property>

<property name="hibernate.connection.provider_class">
org.hibernate.connection.C3P0ConnectionProvider
</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.timeout">120</property>
<property name="hibernate.c3p0.max_statements">100</property>
<property name="hibernate.c3p0.idle_test_period">120</property>
<property name="hibernate.c3p0.acquire_increment">2</property>
<property name="hibernate.jdbc.fetch_size">30</property>
<property name="hibernate.jdbc.batch_size">50</property>
<property name="hibernate.cache.use_query_cache">true</property>
<property name="hibernate.cache.provider_class">
org.hibernate.cache.EhCacheProvider
</property>
<property name="cache.use_second_level_cache">true</property>

说明：可以连接数据库但是不能执行sql语句，在mysql下执行没有任何的问题，但是。。。。
请教高手！谢谢

...全文