Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Firebird connection problem

806684Feb 2 2011 — edited Feb 2 2011
Hello

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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2011
Added on Feb 2 2011
1 comment
275 views