RE: JDBC: "Internal Error"

Posted in 2000

Topics: Connectivity: ODBC / JDBC / .NET, Transactions, Locking & Isolation, Java & JDBC Development

William Rice — Tue, 11 Apr 2000 10:59:54 -0400 — source: Informix-list mailing list archive (1991-1998)

Might you post the code you are using and the schema of the table involved? (Make sure the code includes what the sql statement you are sending is) I would think you would be getting an error number back from your sql call. What that error number is would be helpful as well. Are you within a transaction? Might you be deadlocking with other processes? Will >===== Original Message From Leonard Marinis <Leonard.E.Marinis@grc.nasa.gov> ===== >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 ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------

↪ replying to William Rice

Watawinona — 11 Apr 2000 19:11:57 GMT — source: Informix-list mailing list archive (1991-1998)

What jdk and jdbc versions? And what's the code? Nona >Subject: RE: JDBC: "Internal Error" >From: William Rice ricew@operamail.com >Date: 11.04.00 16:59 W. Europe Daylight Time >Message-id: <8cvflk$c5d$1@news.xmission.com> > > >Might you post the code you are using and the >schema of the table involved? >(Make sure the code includes what the sql statement you are sending is) > >I would think you would be getting an error number >back from your sql call. What that error number is would be helpful as >well. > >Are you within a transaction? > >Might you be deadlocking with other processes? > >Will >>===== Original Message From Leonard Marinis <Leonard.E.Marinis@grc.nasa.gov> > >===== >>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 > >------------------------------------------------------------ >This e-mail has been sent to you courtesy of OperaMail, as a free service >from >Opera Software, makers of the award-winning Web Browser, Opera. Visit us >at >http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free >e-mail >account is waiting at: http://www.operamail.com/ >------------------------------------------------------------ > > > >