[jboss-user] [JCA/JBoss] - Re: How to connect my EJB to Firebird database?
g_zaspa
do-not-reply at jboss.com
Wed Jan 31 04:59:30 EST 2007
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
More information about the jboss-user
mailing list