SQL SERVER 2005 connection in java

**RajeshBendekay** · Apr 26 '12, 09:54 AM

I am using following code and am using sqljdbc.jar file in lib folder of my project . but getting SQL Exception & Null pointer Exception,what is the reason? please Help me

Code:

[U]DBConnectivity.java[/U]

try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver);
connection =DriverManager.getConnection("jdbc:sq lserver://localhost:8089;databaseName=bill;integratedSecu rity=true;");}

,

Code:

[U]NewFile.jsp[/U]
<%
Connection con=DBConnectivity.getCon();
Statement st=con.createStatement();
String sql="select * from emp";
ResultSet rs=st.executeQuery(sql);
%>

,

Code:

 [U]Error Messages[/U]
 1)java.lang.NullPointerException
 2)com.microsoft.sqlserver.jdbc.SQLServerException: