RE: Database connection pooling in Tomcat 5.5

I have a datasource defined similar to yours I get this error when I try to use ds.getConnection("username", "password"); but if I just use ds.getConnection(); it works fine. -Sameer Darren Hall <[EMAIL PROTECTED]> wrote: Is there any other information I can supply to help people help me unde

Re: Database connection pooling in Tomcat 5.5

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'" Sent: Tuesday, September 19, 2006 2:56 PM Subject: RE: Database connection p

RE: Database connection pooling in Tomcat 5.5

> Which is why I suggested Ethereal to see what was really going over the > wire between your Windows box and the DB machine. Yep. I think you're right. I'll get that set up and take a look. Be back in a while. Thanks for the help.

RE: Database connection pooling in Tomcat 5.5

> From: Darren Hall [mailto:[EMAIL PROTECTED] > Subject: RE: Database connection pooling in Tomcat 5.5 > > I don't know where to go from here. I'm stumped. Which is why I suggested Ethereal to see what was really going over the wire between your Windows box and the DB mac

RE: Database connection pooling in Tomcat 5.5

> They are, you just don't know it. From the doc: > > "These libraries are located in a single JAR at > $CATALINA_HOME/common/lib/naming-factory-dbcp.jar. Gotcha. Thanks, Chuck. The naming-factory-dbcp.jar is in my /commons/lib dir. The bizarre thing about all of this is that A) I can connect

Re: Database connection pooling in Tomcat 5.5

Don't think so you need the commons-*.jar files. Tomcat 5.5 refactored the commons-dbcp package internally so it wouldn't collide with webapps using the release version from http://jakarta.apache.org/commons/dbcp. I don't have those and I've been using mysql without issue. --David Darren Hal

RE: Database connection pooling in Tomcat 5.5

> From: Darren Hall [mailto:[EMAIL PROTECTED] > Subject: RE: Database connection pooling in Tomcat 5.5 > > > make SURE commons-pooling.jar, commons-dbcp.jar and > > commons-collections.jar are in your ./WEB-INF/lib folder > > None of these jar files are in either m

RE: Database connection pooling in Tomcat 5.5

(In reverse order) > have you used a DB utility such as tora/toad/sqlplus to successfully > authenticate to your Database with the values for username and password? Yes > Inside struts-config.xml can you show us what you have supplied for each > value associated with the following properties >

RE: Database connection pooling in Tomcat 5.5

> From: Darren Hall [mailto:[EMAIL PROTECTED] > Subject: RE: Database connection pooling in Tomcat 5.5 > > Well, yes and no. I've actually hard coded the username and > password into my code when I've tested *not* using connection > pooling, so I know what they are i

RE: Database connection pooling in Tomcat 5.5

> did you try printing out the username and password variables to see what > credentials are coming through? Well, yes and no. I've actually hard coded the username and password into my code when I've tested *not* using connection pooling, so I know what they are in that case. When using connecti

Re: Database connection pooling in Tomcat 5.5

uesday, 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

RE: Database connection pooling in Tomcat 5.5

did you try printing out the username and password variables to see what credentials are coming through? -Original Message- From: Darren Hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 1:37 PM To: 'Tomcat Users List' Subject: RE: Database connection pooling in

RE: Database connection pooling in Tomcat 5.5

> That SQL Nested Exception thing in general looks like the root cause...any > way to try going to the DOS prompt and connecting to SQL Plus with that > username/pwd combo? Yes, using that username and password works fine through SQL Plus, and I've connected to the database several times through

RE: Database connection pooling in Tomcat 5.5

st' 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

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

RE: Database connection pooling in Tomcat 5.5

: Darren Hall [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 11:53 AM To: 'Tomcat Users List' Subject: RE: Database connection pooling in Tomcat 5.5 More progress with this issue. It seems that on our development server (solaris box running solaris 10) the connection pool connect

RE: Database connection pooling in Tomcat 5.5

More progress with this issue. It seems that on our development server (solaris box running solaris 10) the connection pool connects properly. However on my local box (a Windows XP SP2 box where I'm doing my development before I move it to dev) the connection pool returns to me an "invalid username

Re: Database connection pooling in Tomcat 5.5

List" Sent: Tuesday, September 19, 2006 10:27 AM Subject: Re: Database connection pooling in Tomcat 5.5 > As the subject title implies, we are looking at 5.5. In 5.5, the > parameters on a resource are expressed as attributes on the Resource > element. > > --David > > Mar

Re: Database connection pooling in Tomcat 5.5

OTECTED]> To: "'Tomcat Users List'" Sent: Tuesday, September 19, 2006 9:24 AM Subject: RE: Database connection pooling in Tomcat 5.5 Have you tried username="myuserid" password="mypassword" instead username="(myuserid)" password="(mypassword

RE: Database connection pooling in Tomcat 5.5

> can you print the contents of context.xml? Absolutely Martin, The parameters are there, but they are included as attributes instead of contained as the body of an element. I'm not sure if this matters or not, but I have it implemented a way I saw it done in a "JNDI Datasource How-To" on Apache'

Re: Database connection pooling in Tomcat 5.5

message without making a copy. Thank you. - Original Message - From: "Darren Hall" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" Sent: Tuesday, September 19, 2006 9:24 AM Subject: RE: Database connection pooling in Tomcat 5.5 >> Have

Re: Database connection pooling in Tomcat 5.5

Hi Darren, See below for some code that I recently sent to the list in relation to this problem. It helped with the other person, might work for you too. Regards, Martin -- // fragment from web.xml DB Connection jdbc/dbname javax.sql.DataSource Container // context.xml prefix

RE: Database connection pooling in Tomcat 5.5

> Have you tried > username="myuserid" password="mypassword" > instead username="(myuserid)" password="(mypassword)" Yes Jean-Claude. In fact, I don't use the parenthesis around the username and password in my context.xml file. I just listed it that way here in the list so people would understand

RE: Database connection pooling in Tomcat 5.5

Sorry, I do not use oracle, so I cannot say what is right. Doug - Original Message - From: "Darren Hall" To: "'Tomcat Users List'" Sent: Monday, September 18, 2006 4:38 PM Subject: RE: Database connection pooling in Tomcat 5.5 Further progress... When I co

RE: Database connection pooling in Tomcat 5.5

--- Darren Hall <[EMAIL PROTECTED]> wrote: > Further progress... > When I connect to the database directly (not using a > connection pool) and > specify the same username and password below, the > code executes fine. When I > try to do the context lookup and connect to the > database via the conne

Re: Database connection pooling in Tomcat 5.5

Doug - Original Message - From: "Darren Hall" To: "'Tomcat Users List'" Sent: Monday, September 18, 2006 4:38 PM Subject: RE: Database connection pooling in Tomcat 5.5 Further progress... When I connect to the database directly (not using a connection poo

Re: Database connection pooling in Tomcat 5.5

. Sorry, I do not use oracle, so I cannot say what is right. Doug - Original Message - From: "Darren Hall" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" Sent: Monday, September 18, 2006 4:38 PM Subject: RE: Database connection pooling in Tomcat 5.5 F

RE: Database connection pooling in Tomcat 5.5

ubject: RE: Database connection pooling in Tomcat 5.5 > You are likely connecting to the wrong catalog. Is the pool parameter > defaultCatalog set? That's specified in my Context, correct? If so, then no, I don't have my defaultCatalog parameter set. Here is my context.xml file (comments

Re: Database connection pooling in Tomcat 5.5

Inidcations are from the exception, the config on your end is working and it's actually attempting to get a connection, but the login fails. Have you tried using the client software from the machine tomcat is on, using the same tcp/ip url and parameters tomcat is using? Are there any logs on

RE: Database connection pooling in Tomcat 5.5

Is there any other information I can supply to help people help me understand why I'm getting this error (below)? > I've made some progress on this. I'm now receiving a "SQLNestedException: > Cannot create PoolableConnectionFactory" error when calling getConnection > on the DataSource object ret

RE: Database connection pooling in Tomcat 5.5

> You are likely connecting to the wrong catalog. Is the pool parameter > defaultCatalog set? That's specified in my Context, correct? If so, then no, I don't have my defaultCatalog parameter set. Here is my context.xml file (comments removed, as well as domain uname and passwd)

RE: Database connection pooling in Tomcat 5.5

You are likely connecting to the wrong catalog. Is the pool parameter defaultCatalog set? -Original Message- From: Darren Hall [mailto:[EMAIL PROTECTED] Sent: Monday, September 18, 2006 2:00 PM To: 'Tomcat Users List' Subject: RE: Database connection pooling in Tomcat

RE: Database connection pooling in Tomcat 5.5

I've made some progress on this. I'm now receiving a "SQLNestedException: Cannot create PoolableConnectionFactory" error when calling getConnection on the DataSource object retrieved from my connection pool. Here is the satck trace: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create Po

RE: Database connection pooling in Tomcat 5.5

onday, September 18, 2006 12:31 PM To: 'Tomcat Users List' Subject: RE: Database connection pooling in Tomcat 5.5 The issue could be the path attribute or docbase attribute in the context.xml. I'm not sure what values should appear for these. -Original Message- From: Darren

RE: Database connection pooling in Tomcat 5.5

ist Subject: Re: Database connection pooling in Tomcat 5.5 post your context.xml Darren Hall wrote: > Hi all. > > > > I'm attempting to set up database connection pool using Tomcat 5.5 and > Oracle 10g. I've been following the "JNDI How To" guide from A

RE: Database connection pooling in Tomcat 5.5

D] Sent: Monday, September 18, 2006 11:30 AM To: Tomcat Users List Subject: Re: Database connection pooling in Tomcat 5.5 Do you include a in your WEB-INF/web.xml file? You might also want to post your web.xml Pid wrote: > post your context.xml > > > > > Darren Hall wrote: &g

Re: Database connection pooling in Tomcat 5.5

Do you include a in your WEB-INF/web.xml file? You might also want to post your web.xml Pid wrote: post your context.xml Darren Hall wrote: Hi all. I'm attempting to set up database connection pool using Tomcat 5.5 and Oracle 10g. I've been following the "JNDI How To" guide from Apa

RE: Database connection pooling in Tomcat 5.5

pooling in Tomcat 5.5 post your context.xml Darren Hall wrote: > Hi all. > > > > I'm attempting to set up database connection pool using Tomcat 5.5 and > Oracle 10g. I've been following the "JNDI How To" guide from Apache > (http://tomcat.apache.or

Re: Database connection pooling in Tomcat 5.5

post your context.xml Darren Hall wrote: > Hi all. > > > > I'm attempting to set up database connection pool using Tomcat 5.5 and > Oracle 10g. I've been following the "JNDI How To" guide from Apache > (http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html > ). My ques

Database connection pooling in Tomcat 5.5

Hi all. I'm attempting to set up database connection pool using Tomcat 5.5 and Oracle 10g. I've been following the "JNDI How To" guide from Apache (http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html ). My question is - where should I define the connection pool resource?