8 Replies Latest reply on May 8, 2003 2:57 AM by pshrimpton

    interbase/firebird configuration

    gustaf1

      Does anybody have experiences with configuring interbase/firebird as datasource for jboss?

      gustaf

        • 1. Re: interbase/firebird configuration
          pshrimpton

          Yes, with Firebird. What problem are you having?

          • 2. Re: interbase/firebird configuration
            simon555

            Do you tell me how to configurate firebird step by step?
            thanks.

            • 3. Re: interbase/firebird configuration
              pshrimpton

              Assuming Firebird and Jboss 3.0.x, copy the [JBOSS]\docs\examples\jca\firebird-service.xml file into your deploy directory. Download the driver (firebirdsql.rar), and copy that into your delpoy directory. In firebird-service.xml update the relevent properties to match your setup (normally just the database path/file names). Start Jboss, and you should be up and running.

              • 4. Re: interbase/firebird configuration
                simon555

                I operated following:
                I downloaded the driver(firebirdsql.jar),and copy that into [JBOSS]\server\default\deploy.
                firebird-service.xml,too.Then I changed <config-property name="Database" type="java.lang.String">[server]/3050:[path to gdb database file]</config-property> to <config-property name="Database" type="java.lang.String">[server]/3050:[d:\java\firebird\TEST2.FDB]</config-property> in firebird-service.xml.
                result:FAILDED
                How to update the relevent properties?Assuming my datasource:d:\java\firebird.
                %firebird-home% locate g:\firebird15;
                thanks!


                • 5. Re: interbase/firebird configuration
                  pshrimpton

                  Hi,

                  > I downloaded the driver(firebirdsql.jar),and copy
                  > that into [JBOSS]\server\default\deploy.

                  You need to deploy the firebirdsql.rar file, not the jar.

                  > Then I changed
                  > <config-property name="Database"
                  > type="java.lang.String">[server]/3050:[path to gdb
                  > database file]</config-property> to <config-property
                  > name="Database"
                  > type="java.lang.String">[server]/3050:[d:\java\firebird \TEST2.FDB]</config-property> in
                  > firebird-service.xml.

                  This should be

                  <config-property name="Database" type="java.lang.String">localhost/3050:d:\java\firebird \TEST2.FDB</config-property>

                  Assuming the Firebird server is running on the local machine



                  • 6. Re: interbase/firebird configuration
                    simon555

                    Hi,

                    I deployed the firebirdsql.rar(from FirebirdSql-1.0.0).
                    Update <config-property name="Database" type="java.lang.String">localhost/3050:d:\java\firebird \TEST2.FDB</config-property>

                    When I start jboss,showing

                    00:17:41,326 ERROR [URLDeploymentScanner] MBeanException:Exception in MBean
                    operation 'checkIncompleteDeployments<>'
                    Cause: Incomplete Deployment listing:
                    Packages waiting for a deployer:

                    Incompletely deployed packages:
                    [org.jboss.deployment.DeploymentInfo@3a6cc6d6 < url = file:/G:/jboss306/jboss306/
                    server/default/deploy/firebird-service.xml >
                    deployer:org.jboss.deployment.SARDeployer@15b0afd
                    status:Deployment FAILED reason:jboss.jca:service=FirebirdManager is not
                    registered.; - nested throwable:<javax.management.InstanceNotFoundException:
                    jboss.jca:service=FirebirdManager is not registered.>
                    state:FAILED
                    watch:file:/G:/jboss306/jboss306/server/default/deploy/firebird-service.xml
                    lastDeployed:1052324232725
                    lastModified:1052324232595
                    mbeans:
                    jboss.jca:service=FirebirdManager<state not available>
                    jboss.jca:service=XaTxCM,name=FirebirdDs<state not available>
                    jboss.jca:service=XaTxDs,name=FirebirdDs<state not available>
                    jboss.jca:service=XaTxpool,name=FirebirdDs<state not available>
                    ]MBeans waiting for classes:

                    MBeans waiting for classes:
                    [ObjectName:jboss.jca:service=FirebirdManager
                    state:NOTYPEINSTALLED
                    I Depend On:
                    Depend On Me:]

                    How to continue?


                    • 7. Re: interbase/firebird configuration
                      simon555

                      Hi,

                      I deployed the firebirdsql.rar(from FirebirdSql-1.0.0).
                      Update <config-property name="Database" type="java.lang.String">localhost/3050:d:\java\firebird \TEST2.FDB</config-property>

                      When I start jboss,showing

                      00:17:41,326 ERROR [URLDeploymentScanner] MBeanException:Exception in MBean
                      operation 'checkIncompleteDeployments<>'
                      Cause: Incomplete Deployment listing:
                      Packages waiting for a deployer:

                      Incompletely deployed packages:
                      [org.jboss.deployment.DeploymentInfo@3a6cc6d6 < url = file:/G:/jboss306/jboss306/
                      server/default/deploy/firebird-service.xml >
                      deployer:org.jboss.deployment.SARDeployer@15b0afd
                      status:Deployment FAILED reason:jboss.jca:service=FirebirdManager is not
                      registered.; - nested throwable:<javax.management.InstanceNotFoundException:
                      jboss.jca:service=FirebirdManager is not registered.>
                      state:FAILED
                      watch:file:/G:/jboss306/jboss306/server/default/deploy/firebird-service.xml
                      lastDeployed:1052324232725
                      lastModified:1052324232595
                      mbeans:
                      jboss.jca:service=FirebirdManager<state not available>
                      jboss.jca:service=XaTxCM,name=FirebirdDs<state not available>
                      jboss.jca:service=XaTxDs,name=FirebirdDs<state not available>
                      jboss.jca:service=XaTxpool,name=FirebirdDs<state not available>
                      ]MBeans waiting for classes:

                      MBeans waiting for classes:
                      [ObjectName:jboss.jca:service=FirebirdManager
                      state:NOTYPEINSTALLED
                      I Depend On:
                      Depend On Me:]

                      How to continue?

                      Thanks!

                      • 8. Re: interbase/firebird configuration
                        pshrimpton

                        Hi,

                        > I deployed the firebirdsql.rar(from
                        > om FirebirdSql-1.0.0).
                        > Update <config-property name="Database"
                        > type="java.lang.String">localhost/3050:d:\java\firebir
                        > \TEST2.FDB</config-property>

                        That should work.

                        > When I start jboss,showing
                        >
                        > 00:17:41,326 ERROR [URLDeploymentScanner]
                        > MBeanException:Exception in MBean
                        >deployer:org.jboss.deployment.SARDeployer@15b0afd
                        > status:Deployment FAILED
                        > D reason:jboss.jca:service=FirebirdManager is not
                        > registered.; - nested

                        Not much to worry about really. Its a load order thing, and the firebird-service is being deployed before the firebird rar.

                        If you make a small change to the firebird-service.xml file (e.g. add a space) after JBoss has started it will re-deploy correctly. Or you can comment out the FirebirdManager MBean in the xml file, if you are not using it.