Connecting to an SQL server using Java

Question

I need to connect to a Microsoft SQL server using Java.

I downloaded the driver, an no matter what I did elipse and netbeans could not find the driver.

When I got frustrated I downloaded also MySql driver, and again I get the same exception.

I added the drivers path in the environmental variables and also included the jar files in my project library.

Here is a picture of my project:

http://i56.tinypic.com/1ekple.jpg

What am I doing Wrong?

Thank you very much, Idan.

"When I got frustrated i downloaded also MySql driver" What were you thinking?? MS SQL != MySQL. — Vineet Reynolds
– Vineet Reynolds, Commented Jun 16, 2011 at 16:46
Trying to use com.mysql.jdbc.Driver for an msql: connection will definitely not work. What's the error message with the MS SQL JDBC driver? — Bruno
– Bruno, Commented Jun 16, 2011 at 16:46
I installed a mysql server to try on, i didnt try to connect to mysql server using MS driver. this is what happens when i use the MS driver: i54.tinypic.com/2prcx7k.jpg — Idan
– Idan, Commented Jun 16, 2011 at 16:55
read the jTDS FAQ. The URL format for jTDS is different from the one used by MS SQL JDBC driver. — Vineet Reynolds
– Vineet Reynolds, Commented Jun 16, 2011 at 17:06

Brad Gardner · Accepted Answer · 2011-06-16 17:24:34Z

1

A few problems:

Your JDBC url should be jdbc:mssql instead of jdbc:msql
The port for SQL Server is usually 1433, not 8888 but can be configured.
The driver specified is for MySQL and won't work.

Start to correct by downloaded a MS SQL JDBC driver, there are 2 popular varients:

Open source: http://jtds.sourceforge.net/

Microsoft: http://msdn.microsoft.com/en-us/sqlserver/aa937724

I've used both and haven't had much problems in either case.

EDIT

The only example I have currently is using the microsoft driver, here it is:

DRIVER: com.microsoft.sqlserver.jdbc.SQLServerDriver

URL: jdbc:sqlserver://localhost:1433;database=<MyDB>

edited Jun 16, 2011 at 17:24

answered Jun 16, 2011 at 16:54

Brad Gardner

1,62714 silver badges14 bronze badges

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

2 Comments

Brad Gardner Over a year ago

check that the driver you are using is on your classpath, and that your sql server is running on port 8888. like previously mentioned, this is not the normal port.

Brad Gardner Over a year ago

Edited question to include sample using microsoft driver.

Peter Tillemans · Accepted Answer · 2011-06-16 16:49:56Z

0

There is a typo in the url in order to connect to mysql.

It should be jdbc:mysql://127.0.0.1:8888

Also I would double check if your mysql server is actually running on port 8888 since normally a mysql answers on 3306.

Also there are multiple JDBC drivers for Microsofts' SQL server, which have different url. For the microsoft driver the url looks like jdbc:microsoft:sqlserver://localhost:1433

Check the documentation of the driver for an example url to start from.

answered Jun 16, 2011 at 16:49

Peter Tillemans

35.4k11 gold badges85 silver badges117 bronze badges

2 Comments

Idan Over a year ago

mySql server is easyphp server and it is 8888 port and i can connect to it through cmd

Peter Tillemans Over a year ago

With easyphp the webserver listens on port 8888. Mysql listens also on port 3306 by default when installing easyphp.

Ash · Accepted Answer · 2011-06-16 16:59:20Z

Try with jTDS. It is an open source JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000 and 2005). Place jar file into your application classpath. java.sql package along with above driver helps connecting to database.

import java.sql.*;

public class testConnection
{
    public static void main(String[] args) 
    {
        DB db = new DB();
        db.dbConnect(
     "jdbc:jtds:sqlserver://localhost:1433/tempdb","sa","");
    }
}

class DB
{
    public DB() {}

    public voidn dbConnect(String db_connect_string, 
  String db_userid, String db_password)
    {
        try
        {
            Class.forName("net.sourceforge.jtds.jdbc.Driver");
            Connection conn = DriverManager.getConnection(
    db_connect_string, db_userid, db_password);
            System.out.println("connected");

        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }
};

Collectives™ on Stack Overflow

Connecting to an SQL server using Java

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related