2 Replies Latest reply on Oct 7, 2003 3:21 PM by Benjamin Walstrum

    === Firebird problem with JBoss 3.2.1 ===

    Dobri Newbie

      Hi!

      I have the following problem.
      I have the following firebird-ds.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 -->
      <!-- ==================================================================== -->

      <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. -->

      192.168.168.10:D:/Exchange/temp_ml/HD2.gdb
      SYSDBA
      masterkey
      true
      false


      <tx-connection-factory>

      <jndi-name>FirebirdDS</jndi-name>

      <xa-transaction/>

      <adapter-display-name>Firebird Database Connector</adapter-display-name>

      <config-property name="Database" type="java.lang.String">192.168.168.10:D:/Exchange/temp_ml/HD2.gdb</config-property>

      <user-name>sysdba</user-name>

      masterkey

      <!--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>
      </tx-connection-factory>

      </connection-factories>

      Also I have added the firebirdsql.jar driver in D:\jboss-3.2.1\server\default\lib

      But when I start the jboss I see (my db is on a remote comp with IP: 192.168.168.10):

      11:31:19,294 WARN [ServiceController] Problem starting service jboss.jca:service=FirebirdManager
      org.firebirdsql.gds.GDSException: Unable to complete network request to host "localhost".
      at org.firebirdsql.jgds.GDS_Impl.connect(GDS_Impl.java:1602)
      at org.firebirdsql.jgds.GDS_Impl.isc_create_database(GDS_Impl.java:202)
      at org.firebirdsql.management.FBManager.createDatabase(FBManager.java:375)
      at org.firebirdsql.management.FBManager.start(FBManager.java:92)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
      at $Proxy11.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:392)
      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy5.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:177)
      at $Proxy16.start(Unknown Source)
      at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:231)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:640)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:613)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy7.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:200)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:273)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:392)
      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy5.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:832)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:640)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:613)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:597)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
      at $Proxy6.deploy(Unknown Source)
      at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:365)
      at org.jboss.system.server.ServerImpl.start(ServerImpl.java:272)
      at org.jboss.Main.boot(Main.java:150)
      at org.jboss.Main$1.run(Main.java:388)
      at java.lang.Thread.run(Thread.java:534)


      And at the bottom of the console I see

      11:31:28,966 INFO [MainDeployer] Deployed package: file:/D:/jboss-3.2.1/server/default/deploy/management/
      11:31:28,966 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
      Cause: Incomplete Deployment listing:
      Packages waiting for a deployer:

      Incompletely deployed packages:

      MBeans waiting for classes:

      MBeans waiting for other MBeans:
      [ObjectName: jboss.jca:service=FirebirdManager
      state: FAILED
      I Depend On:
      Depends On Me: org.firebirdsql.gds.GDSException: Unable to complete network request to host "localhost"., ObjectName: jboss.jca:s
      ervice=TxCM,name=FirebirdDS
      state: CONFIGURED
      I Depend On: jboss.jca:service=ManagedConnectionPool,name=FirebirdDS
      jboss.jca:service=CachedConnectionManager
      jboss:service=TransactionManager

      Depends On Me: , ObjectName: jboss.jca:service=ManagedConnectionPool,name=FirebirdDS
      state: CONFIGURED
      I Depend On: jboss.jca:service=ManagedConnectionFactory,name=FirebirdDS

      Depends On Me: jboss.jca:service=TxCM,name=FirebirdDS
      , ObjectName: jboss.jca:service=ManagedConnectionFactory,name=FirebirdDS
      state: CONFIGURED
      I Depend On: jboss.jca:service=RARDeployment,name=Firebird Database Connector

      Depends On Me: jboss.jca:service=ManagedConnectionPool,name=FirebirdDS


      Where is the problem. Is it because firbird-ds.xml is miswritten?

      Thank you

        • 1. Re: === Firebird problem with JBoss 3.2.1 ===
          Adrian Brock Master

          Ask the firebird people why it is trying to connect to
          localhost when you specified a different ip address.

          Maybe you don't specify it that way?

          Regards,
          Adrian

          • 2. Re: === Firebird problem with JBoss 3.2.1 ===
            Benjamin Walstrum Newbie

            I think that at least part of the problem may stem from the way your URL is formed. While it looks correct, it may be causing Jaybird (the Firebird driver) to not pick up the correct values. The URL (when specified in this manner) is a little bit different than a standard JDBC connection URL. It is of the form:

            [SERVER_IP]/[SERVER_PORT]:[PATH_TO_DB]

            The default port for Firebird is 3050, so your URL should most likely look like this:

            192.168.168.10/3050:D:/Exchange/temp_ml/HD2.gdb

            Also, I'm not sure why you have the mbean declared in your file. In my configuration I never needed that part. You should be able to start with just the <tx-connection-factory> section.

            I am not 100% certain that making these changes will solve your problem, but your file will look very similar to mine (which works fine) when you do.

            Regards,

            Ben