Finally I figured out the problem Actually the context file which tomcat creates for every application in conf/<engine>/<application> folder was not getting updated. It was having the localhost settings instead of remote server.
After correcting this file my application is working perfectly. Thanks for the help --Rahul > -----Original Message----- > From: Hassan Schroeder [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 26, 2005 10:04 PM > To: Tomcat Users List > Subject: Re: problem in getting database connection from remote machine > using JNDI > > > rahul wrote: > > > url="jdbc:mysql://localhost:3306/myDB" removeAbandoned="true" > > > 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') > > OK, so if it's not a connection problem (which the error message > doesn't seem to indicate) I'll put my money on a case sensitivity > mismatch between 'localhost' and '192.168.5.65' :-) > > Besides any OS differences, check > mysql> show variables like '%case%'; > +------------------------+-------+ > | Variable_name | Value | > +------------------------+-------+ > | lower_case_file_system | OFF | > | lower_case_table_names | 0 | > +------------------------+-------+ > > HTH, > -- > Hassan Schroeder ----------------------------- [EMAIL PROTECTED] > Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com > > dream. code. > > > > --------------------------------------------------------------------- > 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]
