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]
