Firebird in JBoss 7

[hrast200]

Hi!

Did anyone succeed in connecting Firebird DB and JBoss? I cann't get rid of

JBAS014775:	New missing/unsatisfied dependencies:
	service jboss.jdbc-driver.firebirdsql (missing) dependents: [service jboss.data-source.java:/tiranDS]

jaybird-pool-2.1.6.jar is in .....\jboss-as-7.1.0.CR1b\modules\org\firebirdsql\main

This is my standalone.xml [some parts are changed, like ...(some_path)...]

...

  <subsystem xmlns="urn:jboss:domain:datasources:1.0">

            <datasources>

                <datasource jndi-name="java:/tiranDS" pool-name="TiranPool" enabled="true" jta="true" use-java-context="true" use-ccm="true">

                    <connection-url>

                        jdbc:firebirdsql:serversp/3050:C:\Program Files\...(some_path)...\tiran.gdb

                    </connection-url>

                    <driver>

                        firebirdsql

                    </driver>

                    <pool>

                        <prefill>

                            false

                        </prefill>

                        <use-strict-min>

                            false

                        </use-strict-min>

                        <flush-strategy>

                            FailingConnectionOnly

                        </flush-strategy>

                    </pool>

                    <security>

                        <user-name>

                            username

                        </user-name>

                        <password>

                            pass

                        </password>

                    </security>

                </datasource>

                <drivers>

                   <driver name="firebirdsql" module="org.firebirdsql">

                        <xa-datasource-class>

                            org.firebirdsql.jdbc.FBDriver

                        </xa-datasource-class>

                    </driver>

                </drivers>

            </datasources>

        </subsystem>

...

module.xml looks like this (all .jars mentioned in module.xml aree in .....\jboss-as-7.1.0.CR1b\modules\org\firebirdsql\main folder)

<module xmlns="urn:jboss:module:1.0" name="org.firebirdsql">

    <resources>

        <resource-root path="jaybird-full-2.1.6.jar"/>

        <resource-root path="jaybird-pool-2.1.6.jar"/>

        <resource-root path="log4j-1.2.13.jar"/>

        <resource-root path="jboss-javaee.jar"/>

        <resource-root path="jmxri.jar"/>

        <resource-root path="jmxtools.jar"/>

        <resource-root path="sax2.jar"/>

        <resource-root path="commons-logging-1.1.jar"/>

        <resource-root path="junit-3.8.1.jar"/>

    </resources>

    <dependencies>

        <module name="javax.api"/>

        <module name="javax.activation.api"/>

        <module name="javax.xml.soap.api"/>

        <module name="javax.servlet.api"/>

        <module name="org.jboss.common-core"/>

        <module name="org.jboss.logging"/>

        <module name="javax.mail.api"/>

        <module name="org.apache.log4j"/>               

        <module name="org.jboss.logmanager.log4j"/>

        <module name="org.apache.james.mime4j"/>

        <module name="org.apache.commons.codec"/>

        <module name="org.apache.commons.collections"/>

        <module name="org.apache.commons.io"/>

        <module name="org.apache.commons.lang"/>

        <module name="org.apache.commons.logging"/>

        <module name="org.apache.httpcomponents"/>

        <module name="org.apache.xalan"/>

        <module name="org.apache.xerces"/>

        <module name="org.w3c.css.sac"/>

        <module name="net.sourceforge.cssparser"/>

        <module name="net.sourceforge.nekohtml"/>

    </dependencies>

</module>

Whati is wrong here?

[nickarls]

Tried with a path that doesn't contain spaces (the "Program files")...?

[hrast200]

Unfortunately it did'nt help.

I've tryed with admin console (localhost:9990), but tere were no helpful informations.

[roabol]

Can anyone help us? I trie change from glassfish to Jboss and I can't configure DataSource with Firebird. Please!!!

[ctomc]

Rodrigo hi,

is problem still the same as given that last post is 7 months old and there have been several releases for AS7 since then?

can you try with 7.1.1.Final and then post the problem you have.

--

tomaz

[roabol]

Thanks Tomaz,

I put the jaybird-2.2.0.jar in C:\Users\Rodrigo\Developer\Java\Server\jboss-as-7.1.1.Final\standalone\lib, and created a firebird-ds.xml in the same folder. When I try to create a DataSource the JDBC driver not appears.

I put this folder following the guidelines that says:

14.2.1. Installing the JDBC Driver and Deploying the datasource

To make the JDBC driver classes available to the JBoss Application Server, copy the archive mysql-mysql-connector-java-5.1.5-bin.jar from the Connector/J distribution to the lib directory in the default server configuration (assuming that is the server configuration you’re running).

http://docs.jboss.org/jbossas/docs/Installation_And_Getting_Started_Guide/5/html/Using_other_Databases.html#Using_MySQL_as_the_Default_DataSource-Installing_the_JDBC_Driver_and_Deploying_the_DataSource

I put the screenshot to show you:

My firebird-ds.xml

<?xml version="1.0" encoding="UTF-8"?>

<datasources>

          <local-tx-datasource>

                    <jndi-name>PortalDS</jndi-name>

                    <connection-url>jdbc:firebirdsql:locahost/3050:portal.dsv</connection-url>

                    <driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>

                    <user-name>SYSDBA</user-name>

                    <password>masterkey</password>

          </local-tx-datasource>

</datasources>

If I'm doing something wrong, I'm sorry I'm starting in jboss.

[ctomc]

Hi,

you are folowing wrong administration guide, that is for JBoss 5/EAP5 not for Jboss 7/EAP6

for configuring datasources read this: https://docs.jboss.org/author/display/AS71/DataSource+configuration

--

tomaz

[roabol]

Thanks Tomaz,

I followed the link you sent me and got.

Only to supplement this link may help in how to deploy

https://docs.jboss.org/author/display/AS71/Application+deployment

The full command I performed, just to register:

C:\Users\Rodrigo\Developer\Java\Server\jboss-as-7.1.1.Final\bin>jboss-cli.bat

You are disconnected at the moment. Type 'connect' to connect to the server or 'help' for the list of supported commands.

[disconnected /] connect

[standalone@localhost:9999 /] deploy C:\Users\Rodrigo\Developer\Java\Libraries\jdbc\Jaybird-2.2.0JDK_1.7\jaybird-2.2.0.jar --force

Thereafter the driver appears

Before I forget, there is a new version of jaybird on:

http://www.firebirdsql.org/en/news/jaybird-2-2-release-18663/

thank you very much Tomaz...

[alejojau83]

In some forums is not allowed but wanted to thanks you because you are the only person who make it work how I wanted and perfectly.