I dont know if it is required, but do you have a resource-ref entry in your web.xml, something like this?
<resource-ref> <description>mySQL Datasource</description> <res-ref-name>jdbc/myAPP</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> where res-ref-name has to be the same as in context.xml. And perhaps your look-up-name might not be correct, but I am not sure because I am using PostrgreSQL databse. http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html might help you out. -----Ursprüngliche Nachricht----- Von: rahul [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. Oktober 2005 06:33 An: Tomcat Users List Betreff: ASKING AGAIN: problem in getting database connection from remote machine using JNDI 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
