RE: Help getting MySQL connected to Tomcat

2008-02-25 Thread Lessie Z. Mitch
February 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 rea

Re: Help getting MySQL connected to Tomcat

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

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread kevin
]> Sent: Sunday, 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 th

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread kevin
up. So in my example the Resource is names "jdbc/CurrencyDB" and in the java code I'm calling ctx.lookup("CurrencyDB"); Kevin - Original Message - From: "Christopher Schultz" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Sunday, Febr

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/ ... -- Hass

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 suggest

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread kevin
9) at java.lang.Thread.run(Thread.java:595) For some reason the driver manager can't get the driver even though the jar is in \common\lib ??? Thanks, Kevin - Original Message - From: "Christopher Schultz" <[EMAIL PROTECTED]> To: "Tomcat Users L

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 d

Re: Help getting MySQL connected to Tomcat

2008-02-24 Thread kevin
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 working. I tested mysql and it is using tcp/ip. "mysql -h 127.0.0.1 -u javauser -p" works fin

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
lp. Kevin - Original Message - From: "Christopher Schultz" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Sunday, February 24, 2008 8:06 AM Subject: Re: Help getting MySQL connected to Tomcat -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kevin, [EMAIL PROTE

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: Sent: Saturday, February 23, 2008 9:00 PM Subject: Help getting MySQL connected to Tomca

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 prop

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 va

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