MS SQL server+ JDBC Connection

[Parthi1705]

hi,
I am new to java i need to connect MS SQL server+ JDBC Connection
I am getting the below error when i try to connect the code in Eclipse

import java.sql.*;

public class SQLServerTest {

public static void main(String[] args) {

// Create a variable for the connection string.

String connectionUrl="jdbc:sqlserver://localhost:1433;DatabaseName=Master";



// Declare the JDBC objects.
Connection con = null;
Statement stmt = null;
ResultSet rs = null;

try {
// Establish the connection.
Class.forName("com.microsoft.sqlserver.jdbc.SQLSer verDriver");
con = DriverManager.getConnection(connectionUrl);

// Create and execute an SQL statement that returns some data.
String SQL = "Select * from sys.sysobjects where xtype='u'";
stmt = con.createStatement();
rs = stmt.executeQuery(SQL);

// Iterate through the data in the result set and display it.
while (rs.next()) {
System.out.println(rs.getString(4) + " " + rs.getString(6));
}
}

// Handle any errors that may have occurred.
catch (Exception e) {
e.printStackTrace();
}

finally {
if (rs != null) try { rs.close(); } catch(Exception e) {}
if (stmt != null) try { stmt.close(); } catch(Exception e) {}
if (con != null) try { con.close(); } catch(Exception e) {}
}
}
}

ERROR:

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at SQLServerTest.main(SQLServerTest.java:20)

What would be the reason.

Thanks

[Tolls]

The jar file containing the driver needs to be on the runtime classpath.
How that is setup in your IDE will probably be in the documentation for Eclipse.

[Parthi1705]

Re: MS SQL server+ JDBC Connection
The jar file containing the driver needs to be on the runtime classpath.
How that is setup in your IDE will probably be in the documentation for Eclipse.

Where does the jar file containing the driver will be , and what needs to be to have runtime classpath .
I couldn't find any details i just connect Eclipse and coded and getting the error what needs to be modified or needs to be added at Eclipse .


Thanks!

[Tolls]

You'll need to download it from Microsoft.
Then add it into your project, but exactly how is an Eclipse thing, so read up on the Eclipse documentation.