connecting to sql server 2014 database from basic java application?

java sql intellij-idea sql-server-2014-express connector-j
filthy_wizard picture filthy_wizard · May 7, 2015 · Viewed 7.3k times · Source

I am following along with the book "learn java for web development" by vishal layka at present. But I have run into an issue which I will describe as best I can here. Essentially I cant connect to my database called "book" with connectorj 5.0.8. the database is running locally on microsft sql server 2014. this is the method iam using to get the connection.

private Connection getConnection() throws SQLException
{
     return DriverManager.getConnection("jdbc:mysql://localhost:3306/books","eoin", "");
}

iam getting this output when iam trying to get the connection.

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 

 ** BEGIN NESTED EXCEPTION ** 

java.net.ConnectException
MESSAGE: Connection refused: connect

I edited my sql server configuration in the "sql server configuration manager" tool so that it operates on port 3306 and it is enabled on localhost. the service but still no joy. below shows an image of this config.

enter image description here

iam thinking maybe my lack of knowledge of sql server is holding me back here. another thing i think that may be the issue is in sql management studio. when I try to change the login properties password. this is circled in the image below.

enter image description here

when i change this password.then click "ok" then reenter the "login properties for this db user then password I previously changed seems to have returned to what it was originally? I may be barking up the wrong tree altogether but iam not too sure? I hope the question was clear enough and any help is appreciated!

just a quick edit. Ive also tried turning off my firewall completely and I still couldnt connect.

Answer

Atilla Ozgur picture Atilla Ozgur · May 7, 2015

First of all your connection string is wrong.

jdbc:mysql://localhost:3306/books

Change it to 

jdbc:sqlserver://localhost:3306/books

See connection string info here.

Second, you may need to open TCP/IP in protocol since by default SQL server express has only Named Pipes open. See how to open TCP/IP Protocol here.

Related questions

"NoClassDefFoundError: javax/xml/bind/DatatypeConverter" with SQL Server JDBC

I recently switched to intellij but I'm finding it hard to connect to my localDB. The same code worked on eclipse fine. Also I have already added the sqljdbc42.jar as a module dependency. package com.enter; import java.sql.*; …

Read More
How to convert java.util.Date to java.sql.Date?

I am trying to use a java.util.Date as input and then creating a query with it - so I need a java.sql.Date. I was surprised to find that it couldn't do the conversion implicitly or explicitly …

Read More
could not extract ResultSet in hibernate

I have a problem with Hibernate. I try to parse to List but It throws an exception: HTTP Status 500 - could not extract ResultSet. When I debug, It fault at line query.list()... My sample code here @Entity @Table(name = "…

Read More