Re: JDBC: "Internal Error"
Posted in 2000
Topics: Error Codes & Troubleshooting, Connectivity: ODBC / JDBC / .NET, Server Administration
I appreciate the replies. Unfortunately, I cannot post the code. However,
I can say it is really nothing fancy. Just a simple looping
Statement.execute( "INSERT INTO..." ). I am certain there is nothing wrong
with the SQL of the insert as it'll execute fine many times and then fail
inexplicably... It is inserting to a single table with approximately 140
fields.
I have noticed something though. It would appear that executing an sql
command from another session (e.g., dbaccess) while the application is
running seems to exacerbate things. Though it doesn guarantee an immediate
Internal Error, one is often raised very soon afterwards.
There's no additional information available from the exception other than
what I posted. getErrorCode() returns the number corresponding to "System
or Internal Error". getSQLState() and getMessage() provide no additional
details. From the stack trace it would appear it's failing in the JDBC
driver's method receiveMessage() at line 2008. Of course that doesn't
really help me since I don't have the source and Informix refuses to talk
with me.
Hope this helps.
-Len