java.sql.SQLException: Could not open database table

Hello NG, with Informix I get the error java.sql.SQLException: Could not open database table in my servlet after 253 or 254 selects/updates. Any idea how to solve this Problem. Its Informix SE and its not a Problem from the jdbc driver.... Chris

You can find the text behind any error message by typing finderr <msgno> at the command prompt. The ones you're getting come out as: -253 Identifier length exceeds the maximum allowed by this version of the server. A name in the statement exceeds the maximum length. In 7.x, 8.x, and 9.1x versions of the database server, the maximum length for identifiers in SQL statements is 18 characters. In 9.2 and later versions of the database server, the maximum length for identifiers in SQL statements is 128 characters. Check the length of the names and whether a typographical error caused two names to run together. and -254 Too many or too few host variables given. The number of host variables that you named in the INTO clause of this statement does not match the number of "?" place holders that you wrote into the statement. Locate the text of the statement (in a PREPARE or DECLARE statement), and verify the number of place holders. Then review the list in the INTO clause to see which item is incorrect. Andy "Christian Gauler" <horser@gmx.de> wrote in message news:<bpiplq$1no0h1$1@ID-76367.news.uni-berlin.de>... > Hello NG, > > with Informix I get the error > java.sql.SQLException: Could not open database table in my servlet after > 253 or 254 selects/updates. Any idea how to solve this Problem. Its Informix > SE and its not a Problem from the jdbc driver.... > > > > Chris