Thread: I am trying to connect my java application with SQL Server 2008 but I get error msgs

//STEP 1. Import required packages

import java.sql.*;


public class JDBCCreateTable {

// JDBC driver name and database URL
// Database is called Student

static final String JDBC_DRIVER = "com.SQLEXPRESS.jdbc.Driver";
static final String DB_URL = "jdbc:SQLSERVER://SQLEXPRESS/Student";


// Database credentials

static final String USER = "sa";
static final String PASS = "sasa";

public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;

try{

//STEP 2: Register JDBC driver

Class.forName("com.SQLEXPRESS.jdbc.Driver");

//STEP 3: Open a connection

System.out.println("Connecting to database...");
conn = DriverManager.getConnection(DB_URL,USER,PASS);


//STEP 4: Execute a query

System.out.println("Creating statement...");
stmt = conn.createStatement();
String sql;
sql = "SELECT StudentID, StudentName, StudentAddress, PhoneNumber FROM StudentName";
ResultSet rs = stmt.executeQuery(sql);

//STEP 5: Extract data from result set

while(rs.next()){

//Retrieve by column name

int id = rs.getInt("StudentID");
int age = rs.getInt("StudentName");
String first = rs.getString("StudentAddress");
String last = rs.getString("PhoneNumber");

//Display values

System.out.print("StudentID: " + id);
System.out.print("StudentName: " + age);
System.out.print("StudentAddress: " + first);
System.out.println("PhoneNumber: " + last);
}


//STEP 6: Clean-up environment

rs.close();
stmt.close();
conn.close();
}catch(SQLException se){

//Handle errors for JDBC

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

//Handle errors for Class.forName

e.printStackTrace();
}finally{

//finally block used to close resources

try{
if(stmt!=null)
stmt.close();

}catch(SQLException se2){
}

// nothing we can do

try{
if(conn!=null)
conn.close();
}catch(SQLException se){
se.printStackTrace();
}
//end finally try
}

//end try

System.out.println("Goodbye!");
}
//end main

}

//end FirstExample

Error message? Where? What?

That is not the full exception...that being said I presume it is a ClassNotFound exception, which means I recommend reading the following:
http://www.javaprogrammingforums.com...html#post20626

There should be a jar that contains the Driver class needed to make the connection to the DB. That should fix the ClassNotFoundException.

The database URL is invalid so JDBC couldn't find an appropriate driver:

jdbc:microsoft:SQLSERVER://SQLEXPRESS:Student

It should be:

jdbc:sqlserver://localhost\sqlexpress;databaseName=Student

Originally Posted by nambill

The database URL is invalid so JDBC couldn't find an appropriate driver:

Please don't resurrect posts over a year old, especially with the intent of providing links back to (what I presume is) your webpage for self promotion