Subject Re: [Firebird-Java] Firebird JAybird and Wildfly 8.2 (JBoss)
Author
Post date 2016-05-19T17:07:51Z
Hello,

The application I am attempting to use with FirebirdSQL via Wildfly 8.2 JBOSS AS is  is Dashbuilder  (http://www.dashbuilder.org/)


I installed  jaybird driver after succesfully installing Postgres and MS SQL driver.

I setup a folder  C:\Server\wildfly-8.2.1\modules\system\layers\base\org\firebirdsql\main


copied in the jaybird-2.2.10.jar  file (not the full jar)
 

module.xml
<?xml version="1.0" encoding="UTF-8"?>
<module xmlns="urn:jboss:module:1.3" name="org.firebirdsql">
    <resources>
        <resource-root path="jaybird-2.2.10.jar"/>
    </resources>

    <dependencies>
        <module name="javax.api"/>
<module name = "javax.resource.api"/>
        <module name="javax.transaction.api"/>
    </dependencies>
</module>

I am running the STandlone.bat  so I edit the standalone.xml config file adding the driver to drivers section

<driver name="firebirdsql" module="org.firebirdsql">
                        <driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
                        <xa-datasource-class>org.firebirdsql.ds.FBXADataSource</xa-datasource-class>
                    </driver>

Then added   a datasource

                <datasource jta="false" jndi-name="java:/krmriskinfo" pool-name="krmriskinfo" enabled="true" use-ccm="false">
                    <connection-url>jdbc:firebirdsql://server:3050/RSKINFO</connection-url>
                    <driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
                    <connection-property name="charset">
                        UTF8
                    </connection-property>
                    <driver>firebirdsql</driver>
                    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                    <security>
                        <user-name>SYSDBA</user-name>
                        <password>masterkey</password>
                    </security>
                    <validation>
                        <validate-on-match>false</validate-on-match>
                        <background-validation>false</background-validation>
                    </validation>
                    <timeout>
                        <set-tx-query-timeout>false</set-tx-query-timeout>
                        <blocking-timeout-millis>0</blocking-timeout-millis>
                        <idle-timeout-minutes>0</idle-timeout-minutes>
                        <query-timeout>0</query-timeout>
                        <use-try-lock>0</use-try-lock>
                        <allocation-retry>0</allocation-retry>
                        <allocation-retry-wait-millis>0</allocation-retry-wait-millis>
                    </timeout>
                    <statement>
                        <share-prepared-statements>false</share-prepared-statements>
                    </statement>
                </datasource>

I restarted the Wildfly server (batch file).  Logged into conosole  made sure the datasource was enabled and did a test connect and it was succesful.


 I follow steps to setup datasource in Dashbuilder and I get the error from Wildfly Log

2016-05-17 10:11:05,173 ERROR [org.jboss.dashboard.database. hibernate. HibernateInitializer] (default task-51) The underlying database code [firebird 1.55li] is not supported.
2016-05-17 10:11:05,185 ERROR [org.jboss.dashboard.dataset. sql.SQLDataSet] (default task-51) Error in load() SQLDataset. SQL = null: java.lang.NullPointerException


I tried with newer version of Firebrid SQL and similar error
2016-05-13 16:01:21,372 ERROR [org.jboss.dashboard.database.hibernate.HibernateInitializer] (default task-10) The underlying database code [firebird 2.1.wi] is not supported.
2016-05-13 16:01:21,383 ERROR [org.jboss.dashboard.dataset.sql.SQLDataSet] (default task-10) Error in load() SQLDataset. SQL = null: java.lang.NullPointerException


FYI  I repeated steps using a Postgres datasource  witha copy of data punmped into Postgres and I can connect and create datasource in Dashbuilder.   I really want to get Firebird working with this as I have a an application with lots of information.