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 connec

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

Help getting MySQL connected to Tomcat

2008-02-23 Thread kevin
Hello, I'm trying to get Tomcat and MySQL to connect. I have the following installations: Tomcat V5.5.26 MySQL V5.0 mysql connector 5.1.5 from the mysql site (copied the jar to \common\lib I've tried following the directions from the tomcat dist and from the mysql dist but I always get can't c