java SQL connection refused exception

Question

I am newbie to java db coding...

This is my java code

Connection conn = null;
Statement stmt = null;
Class.forName("com.mysql.jdbc.Driver");
System.out.println("Connecting to database...");
conn = DriverManager.getConnection("jdbc:mysql://localhost/EMP",USER,PASS);
System.out.println("Creating statement...");
stmt = conn.createStatement();
String sql;

This is the exception I am getting :

ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/tiles].[default]] (http-localhost-127.0.0.1-8080-1) Servlet.service() for servlet default threw exception: java.net.ConnectException: Connection refused: connect

I am mySQL server also running and contains simple table named EMP. I am not interpreting the get connection URL comppletely. Can anyone explain it briefly?

Thanks.

"connection refused" = db's not running, tcp port is firewalled, socket is in the wrong place, blah blah blah. — Marc B
– Marc B, Commented Oct 29, 2014 at 14:17
Are you trying to connect to an SQL Express server using a MySQL driver? — RealSkeptic
– RealSkeptic, Commented Oct 29, 2014 at 14:21

RealSkeptic · Accepted Answer · 2014-10-29 14:35:05Z

2

You are using the wrong driver for the database. Every database (MySQL, PostgreSQL, SQL Server, Oracle etc.) has a different driver which is what connects between JDBC and the particular database's communication protocol.

You need the Microsoft SQL Server driver. You can download and install it from here if you don't already have it: Microsoft down page for JDBC 4.0 driver.

And here are the instructions on how to add the jar to your classpath, and what URL to use. Note that in JDBC 4.0 and above, the forName is not necessary anymore.

answered Oct 29, 2014 at 14:35

RealSkeptic

34.8k7 gold badges56 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mkwilfreid · Accepted Answer · 2014-10-29 14:39:49Z

1

from what i can see and understand is that you're missing the port.

you'd have done it in this way:

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/EMP",USER,PASS);

The url can be describe in this way

jdbc: which is your connector mysql:which is your current installed database //hostname: which the machine hosting the server portNumber: the port which allows the connection for the server /databaseName: which is your created database.

hope it was helpful

answered Oct 29, 2014 at 14:39

mkwilfreid

1282 silver badges12 bronze badges

1 Comment

mkwilfreid Over a year ago

and as further explained by @RealSkeptic, try to verify your path and that your database has been correctly installed.

S.L. Barth is on codidact.com · Accepted Answer · 2014-10-29 14:47:49Z

0

Download the Microsoft JDBC driver and use Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver);

If the problem still persists enable TCP/IP network protocol, which is disabled by default, and set the TCP/IP port to 1433 which is the default port number.

edited Oct 29, 2014 at 14:47

S.L. Barth is on codidact.com

8,25371 gold badges55 silver badges68 bronze badges

answered Oct 29, 2014 at 14:41

basebandit

971 silver badge12 bronze badges

Collectives™ on Stack Overflow

java SQL connection refused exception

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related