Subject | JBDC to Firebird - Commit error in threads |
---|---|
Author | Thomas Fischer |
Post date | 2002-04-23T09:30:04Z |
Hi.
I have an exception during inserting several data lines (several insert
statements) into a database
with a single 'commit' statement in a parallel process (thread).
On JDBC Client to an Oracle 9i server it's working fine. Does anyone know a
hint ?
May be there is a jdbc version which worked with a 'commit' in a thread ?
I paste my database and jdbc client information. It's an Firebird server
final release with the latest firebird jdbc
version 2.0.1
Thanks for help :-)
----------- Here the Exception: ----------------------------------
java.lang.RuntimeException: [interclient] Bug detected.
Please send mail to interclient@...
Refer to bug code 10019.
See API reference for exception interbase.interclient.BugCheckException,
statement: INSERT INTO min_max (TYPE_ID, VALUE_ID, PAT_ID, MEASURETIME,
DATA) VALUES (?, ?, ?, ?, ?) at
intellicare.monica.frontend.dbtools.datagen.datalink.datalinkimpl.dalisimple
.SimpleValue.save(SimpleValue.java:86) at
intellicare.monica.frontend.dbtools.datagen.consumer.DataConsumer.consume(Da
taConsumer.java:113) at
intellicare.monica.frontend.dbtools.datagen.consumer.DataConsumer.run(DataCo
nsumer.java:52)
----------- Thats my Interclient: ---------------------------------
Middleware JDBC/Net server name: InterServer
Middleware JDBC/Net server version: 2.0.1 Test Build
Middleware JDBC/Net server protocol version: 20001
Middleware JDBC/Net server expiration date: no expiration date
Middleware JDBC/Net server port: 3060
----------- Thats my Firebird Server: -----------------------------
Database product name: InterBase
Database product version: WI-V6.2.794 Firebird 1.0
Database ODS version: 10.0
Database Page Size: 4.096 bytes
Database Page Allocation: 638 pages
Database Size: 2.552 Kbytes
Database SQL Dialect: 3
Thomas Fischer
Software Engineer
Intellicare GmbH
Anne-Conway-Straße 2
28359 Bremen
Tel +49(421)9 88 99 - 75
Fax +49(421)9 88 99 - 99
I have an exception during inserting several data lines (several insert
statements) into a database
with a single 'commit' statement in a parallel process (thread).
On JDBC Client to an Oracle 9i server it's working fine. Does anyone know a
hint ?
May be there is a jdbc version which worked with a 'commit' in a thread ?
I paste my database and jdbc client information. It's an Firebird server
final release with the latest firebird jdbc
version 2.0.1
Thanks for help :-)
----------- Here the Exception: ----------------------------------
java.lang.RuntimeException: [interclient] Bug detected.
Please send mail to interclient@...
Refer to bug code 10019.
See API reference for exception interbase.interclient.BugCheckException,
statement: INSERT INTO min_max (TYPE_ID, VALUE_ID, PAT_ID, MEASURETIME,
DATA) VALUES (?, ?, ?, ?, ?) at
intellicare.monica.frontend.dbtools.datagen.datalink.datalinkimpl.dalisimple
.SimpleValue.save(SimpleValue.java:86) at
intellicare.monica.frontend.dbtools.datagen.consumer.DataConsumer.consume(Da
taConsumer.java:113) at
intellicare.monica.frontend.dbtools.datagen.consumer.DataConsumer.run(DataCo
nsumer.java:52)
----------- Thats my Interclient: ---------------------------------
Middleware JDBC/Net server name: InterServer
Middleware JDBC/Net server version: 2.0.1 Test Build
Middleware JDBC/Net server protocol version: 20001
Middleware JDBC/Net server expiration date: no expiration date
Middleware JDBC/Net server port: 3060
----------- Thats my Firebird Server: -----------------------------
Database product name: InterBase
Database product version: WI-V6.2.794 Firebird 1.0
Database ODS version: 10.0
Database Page Size: 4.096 bytes
Database Page Allocation: 638 pages
Database Size: 2.552 Kbytes
Database SQL Dialect: 3
Thomas Fischer
Software Engineer
Intellicare GmbH
Anne-Conway-Straße 2
28359 Bremen
Tel +49(421)9 88 99 - 75
Fax +49(421)9 88 99 - 99