0 Replies Latest reply on Mar 14, 2014 4:41 PM by Daniel om3

    Wildfly8: Problem when activating a Firebird Datasource by WEB Manager

    Daniel om3 Newbie

      WildFly version 8.0.0 Final running as Domain Controller

      Linux Mint 13 (based on Ubuntu 12.04 LTS)
      jre1.7-17

       

      I did deploy the jaybird-2.2.4.jar and I created a new firebird datasource using the wildfly web manager and full profile, but I don't succeed enable the new datasource, receiving an unknow error. The message is: HTTP 500 error unexpected.

       

      datasource configuration in domain.xml:

      <datasource jta="false" jndi-name="java:jboss/NameDS" pool-name="NameDS" enabled="false" use-ccm="false">
        <connection-url>jdbc:FirebirdSQL:name.serverfirebird.com.br:/path/to/database/data.fdb</connection-url>
          <driver-class>org.firebirdsql.jdbc.FBDriver</driver-class>
          <connection-property name="charSet">ISO8859-1</connection-property>
          <connection-property name="roleName">ROLE_APP</connection-property>
          <driver>jaybird-2.2.4.jar</driver>
          <security>
                 <user-name>userdb</user-name>
                 <password>passwddb</password>
          </security>
          <validation>
                 <validate-on-match>false</validate-on-match>
                 <background-validation>false</background-validation>
          </validation>
          <timeout>
                 <idle-timeout-minutes>1</idle-timeout-minutes>
          </timeout>
          <statement>
                 <share-prepared-statements>false</share-prepared-statements>
          </statement>
      </datasource>
      

      When I edited the domain.xml file and I changed to enabled="true" and restarted the WildFly, the datasource started with enabled status and I made test connection with success, however when I turn the datasource for disabled I don't turn to enable without error return. Only when I change the parameter in domain.xml file and restart the WildFly I can reactivate datasource.

       

      What I can do for create and enable a firebird datasource using the WildFly Web Manager?

       

      Daniel Dias
      Brazil