tomcat - mysql : Connection refused

[gianni ipez]

Hi all,
I am learning how to connect to mysql database through tomcat,
and I am experiencing a problem.
I have followed the instrunctions detailed in :
Apache Tomcat Faq Page
the problem is that invoking:
http://localhost:8080/DBTest/test.jsp

I get the page with output:
Results
Foo Not Connected
Bar -1

and also the error in the log:

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: connect
 
STACKTRACE:
 
java.net.SocketException: java.net.ConnectException: Connection refused: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:143)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:225)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1805)
at com.mysql.jdbc.Connection.<init>(Connection.java:452)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:701)
at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:769)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4126)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)    

As someone told I checked the ports on my machine, and I have correctly set up mysql on port 3306, tomcat on 8080.
I have a firewall(Sunbelt Kerio), but I've already disabled it.

Any idea please?
Thank you in advance.
Gianni

[Juan Antonio Gomez Moriano]

Is your mysql server running?

Seems that the port is not open, you can quickly check if the 3306 port is open by doing a telnet to it :

telnet localhost 3306

[Cameron Wallace McKenzie]

I like doing a netstat -a on windows. Tells me what ports close to the one I want are open as well.

Shoot us the file that has your connection information and maybe we can see an error.

-Cameron McKenzie

[gianni ipez]

Thank you for your answers.
if I check mysql in the services running I can get it.
It says started.

here are the answers at the prompt commands:
>telnet localhost 3306:
L
6.0.2-alpha-community-nt-debug♥a]0stmGY,☻j*.Ha.a~x]K?

Connessione all'host perduta. (that means host connection lost)

when doing
>netstat -a:

 TCP    ariosto:epmap          ariosto:0              LISTENING
  TCP    ariosto:microsoft-ds   ariosto:0              LISTENING
  TCP    ariosto:1027           ariosto:0              LISTENING
  TCP    ariosto:ms-sql-m       ariosto:0              LISTENING
  TCP    ariosto:3260           ariosto:0              LISTENING
  TCP    ariosto:3261           ariosto:0              LISTENING
  TCP    ariosto:3306           ariosto:0              LISTENING
  TCP    ariosto:44334          ariosto:0              LISTENING
  TCP    ariosto:44501          ariosto:0              LISTENING
  TCP    ariosto:netbios-ssn    ariosto:0              LISTENING
  TCP    ariosto:1025           localhost:44334        ESTABLISHED
  TCP    ariosto:1027           localhost:1030         ESTABLISHED
  TCP    ariosto:1030           localhost:1027         ESTABLISHED
  TCP    ariosto:1432           localhost:44334        ESTABLISHED
  TCP    ariosto:ms-sql-m       localhost:1436         ESTABLISHED
  TCP    ariosto:1436           localhost:ms-sql-m     ESTABLISHED
  TCP    ariosto:44334          localhost:1025         ESTABLISHED
  TCP    ariosto:44334          localhost:1432         ESTABLISHED
  UDP    ariosto:microsoft-ds   *:*                    
  UDP    ariosto:isakmp         *:*                    
  UDP    ariosto:1026           *:*                    
  UDP    ariosto:1028           *:*                    
  UDP    ariosto:1029           *:*                    
  UDP    ariosto:1042           *:*                    
  UDP    ariosto:ms-sql-s       *:*                    
  UDP    ariosto:1435           *:*                    
  UDP    ariosto:4500           *:*                    
  UDP    ariosto:44334          *:*                    
  UDP    ariosto:ntp            *:*                    
  UDP    ariosto:netbios-ns     *:*                    
  UDP    ariosto:netbios-dgm    *:*                    
  UDP    ariosto:1900           *:*                    
  UDP    ariosto:ntp            *:*                    
  UDP    ariosto:1454           *:*                    
  UDP    ariosto:1900           *:*                    
   

Is there helpful?
Is this meaning something to you?
Thanks again!
Gianni

[Taslim Sohel]

I burned with the same problem for long time. I fixed that.
Just download the JTDS JDBC Driver and unpack it. Copy the jtds-1.2-dist.zip file that you download from Sourceforge in to %TOMCAT_HOME%/common/lib.

That�s all. Restart your Tomcat and try again.

JTDS JDBC Driver Download Link:
http://sourceforge.net/project/showfiles.php?group_id=33291