wood burning stoves 2.0
The moose likes JDBC and Relational Databases 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 Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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 java.io.*;
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 ( rs.next() )
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: 219

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...
I agree. Here's the link: http://aspose.com/file-tools
subject: Oracle and Servlet JDBC Connection problems
It's not a secret anymore!