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.

Answer: 
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
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.