informix+java的应用突然出现写不进库的问题

drummer0218

前天一切正常
昨天下午出现：
[Mon Mar 01 17:55:48 CST 2004]
java.sql.SQLException: General error
        at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:7087)
        at sun.jdbc.odbc.JdbcOdbc.SQLAllocConnect(JdbcOdbc.java:117)
        at sun.jdbc.odbc.JdbcOdbcDriver.allocConnection(JdbcOdbcDriver.java:930)
        at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:126)
        at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at sms.db.DbSms.getConnection(DbSms.java:25)
        at sms.db.DbSms.simpleSelect(DbSms.java:56)
        at sms.mess.SendMsgAir.send_air(SendMsgAir.java:65)
        at sms.mess.SendMsgAir.run(SendMsgAir.java:51)
[Mon Mar 01 17:55:48 CST 2004]
java.lang.NullPointerException
        at sms.db.DbSms.simpleSelect(DbSms.java:57)
        at sms.mess.SendMsgAir.send_air(SendMsgAir.java:65)
        at sms.mess.SendMsgAir.run(SendMsgAir.java:51)
今天的问题更多了：
[Tue Mar 02 09:13:00 CST 2004]
java.sql.SQLException: General error
        at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:7087)
        at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:3362)
        at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:964)
        at sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:740)
        at sms.db.DbSms.simpleSelect(DbSms.java:8
        at sms.mess.SendMsgAir.send_air(SendMsgAir.java:65)
        at sms.mess.SendMsgAir.run(SendMsgAir.java:51)
[Tue Mar 02 09:32:46 CST 2004]
java.sql.SQLException: General error
        at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:7087)
        at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:3362)
        at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:964)
        at sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:740)
        at sms.db.DbSms.simpleSelect(DbSms.java:8
        at sms.mess.SendMsgAir.send_air(SendMsgAir.java:65)
        at sms.mess.SendMsgAir.run(SendMsgAir.java:51)
[Tue Mar 02 10:43:06 CST 2004]
java.sql.SQLException: General error
        at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:7087)
        at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:3362)
        at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:964)
        at sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:740)
        at sms.db.DbSms.simpleSelect(DbSms.java:8
        at sms.mess.SendMsgZikao.send_zikao(SendMsgZikao.java:64)
        at sms.mess.SendMsgZikao.run(SendMsgZikao.java:50)
[Tue Mar 02 10:43:07 CST 2004]
java.sql.SQLException: Invalid handle
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7130)
        at sun.jdbc.odbc.JdbcOdbc.SQLNumResultCols(JdbcOdbc.java:4677)
        at sun.jdbc.odbc.JdbcOdbcStatement.getColumnCount(JdbcOdbcStatement.java:1235)
        at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:352)
        at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
        at sms.db.DbSms.simpleSelect(DbSms.java:5
        at sms.mess.SendMsgSb.send_sb(SendMsgSb.java:64)
        at sms.mess.SendMsgSb.run(SendMsgSb.java:50)
[Tue Mar 02 12:48:47 CST 2004]
java.sql.SQLException: General error
        at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:7087)
        at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:3362)
        at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:964)
        at sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:740)
        at sms.db.DbSms.simpleSelect(DbSms.java:8
        at sms.mess.SendMsgZikao.send_zikao(SendMsgZikao.java:64)
        at sms.mess.SendMsgZikao.run(SendMsgZikao.java:50)
[Tue Mar 02 12:50:24 CST 2004]
java.sql.SQLException: General error
        at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:7087)
        at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:3362)
        at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:964)
        at sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:740)
        at sms.db.DbSms.simpleSelect(DbSms.java:8
        at sms.mess.SendMsgZikao.send_zikao(SendMsgZikao.java:64)
        at sms.mess.SendMsgZikao.run(SendMsgZikao.java:50)
[Tue Mar 02 13:04:57 CST 2004]
java.sql.SQLException: General error
        at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:7087)
        at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:3362)
        at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:964)
        at sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:740)
        at sms.db.DbSms.simpleSelect(DbSms.java:8
        at sms.mess.SendMsg.send(SendMsg.java:64)
        at sms.mess.SendMsg.run(SendMsg.java:50)
[Tue Mar 02 13:08:14 CST 2004]
java.sql.SQLException: General error
        at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(JdbcOdbc.java:7087)
        at sun.jdbc.odbc.JdbcOdbc.SQLFreeEnv(JdbcOdbc.java:3362)
        at sun.jdbc.odbc.JdbcOdbcDriver.closeConnection(JdbcOdbcDriver.java:964)
        at sun.jdbc.odbc.JdbcOdbcConnection.close(JdbcOdbcConnection.java:740)
        at sms.db.DbSms.simpleSelect(DbSms.java:8
        at sms.mess.SendMsgAir.send_air(SendMsgAir.java:65)
        at sms.mess.SendMsgAir.run(SendMsgAir.java:51)
-------
online.log里没有任何异常，程序开始几分钟之内是正常的，之后就又出现写不进记录的情况，同时！select也出不来了。。。。。。
=======
有遇到以上情况的人吗？~怎么解决的啊？
有一看就知道是怎么回事的人吗？怎么解决啊？~
*******
Informix Dynamic Server 9.30.FC4
INFORMIX 3.34 32 BIT

强烈感谢回帖~

drummer0218

老大，我说了的呀，是一直都好好的，就是不知道怎么搞的，应该是什么也没动的，就突然出现了一个连不上库的小问题，而online.log里又没有任何表征的。接着，今天的问题就更多了，不光有连不上的，就是连上了也有写不进库的问题，没看到有errcode被返回。
我的应用是已经用了不短的一段时间了的，应该没问题，我觉得是不是数据库上出了点什么什么我不知道的情况的！
大大分析的话，需要我贴点别的什么吗？

satoni

你是不是用的tomcat之类的啊。看看那个有没有问题

drummer0218

现在转为JDBC，好用了，呵呵~