Hi all,

I am using tomcat JNDI for getting databse connection in my application

For this I have created a context.xml file in myAPP/META-INF
which looks like this:

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/myAPP" docBase="myAPP" debug="5" reloadable="true"
privileged="true" crossContext="true">
<Resource name="jdbc/myAPP" auth="Container"
 type="javax.sql.DataSource" maxActive="30" maxIdle="10"
maxWait="6000"
 username="user" password="password"
 driverClassName="com.mysql.jdbc.Driver"
 url="jdbc:mysql://localhost:3306/myDB" removeAbandoned="true"
 autoReconnect="true"
 validationQuery="select now()"
 factory="org.apache.commons.dbcp.BasicDataSourceFactory"/>
</Context>

This works absolutely fine. But when I try to connect to a remote
database by changing url in above
file to "jdbc:mysql://192.168.5.65:3306/myDB" my application fails
It creates following exception while retrieving a connection:
org.apache.tomcat.dbcp.dbcp.SQLNestedException:
Cannot create PoolableConnectionFactory (Unknown database 'myDB')

code I have written for fetching connection is:

  Context ctx = (Context) new InitialContext()
    .lookup("java:comp/env");
  if (ctx == null)
  {
   throw new Exception("No context available");
  } else
  {
   dataSource = (DataSource) ctx.lookup("jdbc/icontact");
   Connection connection = dataSource.getConnection();
  }

can anybody what else I need to configure for getting databse
connections from remote machine.

thanks in advance