Hi, while using the Mysql-Connector-J together with a version 3.23.xx mysql server anything is working fine, except when i try to use this combination programmatically.
My working BASIC-code instantiates a RowSet, moves the cursor to the insert row, fills the insert row and writes the data out with a call to RowsSet.insertRow(). When doing so I get an exception: Type: com.sun.star.sdbc.SQLException Message: GDS Exception. 335544665. violation of PRIMARY or UNIQUE KEY constraint "INTEG_65" on table "TestTab" The code is tested with MyODBC 2.5 and the same server and with Firebird connected via ODBC (which crashes at the fifth inserted record, but that's another story). In the GUI I can edit tables and I'm absolutely sure the primary key is set to a legal value and it is unique. The server log show no entry, so the exception is inside OOo(1.1). How can I go on now? TIA, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
