1) make SURE commons-pooling.jar, commons-dbcp.jar and commons-collections.jar are in your ./WEB-INF/lib folder 2) Inside struts-config.xml can you show us what you have supplied for each value associated with the following properties <data-source type="org.apache.commons.dbcp.BasicDataSource" key="TableName"> <set-property property="driverClassName" value=" <set-property property="url" value=" <set-property property="username" value=" <set-property property="validationQuery" value=" </source>
3) have you used a DB utility such as tora/toad/sqlplus to successfully authenticate to your Database with the values for username and password? Martin-- ********************************************************************* This email message and any files transmitted with it contain confidential information intended only for the person(s) to whom this email message is addressed. If you have received this email message in error, please notify the sender immediately by telephone or email and destroy the original message without making a copy. Thank you. ----- Original Message ----- From: "Darren Hall" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <users@tomcat.apache.org> Sent: Tuesday, September 19, 2006 2:04 PM Subject: RE: Database connection pooling in Tomcat 5.5 > does your XP box give you any application log errors anywhere? I see no errors in the event viewer in any of the logs that are related to this issue, but it was a good idea. (I didn't think of it.) > I wonder if Windows is looking for a domain authentication, that is a > domain name stapled on to the user acct prior to authenticating the user? No, there is no domain information used currently for the database connection process. Another good idea. I'll speak with my network admin and see if he believes this could be causing an issue. > Can you print out to the Tomcat logs the errors? Curiously, Tomcats logs show no errors relating to this issue. My application log is the only place where the error is caught and logged. Here is the relevant output from my log including the top of the stack trace. <flc-event-2006-09-19.log> ... 2006-09-19 13:07:44,670 DEBUG org.mydomian.labs.LaboratorySearchAction - (exeucte) Retrieving database connection from the DataSource. 2006-09-19 13:07:45,826 DEBUG org.apache.struts.util.PropertyMessageResources - getMessage(en_US,unhandledException) 2006-09-19 13:07:45,841 WARN org.apache.struts.action.RequestProcessor - Unhandled Exception thrown: class org.apache.tomcat.dbcp.dbcp.SQLNestedException 2006-09-19 13:07:45,857 ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/flc].[primar y-controller] - Servlet.service() for servlet primary-controller threw exception org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-01017: invalid username/password; logon denied ) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource .java:855) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.ja va:540) at org.mydomain.labs.LaboratorySearchAction.execute(LaboratorySearchAction.java :94) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces sor.java:431) ... --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
