Subject | Setting up local transactions with jboss and firebird? |
---|---|
Author | Andrew Goedhart |
Post date | 2007-03-15T11:37:45Z |
>>>> Use Oracle's example to setup the data source.The XMLlayout for firebird and oracle xml files are different and seem to refer to different rar files
firebird-ds.xml
---------------
<connection-factories>
<tx-connection-factory>
<jndi-name>ModelDS</jndi-name>
<!-- <xa-transaction/> replaced by line below -->
<local-transaction/>
<track-connection-by-tx/>
<rar-name>firebirdsql.rar</rar-name>
<connection-definition>javax.sql.DataSource</connection-definition>
<config-property name="Database" type="java.lang.String">196.37.96.64/3050:model.fdb</config-property>
<user-name>sysdba</user-name>
<password>ssss</password>
<config-property name="TransactionIsolationName">TRANSACTION_READ_COMMITTED</config-property>
<config-property name="BlobBufferLength"></config-property>
<min-pool-size>0</min-pool-size>
<new-connection-sql>select RDB$RELATION_ID from RDB$DATABASE</new-connection-sql>
<check-valid-connection-sql>select RDB$RELATION_ID from RDB$DATABASE</new-connection-sql>
</tx-connection-factory>
</connection-factories>
Oracle-ds
---------
<datasources>
<local-tx-datasource>
<jndi-name>ModelDS</jndi-name>
<connection-url>196.37.96.64/3050:model.fdb</connection-url>
<driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
<user-name>sysdba</user-name>
<password>yyyy</password>
<new-connection-sql>select RDB$RELATION_ID from RDB$DATABASE</new-connection-sql>
<check-valid-connection-sql>select RDB$RELATION_ID from RDB$DATABASE</check-valid-connection-sql>
</local-tx-datasource>
</datasources>
Would I be correct in assuming that the firebird-ds.xml requires: firebirdSql.rar or equivalent whilst the oracle -ds formated file requires: jboss-ha-local-jdbc.rar and the jaybird jar files in the jboss lib directory.