• Post Reply Bookmark Topic Watch Topic
  • New Topic

jdbc with microsoft SQl Server 2008  RSS feed

Rajeev Kumarjamshedpur
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am wrinting a simple java code that communicate with microsoft SQL Server 2008

and after this set classpath of sqljdbc4.jar
and after this i comile the program i got following error
C:\Documents and Settings\r6876046\Desktop>javac Test.java
Test.java:7: package com.microsoft.sqlserver.jdbc does not exist
DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQ
1 error

here is my source code

import java.sql.*;
class Test
public static void main(String[] args) throws Exception
// Register the driver
DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
// Establish connection with the Database
Connection con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433:","sa","jeffrey");
//cfreate a sql statement
Statement stmt=con.createStatement();
//Execute the stmt
ResultSet rs=stmt.executeQuery("select * from studentinfo");
//all row of student table are in rs Now retrive column data from rs and display
// close the connection

Please help me about this and where i need to change and how i achive the goal please guide me properly i am waiting for Your Response

thanks In Advance

Vijitha Kumara
Posts: 3974
Chrome Fedora Hibernate
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

to load and register the driver class with the DriverManager.
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!