Advertise with us

Our eBooks

How to connect to a DataSource from a remote client?

 

If you want to connect to your JBoss Connection Pool from a remote client ( that is a client that is not deployed on JBoss) you need to tell JBoss NOT to bind the Datasource under the "java:/"
namespace.
As a matter of fact this restricts the lookup to the same VM as the JBoss server.

Simply use tag <use-java-context>false</use-java-context> in your -ds.xml file

This is a sample Datasource file for mysql configured to accept remote client access

 <datasources>
      <local-tx-datasource>
        <jndi-name>MySqlDS</jndi-name>
        <use-java-context>false</use-java-context>
        <connection-url>jdbc:mysql://mysql-hostname:3306/jbossdb
        </connection-url>
        <driver-class>com.mysql.jdbc.Driver</driver-class>
        <user-name>x</user-name>
        <password>y</password>

          <metadata>
             <type-mapping>mySQL</type-mapping>
          </metadata>
      </local-tx-datasource>

    </datasources>

 

© 2021 mastertheboss.com. All Rights Reserved.

Please publish modules in offcanvas position.