Re: ASKING AGAIN: problem in getting database connection from rem ote machine using JNDI

[Jan Pernica]

In your deploy XML you should have somethink like this:
 <ResourceLink global="jdbc/global" name="jdbc/myApp" 
type="javax.xml.DataSource"/>

Where jdbc/global is defined in the Data Sources of the tomcat server.

Jan

rahul wrote:

I am still not been able to use remote database,
even after including <resource-ref> in my web.xml



 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 25, 2005 1:48 PM
To: users@tomcat.apache.org
Subject: RE: ASKING AGAIN: problem in getting database connection from
rem ote machine using JNDI


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-h
owto.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]


   




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]