CODEWITHSUNDEEP
javasql-server
Maarten Blokker
Maarten Blokker

Reputation: 604

Unable to get a SQL-Server connection

Im having difficulties trying to get a connection to my sqlserver database. The database im using is SQL-Server 2008. The driver im using is the one i got here: Microsoft download page

I use the following code:

public static final String URL_FORMAT = "jdbc:sqlserver://%s:%s;DatabaseName=%s";

    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        String connectionURL = String.format(URL_FORMAT, "10.31.3.3", 1433, "EPowerTest");
        System.out.println("connecting to: "+connectionURL);
        
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        Connection connection = DriverManager.getConnection(connectionURL, "sa", "*************");
        if (connection == null) {
            System.out.println("no connection was established");
        } else {
            System.out.println("succesfully connected");
        }
    }

Now this piece of code runs on my developers machine, im getting the following results:

connecting to: jdbc:sqlserver://...:1433;DatabaseName=******

succesfully connected

But when i run this piece of code on my developers machine it prints the follwing:

connecting to: jdbc:sqlserver://10.31.3.3:1433;DatabaseName=*******

and the second line never gets printed, because it seems DriverManager.getConnection does not return. This is not a firewall issue, since all three terminals (db server, developers machine and the test machine) are all on the same network. Why is my method not returning? am i missing some important SQLServer files?

Hope anyone here can help me with this annoying problem!

Upvotes: 2

Views: 362

Answers (1)

Luciano
Luciano

Reputation: 8582

Check if the JVM in the machine that the connections hangs is the version 1.6.0_29. If it is, upgrade to a newer Java.

Here is another link explaining the issue.

Upvotes: 2

Related Questions