[jboss-user] [JCA/JBoss] - Re: How to connect my EJB to Firebird database?

[g_zaspa]

Weston,

I just copied firebird-ds.xml from JBoss4.0.5 doc folder and changed rar and database names. The jndi name FIrebirdDS I didn't change. Here's the full text of my firebird-ds.xml:

<?xml version="1.0" encoding="UTF-8"?>
  | 
  |   <!-- $Id: firebird-ds.xml 41641 2006-03-02 17:41:11Z dimitris $ -->
  |   
  |   <!-- ==================================================================== -->
  |   <!-- 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">${jboss.server.data.dir}${/}fbtest.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>FIrebirdDS</jndi-name>
  |     <xa-transaction/>
  |     <track-connection-by-tx/>    
  |     <rar-name>jaybird-2.1.1.rar</rar-name>
  |     <connection-definition>javax.sql.DataSource</connection-definition>    
  |     <config-property name="Database" type="java.lang.String">localhost/3050:c:/1/fbtest.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>
  | 
Can you explain me why I get the following message in JBoss console when deploying my .ear (I wrote of that before - actually it is the last part of the message) and if this problem may cause problems for the work of the EJB:

--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.jca:name=FIrebirdDS,service=DataSourceBinding
State: NOTYETINSTALLED
Depends On Me:
persistence.units:ear=EJB3Test.ear,jar=EJB3Test.jar,unitName=order
persistence.units:ear=EJB3Test.ear,jar=EJB3Test.jar,unitName=order
persistence.units:ear=EJB3Test.ear,jar=EJB3Test.jar,unitName=order 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4008716#4008716

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4008716