RE: DB configuration and socket error
From: Propes, Barry L [mailto:barry.l.pro...@citi.com] Subject: DB configuration and socket error I'm trying to connect to a second one (different context info and credentials) in the midwest. Regions aside, for simple connectivity testing purposes at the moment, I'm not worrying about the context.xml info - I'll address that later. What's in your webapp's Context element (or rather the nested Resource element therein) may well be the problem. Post that, and we'll see if we can help. - 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
RE: DB configuration and socket error
I will send that on shortly, but if I'm just trying to pass basic params (for the DB conn) through the JSP, wouldn't it be ignoring the context.xml info? If I'm not referencing it? (I commented it out for the short term). -Original Message- From: Caldarale, Charles R [mailto:chuck.caldar...@unisys.com] Sent: Friday, August 13, 2010 3:14 PM To: Tomcat Users List Subject: RE: DB configuration and socket error From: Propes, Barry L [mailto:barry.l.pro...@citi.com] Subject: DB configuration and socket error I'm trying to connect to a second one (different context info and credentials) in the midwest. Regions aside, for simple connectivity testing purposes at the moment, I'm not worrying about the context.xml info - I'll address that later. What's in your webapp's Context element (or rather the nested Resource element therein) may well be the problem. Post that, and we'll see if we can help. - 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
RE: DB configuration and socket error
From: Propes, Barry L [mailto:barry.l.pro...@citi.com] Subject: RE: DB configuration and socket error I will send that on shortly, but if I'm just trying to pass basic params (for the DB conn) through the JSP, wouldn't it be ignoring the context.xml info? There's clearly an attempt to establish a connection to the DB; if the credentials or other attributes are incorrect, the attempt will fail - that's what we're seeing in the stack trace. What's triggering the connection attempt is visible in the stack trace. - 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
RE: DB configuration and socket error
I also did a thread dump with some info -- should I include that in a reply? -Original Message- From: Caldarale, Charles R [mailto:chuck.caldar...@unisys.com] Sent: Friday, August 13, 2010 3:43 PM To: Tomcat Users List Subject: RE: DB configuration and socket error From: Propes, Barry L [mailto:barry.l.pro...@citi.com] Subject: RE: DB configuration and socket error I will send that on shortly, but if I'm just trying to pass basic params (for the DB conn) through the JSP, wouldn't it be ignoring the context.xml info? There's clearly an attempt to establish a connection to the DB; if the credentials or other attributes are incorrect, the attempt will fail - that's what we're seeing in the stack trace. What's triggering the connection attempt is visible in the stack trace. - 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
RE: DB configuration and socket error
From: Propes, Barry L [mailto:barry.l.pro...@citi.com] Subject: RE: DB configuration and socket error I also did a thread dump with some info -- should I include that in a reply? Probably not necessary. - 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
Re: DB configuration and socket error
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Barry, On 8/13/2010 4:07 PM, Propes, Barry L wrote: ug 13, 2010 2:58:03 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet jsp threw exception java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169870336)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4 Does Oracle have any information on what error 12505 means? If you're calling DriverManager.getConnection() and passing a URL plus username and password, then Tomcat has nothing at all to do with this, unless you're running under a SecurityManager, in which case you'd be getting SecurityExceptions also. That doesn't necessarily mean we can't help. It just makes it off-topic ;) - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkxluPkACgkQ9CaO5/Lv0PApbQCfUoCMQXlVedNxRBPPGA8pbADO jgIAoJu3c/4nMjWFCgO8/rIXRaXQvZwt =efLQ -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: DB configuration and socket error
Yeah, sorry, Chris...it probably is moreso Oracle related in nature than Tomcat. I just thought I'd make sure about that before I addressed it with the one set of Oracle personnel in the midwest location. I'm hardly an Oracle expert, but the only difference to my knowledge on these two different servers is that one is on an HP Solaris and the other running on an IBM AIX, I think it is. They have different types of auditing software, but nothing that should specifically inhibit connectivity like this. I'll try to address it on Oracle's forum and see if anyone can shed light on the 12505 error. Thanks! -Original Message- From: Christopher Schultz [mailto:ch...@christopherschultz.net] Sent: Friday, August 13, 2010 4:28 PM To: Tomcat Users List Subject: Re: DB configuration and socket error -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Barry, On 8/13/2010 4:07 PM, Propes, Barry L wrote: ug 13, 2010 2:58:03 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet jsp threw exception java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169870336)(ERR=12505)(ERROR_STACK=(E RROR=(CODE=12505)(EMFI=4 Does Oracle have any information on what error 12505 means? If you're calling DriverManager.getConnection() and passing a URL plus username and password, then Tomcat has nothing at all to do with this, unless you're running under a SecurityManager, in which case you'd be getting SecurityExceptions also. That doesn't necessarily mean we can't help. It just makes it off-topic ;) - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkxluPkACgkQ9CaO5/Lv0PApbQCfUoCMQXlVedNxRBPPGA8pbADO jgIAoJu3c/4nMjWFCgO8/rIXRaXQvZwt =efLQ -END PGP SIGNATURE- - 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
RE: DB configuration and socket error
BTW, Chris, I did happen to be calling DriverManager.getConnection() passing the user/pwd params -- in this instance. And 12505, according to the Oracle forums, seems to be some kind of listener problem. I had reckoned that the problem might be with their (the midwest center's) Oracle server's ports, and what its server would allow, or be listening to. Seemed to make sense to me since I could get an ODBC conn via MS Acces and that Ora driver, as well as TNSPING it from the machine in question making the call. I'm likely going off topic greatly with this, so forgive me if that's the case, but if anyone can affirm this, that's also very helpful. Thanks, folks! Barry -Original Message- From: Christopher Schultz [mailto:ch...@christopherschultz.net] Sent: Friday, August 13, 2010 4:28 PM To: Tomcat Users List Subject: Re: DB configuration and socket error -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Barry, On 8/13/2010 4:07 PM, Propes, Barry L wrote: ug 13, 2010 2:58:03 PM org.apache.catalina.core.StandardWrapperValve invoke SEVERE: Servlet.service() for servlet jsp threw exception java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169870336)(ERR=12505)(ERROR_STACK=(E RROR=(CODE=12505)(EMFI=4 Does Oracle have any information on what error 12505 means? If you're calling DriverManager.getConnection() and passing a URL plus username and password, then Tomcat has nothing at all to do with this, unless you're running under a SecurityManager, in which case you'd be getting SecurityExceptions also. That doesn't necessarily mean we can't help. It just makes it off-topic ;) - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkxluPkACgkQ9CaO5/Lv0PApbQCfUoCMQXlVedNxRBPPGA8pbADO jgIAoJu3c/4nMjWFCgO8/rIXRaXQvZwt =efLQ -END PGP SIGNATURE- - 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