Is there anything else that is required for remote database?
> -----Original Message----- > From: rahul [mailto:[EMAIL PROTECTED] > Sent: Monday, October 24, 2005 7:56 PM > To: Tomcat Users List > Subject: problem in getting database connection from remote machine > using JNDI > > > 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 > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
