1 Reply Latest reply on Jun 14, 2006 10:08 AM by Weston M. Price

    Configuring Oracle as <tx-connection-factory>

    Anders Carlsen Newbie

      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:

       <!-- Apparently this will fix the failure to delist resource?!-->
       <!-- Hmmm maybe not?! Other report the following to fix the NPE ?!-->
       <!-- 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>
       <config-property name="Database" type="java.lang.String">dbserver/3050:c:/somedatabase.gdb</config-property>
       <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) -->

      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.