File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Oracle and Servlet JDBC Connection problems Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle and Servlet JDBC Connection problems" Watch "Oracle and Servlet JDBC Connection problems" New topic

Oracle and Servlet JDBC Connection problems

rahul markonda

Joined: Jul 13, 2011
Posts: 9
Thanks for the help with my database MS Access Connection.............
But right now as type-4 driver in Oracle is working so I switched back to it......

Through this driver I could use a direct JDBC program but when I use such a code inside a servlet I get errors again......
Its a simple code where I print table after username and password matched....

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

public class ServletDemo extends HttpServlet

public void init(ServletConfig sc) {
try {
Connection con=null;

con=DriverManager.getConnection("jdbcracle:thin:@localhost:1521:ORCL", "scott" , "james1");
catch(Exception exp){
System.out.println("exp : "+exp.getMessage());
catch(Exception x){
System.out.println( "Unable to load the driver class!" );
public void service (HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
PrintWriter pw=res.getWriter();
String un=req.getParameter("uname");
String pwd=req.getParameter("pwd");
if (un.equals("rahul") && pwd.equals("rahul"))
Statement st=con.createStatement();
ResultSet rs=null;
st.executeQuery("select * from student");
if (rs != null)
while ( )
System.out.println( rs.getString(1)+" "+ rs.getString(2)+" "+rs.getString(3));


pw.println("Login Failed");
pw.println("<a href='index.html'> Go Back</a>");

Though JDBC and Servlets are working independently when I want to use them combined I get error like:
Error 1: Cannot find symbol
symbol: Class Connection

Error 2: Cannot find symbol
symbol: Class DriverManager

Error 3: Cannot find symbol
symbol: Class Statement

Error 4: Cannot find symbol
symbol: variable con

Error 5: Cannot find symbol
symbol: Class ResultSet

I also set ojdbc14.jar as classpath.
I use Windows 7 and server is tomcat 5.5. I use Oracle 11g
Thank you
Madhan Sundararajan Devaki
Ranch Hand

Joined: Mar 18, 2011
Posts: 312

Is your ojdbc14.jar present within WEB-INF/lib folder of your servlet?

Not many get the right opportunity !
vipul bondugula
Ranch Hand

Joined: Oct 14, 2010
Posts: 218

For the Connection ,Statement and ResultSet you need to import java.sql.*.

Declare Connection ,Statement and ResultSet objects globally..
outside init()..
jst declare and initialize to null.then you won't get the errors.

Vipul Kumar
Rahul Bhawar

Joined: Dec 03, 2013
Posts: 1
Madhan Sundararajan Devaki wrote:Is your ojdbc14.jar present within WEB-INF/lib folder of your servlet?

Thanks Madhan .. you solve my problem...
subject: Oracle and Servlet JDBC Connection problems