J# using JDBC for SQL Server

code:

/* Establish a test connection to remote SQLServer in J# using JDBC */
package JSharpConnTest;
import java.sql.*;
public class JSharpConnTest
{
private static ResultSet rs;
private static Connection conn = null;
private static Statement stmt = null;
private static final String sSubprotocol = "jdbc:microsoft:sqlserver://";
private static final String sServerName = "CLUSTERTEST";
private static final String sPortNumber = "1433";
private static final String sDBName = "ClientLetterWorkRequests";
private static final String sUserName = "sa";
private static final String sPassword = "1111";
private static final String sSQLQuery = "SELECT * FROM CLDatabases";
private static final String sURL = sSubprotocol + sServerName +
":" + sPortNumber + ";
databaseName=" + sDBName + ";
";
public static void main(String[] args)
{
getConnection();
}
public static void getConnection()
{
System.out.println( "Connecting to.. " + sURL );
try
{
//Register the driver
// Microsoft SQL Server 2000 Driver for JDBC
// --problem locating driver?
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// Pass connection URL
conn = DriverManager.getConnection(sURL, sUserName, sPassword);
// Query database
stmt = conn.createStatement();
rs = stmt.executeQuery(sSQLQuery);
// Test data retrieval
while (rs.next());
{
String colOne = rs.getString("DATABASEKEY");
String colTwo = rs.getString("SERVERTYPE");
System.out.println(colOne + " " + colTwo);
}
}
catch (java.lang.ClassNotFoundException ex)
{
System.err.println("\nClassNotFoundException: " + ex.getMessage());
}
catch (SQLException ex)
{
System.err.println("\nSQLException: " + ex.getMessage());
}
catch (Exception ex)
{
System.err.println("\nException: " + ex.getMessage());
}
finally
{
// Release resources
try
{
if (conn != null)
conn.close();
if (stmt != null)
stmt.close();
}
catch (Exception ex)
{
System.err.println("\nException: " + ex.getMessage());
}
}
} // end getConnection()
} // end JSharpConnTest

This statement:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Causes the following exception:
[java.lang.ClassNotFoundException]{
"com.microsoft.jdbc.sqlserver.SQLServerDriver"}java.lang.ClassNotFoundExcep
tion
I installed Microsoft SQL Server 2000 Driver for JDBC
I believe the problem is with locating the driver, unlike Java, J# doesn't
use classpath enviromental variable. I am not sure how to add the driver
reference in J#.Hi
Why use JDBC when ADO.NET can do everything for you?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"RobertStout" <
RobertStout@.discussions.microsoft.com>
wrote in message
news:4FB06586-4C07-4886-A9E5-444A85DA4F31@.microsoft.com...
>

code:

>
 /* Establish a test connection to remote SQLServer in J# using JDBC */
>
>
 package JSharpConnTest;
>
 import java.sql.*;
>
>
 public class JSharpConnTest
>
 {
>
 private static ResultSet rs;
>
 private static Connection conn = null;
>
 private static Statement stmt = null;
>
 private static final String sSubprotocol = "jdbc:microsoft:sqlserver://";
>
 private static final String sServerName = "CLUSTERTEST";
>
 private static final String sPortNumber = "1433";
>
 private static final String sDBName = "ClientLetterWorkRequests";
>
 private static final String sUserName = "sa";
>
 private static final String sPassword = "1111";
>
 private static final String sSQLQuery = "SELECT * FROM CLDatabases";
>
 private static final String sURL = sSubprotocol + sServerName +
>
 ":" + sPortNumber + ";
databaseName=" + sDBName + ";
";
>
>
 public static void main(String[] args)
>
 {
>
 getConnection();
>
 }
>
>
 public static void getConnection()
>
 {
>
 System.out.println( "Connecting to.. " + sURL );
>
>
 try
>
 {
>
 //Register the driver
>
 // Microsoft SQL Server 2000 Driver for JDBC
>
 // --problem locating driver?
>
 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
>
>
 // Pass connection URL
>
 conn = DriverManager.getConnection(sURL, sUserName, sPassword);
>
>
 // Query database
>
 stmt = conn.createStatement();
>
 rs = stmt.executeQuery(sSQLQuery);
>
>
 // Test data retrieval
>
 while (rs.next());
>
 {
>
 String colOne = rs.getString("DATABASEKEY");
>
 String colTwo = rs.getString("SERVERTYPE");
>
 System.out.println(colOne + " " + colTwo);
>
 }
>
 }
>
 catch (java.lang.ClassNotFoundException ex)
>
 {
>
 System.err.println("\nClassNotFoundException: " + ex.getMessage());
>
 }
>
 catch (SQLException ex)
>
 {
>
 System.err.println("\nSQLException: " + ex.getMessage());
>
 }
>
 catch (Exception ex)
>
 {
>
 System.err.println("\nException: " + ex.getMessage());
>
 }
>
 finally
>
 {
>
 // Release resources
>
 try
>
 {
>
 if (conn != null)
>
 conn.close();
>
 if (stmt != null)
>
 stmt.close();
>
 }
>
 catch (Exception ex)
>
 {
>
 System.err.println("\nException: " + ex.getMessage());
>
 }
>
 }
>
>
>
 } // end getConnection()
>
 } // end JSharpConnTest
>

>
>
This statement:
>
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
>
>
Causes the following exception:
>

[java.lang.ClassNotFoundException]{
"com.microsoft.jdbc.sqlserver.SQLServerDr
iver"}java.lang.ClassNotFoundException
>
>
I installed Microsoft SQL Server 2000 Driver for JDBC
>
I believe the problem is with locating the driver, unlike Java, J# doesn't
>
use classpath enviromental variable. I am not sure how to add the driver
>
reference in J#.|||If I could use ADO.NET I would of been done with the entire app a long time
ago.
Sadly, I have to use JDBC.
Can you help?
Thanks
-Rob
I would much rather use ADO.NET but I can't, I have to use JDBC.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Why use JDBC when ADO.NET can do everything for you?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "RobertStout" <RobertStout@.discussions.microsoft.com> wrote in message
> news:4FB06586-4C07-4886-A9E5-444A85DA4F31@.microsoft.com...
> [java.lang.ClassNotFoundException]{"com.microsoft.jdbc.sqlserver.SQLServerDr
> iver"}java.lang.ClassNotFoundException
>
>sql