Dashbuilder doesn't seem to support Firebird out of the box. See
https://github.com/droolsjbpm/dashboard-builder/blob/master/modules/dashboard-commons/src/main/java/org/jboss/dashboard/database/hibernate/HibernateInitializer.java

I suggest you file a ticket with them to ask them to add Firebird support.

Mark

On 19-5-2016 19:07, lfeliz@... [Firebird-Java] wrote:
> 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&
> lt;/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>
> </st atement>
> </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.
> < /div>
>
>
>
>


--
Mark Rotteveel