Hello, could you run the example with a JDBC trace? (And supply a definition of the table that is affected?)
Regards Alexander Schröder SAP DB, SAP Labs Berlin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 4. Mai 2006 16:05 To: maxdb@lists.mysql.com Subject: [-3102]: Invalid subtrans structure / update / column of type LONG / JDBC Hello, I guess that there is a bug that causes the above exception (error message "[-3102]: Invalid subtrans structure") when a row containing a column of type LONG is updated. But it seems that this error is thrown only under certain conditions. - the exception occurs only if the value of the LONG-column is NOT NULL. - the exception is thrown only when using a certain sequence of statements. In our example the exception is thrown using the following sequence: SELECT: we read the last row's primary key of that table INSERT: we insert the new row containing some data for the column of type LONG [prep.setBytes(byte[])] UPDATE: we update the inserted row while all non-key columns are updated (altough the byte[]-content remains the same) -> If we place another SELECT-statement between the above INSERT and UPDATE statement that reads the inserted row from the database, the exception is *not* thrown. -> Altough the exception is thrown, the update is done correctly in our example We use JDBC driver 7.6.0 Build 012-000-004-339 on MaxDB Kernel 7.5.0 Build 034-121-118-234 I found that there was a similar problem posted on 2003-03-03 and possibly the same problem was the cause of this report: http://lists.mysql.org/maxdb/19277 (28.11.2003) Perhaps I'll be able to post a program/tabledefinition that can reproduce the problem. Best regards, Gabriel Matter
smime.p7s
Description: S/MIME cryptographic signature