1 Reply Latest reply on Oct 9, 2016 7:14 AM by Miguel R.

    postgresql driver in domain mode is not working

    Miguel R. Newbie

      Hi everyone!

       

      I'm trying to build a JBoss infrastructure with two hosts in domain mode. In this domain, I want to use a datasource with the postgres driver as a module but it is not working as it should.

       

      I followed this steps:

       

      first I downloaded the postgres.jar I was interested in, from the official website.

      second META-INF/services/java.sql.driver added to the postgres.jar file

      third module.xml with this content:

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

      <module xmlns="urn:jboss:module:1.1" name="org.postgresql" >

          <resources>

              <resource-root path="postgresql-9.4.1207.jar" />

          </resources>

          <dependencies>

              <module name="javax.api" />

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

          </dependencies>

      </module>

       

      and postgres.jar files copied into /opt/eap/modules/system/layers/base/org/postgresql/main/. folder

      fourth ./jboss-cli.sh --connect --controller=127.0.0.1:9999

       

      fifth /profile=ha/subsystem=datasources/jdbc-driver=postgresql:add(driver-name=postgresql,driver-module-name=org.postgresql)

       

      Then I try to add a new datasource in the ha profile using the posgresql driver and I don't see the driver:

      Captura de pantalla de 2016-10-08 16-52-23.png

      Could you guys please help me?

       

      Thanks in advance.

      Regards,

      Migueu