Firebird jca-jdbc xa driver beta and JBoss3rc
penningw Apr 28, 2002 12:31 PMAfter an apparent successful deploy of the driver (and creating an fbtest.gdb via a locahost firebird server and with the firebird-service.xml below) ... why should I get the following error:
2002-04-29 00:03:38,352 INFO [org.firebirdsql.jca.FBManagedConnectionFactory] Could not get a db connection!
org.firebirdsql.gds.GDSException:
at org.firebirdsql.jgds.GDS_Impl.connect(GDS_Impl.java:1240)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:263)
at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:247)
at org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle(FBManagedConnecti onFactory.java:515)
...
2002-04-29 00:03:38,812 ERROR [org.jboss.ejb.EntityContainer] Exception in service lifecyle operation: create
org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable is: java.sql.SQLException: Problem getting connection: javax.resource.ResourceException: could not get a db connection!
java.sql.SQLException: Problem getting connection: javax.resource.ResourceException: could not get a db connection!
at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:100)
at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:38)
MY FIREBIRD-SERVICE.XML:
<?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 -->
<!-- ==================================================================== -->
<!--FBManager can be used to create and drop databases.
Drop is especially useful during testing, since it
assures a clean start next time. -->
c:\fbtest.gdb
sysdba
masterkey
true
false
jboss.jca:service=RARDeployer
<depends optional-attribute-name="ManagedConnectionFactoryName">
<!--more hack-->
<depends optional-attribute-name="OldRarDeployment">
jboss.jca:service=RARDeployment,name=Firebird Database Connector
<!-- <config-property>
<config-property-name>Server</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>localhost</config-property-value>
</config-property>
<config-property>
<config-property-name>Port</config-property-name>
<config-property-type>java.lang.Integer</config-property-type>
<config-property-value>3050</config-property-value>
</config-property> -->
<config-property>
<config-property-name>Database</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>c:\fbtest.gdb</config-property-value>
</config-property>
<config-property>
<config-property-name>UserName</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>sysdba</config-property-value>
</config-property>
<config-property>
<config-property-name>Password</config-property-name>
<config-property-type>java.lang.String</config-property-type>
<config-property-value>masterkey</config-property-value>
</config-property>
FirebirdDS
<depends optional-attribute-name="ManagedConnectionPool">
0
50
5000
15
ByContainer
<depends optional-attribute-name="CachedConnectionManager">jboss.jca:service=CachedCo nnectionManager
java:/jaas/FirebirdDBRealm
java:/TransactionManager