Subject Problem getting Connection
Author Prabhakar Krishnaswami

I am trying to configure firebird with JBoss 3.0x. I got a copy of the firebird-service.xml from the distribution and modified the URL and JndiName attribute. When JBoss comes up, I get the following error:

 

 

08:53:06,896 FATAL [StackTrace] java.sql.SQLException: Problem getting connectio

n: javax.resource.ResourceException: Connection string missing

        at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:83)

 

        at com.dynix.util.DBConnection.getDBConnection(DBConnection.java:111)

        at com.dynix.hip.util.InitWizard.runWizard(InitWizard.java:189)

        at com.dynix.hip.ContextListener.startService(ContextListener.java:131)

        at com.dynix.hip.ContextListener.contextInitialized(ContextListener.java

:77)

        at org.mortbay.jetty.servlet.WebApplicationContext.start(WebApplicationC

ontext.java:480)

        at org.mortbay.j2ee.J2EEWebApplicationContext.start(J2EEWebApplicationCo

ntext.java:85)

        at org.jboss.jetty.Jetty.deploy(Jetty.java:368)

        at org.jboss.jetty.JettyService.performDeploy(JettyService.java:249)

        at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:30

0)

        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:814)

        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:806)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:627)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:591)

        at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

 

Here is the section of service.xml which does the configuration:

 

<depends optional-attribute-name="ManagedConnectionFactoryName">

      <mbean code="org.jboss.resource.connectionmanager.RARDeployment" name="jboss.jca:service=XaTxDS,name=FirebirdDS">

        <!--more hack-->

        <depends optional-attribute-name="OldRarDeployment">jboss.jca:service=RARDeployment,name=Firebird Database Connector</depends>

        <attribute name="ManagedConnectionFactoryProperties">

          <properties>

           <connection-url>jdbc:firebirdsql://localhost:3050/D:/projects/hip_thunder/etc/config/ipacadminuni.gdb</connection-url>

 

            <config-property name="TransactionIsolationName" type="java.lang.String">TRANSACTION_REPEATABLE_READ</config-property>

            <config-property name="Encoding" type="java.lang.String">UNICODE_FSS</config-property>

            <config-property name="BlobBufferLength" type="int">4096</config-property>

 

            <config-property name="UserName" type="java.lang.String">Sysdba</config-property>

            <config-property name="Password" type="java.lang.String">masterkey</config-property>

 

          </properties>

        </attribute>

      

        <attribute name="JndiName">ipac_admin</attribute>

      </mbean>

 

Could somebody tell me what’s wrong with my configuration?

 

Prabhakar Krishnaswami

Software Engineer

 

Dynix

pkrishnaswami@...

p 801-223-5817

f  801-223-5202

www.dynix.com