16 个线程并发操作informix ,infomix jdbc driver 里就会狂出错请教

0 0

16 个线程并发操作informix ,infomix jdbc driver 里就会狂出错请教0

各位：
   我们有一个报表系统，在后台批处理最后插入数据库时，会从informix jdbcDriver里抛出诸多怪异的nullpointException,这些是informixdriver 's bug吗？或者需要什么数据库级的配置？

环境：AIX ibm590 , IBM Informix Dynamic Server Version 10.00.FC5 , j2ee 项目.
出错情境：并发开启16个thread . 操作数据库，按一定条件，对一张表先删，后插入。
           使用apache DBCP 连接池，连接池连接数30个，(按理说16个线程操作数据库，最多使用16个连接，但发现出错时，已表现是新建连接了，这个地方也不知是不是连接池的原因.)

具体错误：
java.lang.NullPointerException
         at com.informix.jdbc.IfxDriver.a(IfxDriver.java:911)
         at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:233)
         at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
         at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
         at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
         at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
         at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
         at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:186)

java.lang.NullPointerException
         at java.util.Hashtable.put(Hashtable.java:632)
         at com.informix.jdbc.IfxDriver.a(IfxDriver.java:962)
         at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:233)
         at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
         at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
         at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)
         at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
         at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
         at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:186)

连这个select 竞也会出错。不是所有select都错，是只有少数几个，select语句都是一样，只是执行时间不同
java.sql.SQLException: Database not selected yet.
org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [select kmh,jfye,dfye,ycjfye,ycdfye,jffse,dffse,yjffsexj,ydffsexj,yjffsezz,ydffsezz,ndffsexj,njffsexj,njffsezz,ndffsezz,ndffse,ncjfye,ncdfye,njffse from base_item_month where Dbank_id='2211042800' and Dcurr_id='01' and Ddate='2008-01-31' and (1=1) order by ROW_NO]; SQL state [IX000]; error code [-349]; Database not selected yet.; nested exception is java.sql.SQLException: Database not selected yet.

如有informix相关经验的高人，请望多多指点，thx.

数据库