Hi,

You should also check what dialect is setin the dashboard application.
If it uses JPA it should be in the persistance.xml

For hibernate a parameter that specifies database dialect is required.
If dialect is set for PostgreSQL, it is normal to get these errors.
PostgreSQL dialect in hibernate can't recognize database if your data
source is Firebird.

Also another way of installing jaybird in WildFly 8.2 is to deploy jar
file as deployment using web ui. All settings you can do from there. No
need to touch any of the xml files manually.

Once you deploy the driver it will be visible and you can create data
sources with it.

On 19.5.2016 �. 20:07 �., lfeliz@... [Firebird-Java] wrote:
>
>
> 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.
>
>


--
Doychin Bondzhev
dSoft-Bulgaria Ltd.
PowerPro - billing & provisioning solution for Service providers
PowerStor - Warehouse & POS
http://www.dsoft-bg.com/
Mobile: +359888243116


[Non-text portions of this message have been removed]