Hello friends,
This is my error iam not getting any output iam getting this java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver .even i set class path also .i am getting this java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver ..what to do with this.can any one slove this please.this is my program..
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import javax.servlet.*;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class getting extends HttpServlet
{
public void doGet(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
response.setContentType("text/html");
PrintWriter pw=response.getWriter();
Connection con = null;
String url="jdbc
racle:thin:@localhost:1521
atab";
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection(url,"scott","tiger");
PreparedStatement pst=con.prepareStatement("Select * from empsal");
ResultSet rs=pst.executeQuery();
ResultSetMetaData rsmd=rs.getMetaData();
int no=rsmd.getColumnCount();
pw.println(+no);
pw.println("The name of the columns are:
");
for(int i=0;i<=no;i++)
{
String s=rsmd.getColumnName(i);
pw.println(s);
}
}
catch(Exception e)
{
pw.println(e);
}
}
}
[email protected]
