This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
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 Building Microservices this week in the Design 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
Author

Oracle and Servlet JDBC Connection problems

rahul markonda
Greenhorn

Joined: Jul 13, 2011
Posts: 9
Hi,
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 {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=null;
try{

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!" );
System.out.println(x.getMessage());
}
}
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"))
{
pw.println("Success");
Statement st=con.createStatement();
ResultSet rs=null;
st.executeQuery("select * from student");
rs=st.getResultSet();
if (rs != null)
while ( rs.next() )
{
System.out.println( rs.getString(1)+" "+ rs.getString(2)+" "+rs.getString(3));

}
st.close();
con.close();
}


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


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?


S.D. MADHAN
Not many get the right opportunity !
vipul bondugula
Ranch Hand

Joined: Oct 14, 2010
Posts: 219
Hi

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.


Thanks
Vipul Kumar
Rahul Bhawar
Greenhorn

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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Oracle and Servlet JDBC Connection problems
 
It's not a secret anymore!