problem in getting database connection from remote machine using JNDI

[rahul]

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 help?


thanks in advance
--RahulJoshi