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

    === Firebird problem with JBoss 3.2.1 ===

    dobri
    dobri Oct 7, 2003 2:47 AM

      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

      • 3415 Views
      • Tags:
        • 1. Re: === Firebird problem with JBoss 3.2.1 ===
          adrian.brock Oct 7, 2003 5:37 AM (in response to dobri)

          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

            • Actions
          • 2. Re: === Firebird problem with JBoss 3.2.1 ===
            benwalstrum
            benwalstrum Oct 7, 2003 3:21 PM (in response to dobri)

            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

              • Actions