JDBC: "Internal Error"
Posted in 2000
Hi All, I've posted this once already but got no responses. I'll try one last time; hopefully someone can help? I'm writing a very simple application to insert rows into an Informix 7.30.UC7-2 (Linux Edition) database via JDBC. Unfortunately I'm getting the following SQLException every once in a while (I honestly can't pinpoint any causing factors, it just happens after a few thousands inserts): java.sql.SQLException: System or internal error at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:308) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2008) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:1897) at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:1872) at com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:336) at com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:761) at com.informix.jdbc.IfxStatement.execute(IfxStatement.java:511) at Depp2DB.insertFrame(Depp2DB.java:284) at Depp2DB.main(Depp2DB.java:317) I've been unable to get a hold of anyone in Informix about this since I don't have a year-long support contract (why doesn't Informix offer case-by-case troubleshooting? I suppose that's for another thread..) Very frustrating when the problem is apparently occuring deep in the JDBC driver. Has anyone run into anything similar to this? Any input at all would be helpfull. I've tried various JDK's and both JDBC drivers from Informix with the same results. I'm running SMP RedHat v6.0 (w/glibc-2.1.2) and am beginning to suspect some concurrency problems with SMP in the JDBC driver? Thanks, Len Marinis lmarinis@hotmail.com