MSSQL server 2005-JDBC connection

Question

I am trying to connect Microsoft SQL server 2005 in JAVA using JDBC but getting following Exception. My project is not running in Eclipse it is saying "Requested resource not found" (Done all server configurations and also adding and removing project from server) and when I run it from console it shows me "Class not found exception" I've put JARs by using build path and also put in WEB-INF/lib. but not getting connection following is my code.

import java.sql.Connection;  
import java.sql.DriverManager;  
import java.sql.ResultSet;  
import java.sql.Statement; 

import com.microsoft.sqlserver.jdbc.SQLServerDriver;
/** 
 * @author www.javaworkspace.com 
 *  
 */  
public class SMSdao {  
    public static void main(String[] args) {  
        try {  

         Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            Connection connection = DriverManager  
                    .getConnection(  
                            "jdbc:sqlserver://192.128.10.17:1433;databaseName=TEK_R;selectMethod=cursor",  
                            "sa", "sai@123");  

            System.out.println("DATABASE NAME IS:"  
                    + connection.getMetaData().getDatabaseProductName());  
            Statement statement = connection.createStatement();  
            ResultSet resultSet = statement  
                    .executeQuery("SELECT * FROM dbo.SMS_OUT");  
            while (resultSet.next()) {  
                System.out.println("Message:"  
                        + resultSet.getString("MessageIn"));  
            }  
        } catch (Exception e) {  
            e.printStackTrace();  
        }  
    }  
}

AND the stack trcae is:

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:423)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:356)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:186)
        at SMSdao.main(SMSdao.java:13)

Tried Everything and done all the things whatever i found on web. I am using jdk 7 and tomcat 6 on windows 7.

Daniel Lavoie · Accepted Answer · 2012-05-12 06:48:36Z

2

You need to download the SQLServerDriver JDBC from microsoft. The Class.forName is searching for the Class name you specified and it can't find it in your classpath.

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

Just put the jar in your project classpath (tomcat's shared lib is better).

answered May 12, 2012 at 6:48

Daniel Lavoie

1,9321 gold badge16 silver badges19 bronze badges

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

4 Comments

Rohit Haval Over a year ago

Hey Daniel I have done all these things whatever you are telling but now it is displaying compile time error for same that is "package not found com.microsoft.sqlserver.jdbc".

Daniel Lavoie Over a year ago

Is Tomcat's server runtime present in your project's build pah ?

Rohit Haval Over a year ago

Ya,Tomcat's server runtime is present in project's build path.

Daniel Lavoie Over a year ago

I would suggest to review all your classpath config. There is definitively something wrong.

mockaroodev · Accepted Answer · 2012-05-12 06:54:24Z

0

I would also suggest using jTDS instead: http://jtds.sourceforge.net/

Historically microsoft's JDBC drivers have failed to fully implement important and useful parts of the JDBC spec. jTDS should be more fully featured and is open source.

answered May 12, 2012 at 6:54

mockaroodev

2,0691 gold badge21 silver badges25 bronze badges

Collectives™ on Stack Overflow

MSSQL server 2005-JDBC connection

2 Answers 2

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Related