Skip to Content
0
Former Member
Mar 26, 2007 at 07:33 AM

error: when connecting to sqlServer2005 java.lang.ClassNotFoundException:

80 Views

Hi SDN,

I am trying to connect to sqlServer2005 using the following code

try{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

Connection con = java.sql.DriverManager.getConnection("jdbc:sqlserver://obtdev15:1433;DatabaseName=O50");

response.write("connection succeded<br>");

Statement st= con.createStatement();

response.write("statement created<br>");

ResultSet c = st.executeQuery("select * from [SAPO50DB].[OGP_PROJECT]");

response.write(" rows selected-->" + c.getString("PROJECTNAME"));

}catch(Exception e){

e.printStackTrace();

response.write("exception in --"+e);

}

}

}

when i execute it, it throws the following exception

<b>java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver Found in negative cache -


Loader Info -


ClassLoader name: [com.sapportals.portal.prt.util.ApplicationClassLoader@b460e20] Parent loader name: [com.sapportals.portal.prt.util.AutoClassLoader@a52a72a] References: not registered! Resources: F:\usr\sap\O50\DVEBMGS50\j2ee\cluster\server0\apps\sap.com\irj\servlet_jsp\irj\root\WEB-INF\portal\portalapps\ConnectingtoDB\lib\api.jar -


</b>

Please suggest me to rectify the above error.

your help will be awarded.

Thanks in Advance.

Regards

Basha