Re: informix jdbc driver problem?

--Boundary_(ID_S/jmvjB0LO21ybG03gbhmw) Content-type: text/plain; charset=us-ascii Content-disposition: inline Content-transfer-encoding: 7BIT bstaib You can use the finderr utility to find what the error numbers mean. Frex: prompt> finderr -239 -239 Could not insert new row - duplicate value in a UNIQUE INDEX column. The row that is being inserted (or being updated to have a new primary key) contains a duplicate value of some row that already exists, in a column or columns that are constrained to have unique values. The row is not inserted. Roll back the current transaction, and execute it again without any duplicate rows. prompt >finderr -100 -100 ISAM error: duplicate value for a record with unique key. A row that was to be inserted or updated has a key value that already exists in its index. For C-ISAM programs, a duplicate value was presented in the last call to iswrite, isrewrite, isrewcurr, or isaddindex. Review the program logic and the input data. For SQL products, a duplicate key value was used in the last INSERT or UPDATE. The explanations would probably provide more clues to your problem. HTH Sujit bstaib <bstaib@justintime.com> on 10/04/99 01:57:16 PM Please respond to bstaib <bstaib@justintime.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: informix jdbc driver problem? --Boundary_(ID_S/jmvjB0LO21ybG03gbhmw) Content-type: text/plain; charset=iso-8859-1 Content-disposition: inline Content-transfer-encoding: quoted-printable I am getting some intermittent exceptions during the execute() call of = a prepared statement. It is a multi-threaded application running on Solaris. Using jdk 1.1.5, native threads, and the weblogic type 4 jdbc driver (3.1). Here are some examples of the seemingly random exceptions= being caught: (any help appreciated) Informix error: -239 minor code=3D[-100] [ at processUpdate <Error> ] S= ee Informix error codes for explanation Informix error: 6 minor code=3D[203] [ProcessUpdate: Expected packet ID= but got: 8 and 00,06,00,CB,00,00,00,00,00,38,00,01,00,05,00,00, // = - =CB 8 - - 00,00,00,0C, // -] See Informix error codes for explanation Informix error: 0 minor code=3D[15] [Expected packet ID but got: 56 and= 00,00,00,0F,00,00,00,00,00,00,00,00,00,00,00,00, // - 00,00,00,37,00,00,00,01,00,00,00,01,00,0C, // 7 - - -] See Informix error codes for explanation Informix error: 1 minor code=3D[41] [Expected packet ID but got: 15 and= 00,01,00,29,F5,0A,00,00,00,00,00,37,00,00,04,DB, // - )=F5- 7 -=DB= 00,00,00,A3,00,0C, // =A3 -] See Informix error codes for explanation Informix error: 0 minor code=3D[0] [Expected packet ID but got: 12 and 00,0C, // -] See Informix error codes for explanation: = --Boundary_(ID_S/jmvjB0LO21ybG03gbhmw)--