How to connect to a DataSource from a remote client?

Written by F.Marchioni

JBoss recipe of the day
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>

JBoss.org Search

Custom Search

Comments

Only registered users can write comments!

How to avoid the 50 seconds start up limit in Eclipse ?

How can you solve deployment errors caused by large war/jar/ear files ?

How do you configure your .war to be deployed after your EJB ?

3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."