Firebird connection problem
806684Feb 2 2011 — edited Feb 2 2011Hello
I'm trying to use Firebird JDBC driver (JayBird 2.1.6) in OSB (11.1.1.3).
I've configured connection poll with the following parameters:
JDBC DataSource:
driver class name - org.firebirdsql.jdbc.FBDriver
transactions - unchecked Supports Global Transactions
DBAdapter connection factory:
dataSourceName - filled
xADataSourceName - empty
Transaction Support - no transaction
I got the following error message when try to test it (insert record in table):
Caused by java.sql.SQLException: Cannot call Connection.commit in distributed transaction. Transaction Manager will commit the resource manager when the distributed transaction is committed.
Does anyone know what is the problem and how to fix it?
Thanks for any help!