Ok, will do...thanks for the suggestion.

I'll remove that.

Thanks.
 

-----Original Message-----
From: Caldarale, Charles R [mailto:chuck.caldar...@unisys.com] 
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:barry.l.pro...@citi.com]
> 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: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to