I am trying to migrate my application from using Firebird to Oracle.
Today I use the following configuration in my EAR project and it works fine:
<connection-factories>
<tx-connection-factory>
<jndi-name>DatasourceNameDS</jndi-name>
<xa-transaction/>
<!-- Apparently this will fix the failure to delist resource?!-->
<track-connection-by-tx/>
<!-- Hmmm maybe not?! Other report the following to fix the NPE ?!-->
<idle-timeout-minutes>0</idle-timeout-minutes>
<!-- Thought I'd share our experience that looks very, very similar. We worked around the issue by setting <idle-timeout-minutes>0</idle-timeout-minutes>
on each datasource. Haven't had a problem since. (It's been about 10 months). -->
<adapter-display-name>Firebird Database Connector</adapter-display-name>
<rar-name>jaybird-2.0.1.rar</rar-name>
<connection-definition>javax.sql.DataSource</connection-definition>
<config-property name="Database" type="java.lang.String">dbserver/3050:c:/somedatabase.gdb</config-property>
<user-name>username</user-name>
<password>password</password>
<min-pool-size>0</min-pool-size>
<check-valid-connection-sql>SELECT CAST(1 as INTEGER) FROM rdb$database</check-valid-connection-sql>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>Firebird</type-mapping>
</metadata>
</tx-connection-factory>
</connection-factories>
Now I want to configure Oracle as a tx connection factory, but how do I do that? I haven't been able to find any examples about it. I hope someone can help me. I already tried configuring Oracle using the example configurations provided with JBoss, but while I can use those to connect to the database, they result in me getting connection factory deployment errors on startup, and I assume that has something to do with the fact, that I need to configure Oracle as a connection factory, just like I did with Firebird.