RE: Help getting MySQL connected to Tomcat

2008-02-25 Thread Lessie Z. Mitch
24, 2008 5:10 AM To: Tomcat Users List Subject: Re: Help getting MySQL connected to Tomcat java.net.ConnectException: Connection refused: connect Some distributions of mysql configure it by default to use named pipes w/o a port listening at 3306. It's mainly for security reasons, but can

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread David Smith
java.net.ConnectException: Connection refused: connect Some distributions of mysql configure it by default to use named pipes w/o a port listening at 3306. It's mainly for security reasons, but can be a real PITA when your application requires a TCP/IP port. Check the parameters MySQL was

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Lessie, Lessie Z. Mitch wrote: | url=jdbc:mysql://localhost:3306/javatest?autoReconnect=true Don't use autoReconnect=true... that parameter has been deprecated for years, and the effect is better achieved by using testOnBorrow=true along with

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin, [EMAIL PROTECTED] wrote: | I've tried following the directions from the tomcat dist and from the | mysql dist but I always get can't connect exceptions when I start tomcat. Connection refused usually means that everything is configured

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread Martin Gainty
Hi Kevin- is there a MySQL listener installed on port 3306..you can verify with netstat -a | grep 3306? If so can you connect using mySQL client? M- - Original Message - From: [EMAIL PROTECTED] To: users@tomcat.apache.org Sent: Saturday, February 23, 2008 9:00 PM Subject: Help getting

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread kevin
Users List users@tomcat.apache.org Sent: Sunday, February 24, 2008 8:06 AM Subject: Re: Help getting MySQL connected to Tomcat -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin, [EMAIL PROTECTED] wrote: | I've tried following the directions from the tomcat dist and from the | mysql dist but I

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread Alan Chaney
[EMAIL PROTECTED] wrote: Thanks for the help. I still don't have this working completely, but tomcat is now working. I tested mysql and it is using tcp/ip. mysql -h 127.0.0.1 -u javauser -p works fine. Also the MSQLAdmin program shows it is connecting to the correct port 3306

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread kevin
- From: Alan Chaney [EMAIL PROTECTED] To: Tomcat Users List users@tomcat.apache.org Sent: Sunday, February 24, 2008 9:11 AM Subject: Re: Help getting MySQL connected to Tomcat [EMAIL PROTECTED] wrote: Thanks for the help. I still don't have this working completely, but tomcat is now

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin, [EMAIL PROTECTED] wrote: | I tested mysql and it is using tcp/ip. mysql -h 127.0.0.1 -u javauser | -p works fine. | Also the MSQLAdmin program shows it is connecting to the correct port 3306 Okay, good. Any software firewalls enabled? The

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread kevin
: Sunday, February 24, 2008 1:30 PM Subject: Re: Help getting MySQL connected to Tomcat -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin, [EMAIL PROTECTED] wrote: | I tested mysql and it is using tcp/ip. mysql -h 127.0.0.1 -u javauser | -p works fine. | Also the MSQLAdmin program shows

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin, [EMAIL PROTECTED] wrote: | Now for the issue at hand. I turned off my Windows firewall and this did | not fix the issue. Yeah, that was unlikely to change anything. Make sure you turn that back on! | I implemented the resource as you

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread Hassan Schroeder
On Sun, Feb 24, 2008 at 2:59 PM, [EMAIL PROTECTED] wrote: I implemented the resource as you suggested (short hand method as follows): WEB-INF\context.xml for the app now has Is that a typo or really what you did? Your webapp's context.xml goes in META-INF/ , not WEB-INF/ ... -- Hassan

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread kevin
users@tomcat.apache.org Sent: Sunday, February 24, 2008 1:30 PM Subject: Re: Help getting MySQL connected to Tomcat -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin, [EMAIL PROTECTED] wrote: | I tested mysql and it is using tcp/ip. mysql -h 127.0.0.1 -u javauser | -p works fine. | Also

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread kevin
, February 24, 2008 4:14 PM Subject: Re: Help getting MySQL connected to Tomcat On Sun, Feb 24, 2008 at 2:59 PM, [EMAIL PROTECTED] wrote: I implemented the resource as you suggested (short hand method as follows): WEB-INF\context.xml for the app now has Is that a typo or really what you

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread kevin
learned, always rebuild war and redeploy. Thanks for all the help! Kevin - Original Message - From: [EMAIL PROTECTED] To: Tomcat Users List users@tomcat.apache.org Sent: Sunday, February 24, 2008 4:35 PM Subject: Re: Help getting MySQL connected to Tomcat Are you sure? I thought

RE: Help getting MySQL connected to Tomcat

2008-02-23 Thread Lessie Z. Mitch
Try: url=jdbc:mysql://localhost:3306/javatest?autoReconnect=true ~LZM~ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, February 23, 2008 4:01 PM To: users@tomcat.apache.org Subject: Help getting MySQL connected to Tomcat Hello, I'm trying to get