problem with jdbc connection

From: BhaduriAnand <bhadu_at_iiitmk.ac.in>
Date: 25 Feb 2002 00:44:10 -0800
Message-ID: <b7de5e80.0202250044.3cfac716_at_posting.google.com>

hi,
  i have written one servlet for geeting connected to my database in oracle 8i.But it is not getting connected.here is the code.and the error given when i run the jsp is also given below.

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

/***************************************************************************************************************************

                                        class jdbcServlet started

***************************************************************************************************************************/
public class win2 extends HttpServlet{
	Connection con;
	


/***************************************************************************************************************************



					init() started

***************************************************************************************************************************/

public void init(){                 

	try{
	Class.forName("oracle.jdbc.driver.OracleDriver");//loading the odbc
driver
	con=DriverManager.getConnection("jdbc:oracle:oci8:_at_cheru","scott","tiger");//
	     }
	     catch(ClassNotFoundException e)
	     {
	     System.out.println("JDBC-ODBC bridge not found");//outputting
error if class not found
	     return;
	     }
	     catch(SQLException e)
	     {
	     System.out.println("SQL exception thrown in init");
	     return;
            }//try-catch finished

}//init finished         

/***************************************************************************************************************************

                                init() finished

***************************************************************************************************************************/




/***************************************************************************************************************************



					doPost() started

***************************************************************************************************************************/

public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException{

	try{
	     res.setContentType("text/html");
	     PrintWriter out=res.getWriter();
	     String dbpasswd=null;
                       String name=req.getParameter("name");
	     String password=req.getParameter("password");
	     Statement stmt=con.createStatement();
		try{
	    	ResultSet rs=stmt.executeQuery("SELECT * FROM bhaduri where

username='"+name+"'");//selecting record matching with username

	    		while(rs.next())//moving the cursor
	    		{		
	    		dbpasswd=rs.getString("password");//getting password
corresponding to username
	    		}//while finished

                      	 }catch(SQLException e)
	    	 {
	     	System.out.println("Error in SQL Statement ");
	     	System.out.println(e.getMessage());
	     	}// inner try-catch finished

			if(password.equals(dbpasswd))//comparing password from table and
password given by user
			{

			res.sendRedirect("http://192.168.0.110:8080/bhaduri/main.html");//if
password matches go to main page
			}

			else
			res.sendRedirect("http://192.168.0.110:8080/bhaduri/loginfail.html");//else

login page

			}
		catch(Exception e)
		{
		System.out.println("Error");
		e.printStackTrace();
		}// outer try-catch finished
	}//doPost finished



/***************************************************************************************************************************



					doPost() finished

***************************************************************************************************************************/

}//class finished

/***************************************************************************************************************************

                                        class jdbcServlet finished

***************************************************************************************************************************/

		Error: 500

Location: /bhaduri/servlet/win2
Internal Servlet Error:

java.lang.UnsatisfiedLinkError: no ocijdbc8 in java.library.path

	at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1312)
	at java.lang.Runtime.loadLibrary0(Runtime.java:749)
	at java.lang.System.loadLibrary(System.java:820)
	at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:228)
	at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:246)
	at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
	at java.sql.DriverManager.getConnection(DriverManager.java:517)
	at java.sql.DriverManager.getConnection(DriverManager.java:177)
	at win2.init(win2.java:36)
	at javax.servlet.GenericServlet.init(GenericServlet.java:258)
	at org.apache.tomcat.core.ServletWrapper.doInit(ServletWrapper.java:317)
	at org.apache.tomcat.core.Handler.init(Handler.java:215)
	at org.apache.tomcat.core.ServletWrapper.init(ServletWrapper.java:296)
	at org.apache.tomcat.core.Handler.service(Handler.java:254)
	at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
	at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
	at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
	at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
	at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
	at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
	at java.lang.Thread.run(Thread.java:484)

please help
Bhaduri Anand Received on Mon Feb 25 2002 - 09:44:10 CET