Ok, will do...thanks for the suggestion. I'll remove that.
Thanks. -----Original Message----- From: Caldarale, Charles R [mailto:[email protected]] Sent: Friday, March 19, 2010 4:31 PM To: Tomcat Users List Subject: RE: DB connection error -Tomcat 6 config > From: Propes, Barry L [mailto:[email protected]] > Subject: RE: DB connection error -Tomcat 6 config > > javax.servlet.ServletException: > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create > PoolableConnectionFactory (ORA-00923: FROM keyword not found where > expected) I would suggest removing this from your <Resource> element: testWhileIdle="true" One normally uses testOnBorrow, and specifies a validationQuery appropriate for the DB in use. Without the validationQuery, I have no idea what the DBCP makes up to send. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. --------------------------------------------------------------------- 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]
