This week's book giveaway is in the Performance forum.
We're giving away four copies of The Java Performance Companion and have Charlie Hunt, Monica Beckwith, Poonam Parhar, & Bengt Rutisson on-line!
See this thread for details.
Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hello

 
mahendranag manchinasetty
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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);
}

}
}

mahendranag@gmail.com
 
Peter Lawrey
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
> Hello.
Hello. How are you doing?

> .i am getting this java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
Sounds like it could not find the class OracleDriver. It has to be in one of the jars in your class path.
It could be one of these Find Jar for OracleDriver
 
Tim Holloway
Saloon Keeper
Pie
Posts: 18223
53
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A long time ago, Oracle distributed the driver in a file named classes12.zip.

You shouldn't be using that one, since it changed in Oracle 9, and Oracle 8 is no longer supported that I know of.

However, the classpath jars have to have names ending in ".jar", so the classes12.zip had to be renamed.
 
Jesper de Jong
Java Cowboy
Saloon Keeper
Pie
Posts: 15369
40
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to JavaRanch. Please use a meaningful subject line when you post a question.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic