1 Reply Latest reply on Mar 31, 2006 4:32 AM by Feroz Ahanger

    How to configure Firebird JNDI in JBoss 4.0.4RC1

    Feroz Ahanger Newbie

      hi,
      i am trying to configure Firebird datasource in JBoss 4.0.4RC1 but cant get it working.

      may be because i need a firebirdsql.rar, where can i get that file, it is not in JBoss anywhere..

      <?xml version="1.0" encoding="UTF-8"?>
      
       <!-- ==================================================================== -->
       <!-- New ConnectionManager setup for firebird dbs using jca-jdbc xa driver-->
       <!-- Build jmx-api (build/build.sh all) and view for config documentation -->
       <!-- ==================================================================== -->
      
      <connection-factories>
      
       <!--FBManager can be used to create and drop databases.
       Drop is especially useful during testing, since it
       assures a clean start next time. -->
       <mbean code="org.firebirdsql.management.FBManager" name="jboss.jca:service=FirebirdManager">
       <attribute name="FileName">E:\TEST.GDB</attribute>
       <attribute name="UserName">sysdba</attribute>
       <attribute name="Password">masterkey</attribute>
       <attribute name="CreateOnStart">true</attribute>
       <attribute name="DropOnStop">false</attribute>
       </mbean>
      
       <tx-connection-factory>
      
       <jndi-name>jdbc/firebirdDS</jndi-name>
      
       <xa-transaction/>
       <!-- Actually I need a firebirdsql.rar here, but i cant get it anywhere-->
       <rar-name>jboss-xa-jdbc.rar</rar-name>
       <connection-definition>javax.sql.DataSource</connection-definition>
      
       <config-property name="Database" type="java.lang.String">localhost/3050:E:\TEST.GDB</config-property>
      
       <user-name>sysdba</user-name>
      
       <password>masterkey</password>
      
       <!--additional properties. only use one way of setting tx isolation, please
       <config-property name="TransactionIsolation"></config-property>
       <config-property name="TransactionIsolationName">TRANSACTION_READ_COMMITTED</config-property>
       <config-property name="BlobBufferLength"></config-property>
       <config-property name="Encoding">UNICODE_FSS</config-property>
       -->
      
       <min-pool-size>0</min-pool-size>
       <!-- sql to call when connection is created
       <new-connection-sql>some arbitrary sql</new-connection-sql>
       -->
      
       <!-- sql to call on an existing pooled connection when it is obtained from pool
       <check-valid-connection-sql>some arbitrary sql</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>