mysql v3 with connector/J

Marc Santhoff <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.