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]
