Home » Developer & Programmer » JDeveloper, Java & XML » java oracle database connection
java oracle database connection [message #138955] Mon, 26 September 2005 00:14 Go to next message
sandeepkumar99
Messages: 3
Registered: September 2005
Location: Ernakulam
Junior Member
I have a programme written in java(using JBuilder for Designer) and oracle as Back End. When i am going to connect to oracle getting a runtime error(java.lang.classNotFound Exception)
oracle.jdbc.Driver.oracleDriver.


Please reply soon

Report message to a moderator

Re: java oracle database connection [message #139431 is a reply to message #138955] Wed, 28 September 2005 00:36 Go to previous messageGo to next message
Kavitha Suresh
Messages: 22
Registered: September 2005
Junior Member
Please include classes12.zip in your CLASSPATH and make sure the driver oracle.jdbc.driver.OracleDriver is loaded using
Classes.forName(..);

Report message to a moderator

Re: java oracle database connection using JBuilder [message #140424 is a reply to message #139431] Tue, 04 October 2005 03:23 Go to previous messageGo to next message
sandeepkumar99
Messages: 3
Registered: September 2005
Location: Ernakulam
Junior Member
I have done a code for forms and i want to connect to oracle 8i using java in JBuilder and when i import the sql package it produces an error message that cannot load the driver . i have also import oracle.jdbc.driver and istill get the same error. If you are giving a sample code for that it will be a great help to me and i say everything who help me thanks in advance.

Report message to a moderator

Re: java oracle database connection using JBuilder [message #140613 is a reply to message #140424] Tue, 04 October 2005 23:51 Go to previous messageGo to next message
Kavitha Suresh
Messages: 22
Registered: September 2005
Junior Member
Hi,
Make Sure Classes12.Zip(or jar) is in your CLASSPATH.
Then, try the following code.

try
{
Class.forName(oracle.jdbc.driver.OracleDriver);
Connection conn = DriverManager.getConnection(URL,userId,password);
}
catch ( Exception e)
{

}
Hope this helps

Report message to a moderator

Re: java oracle database connection using JBuilder [message #242374 is a reply to message #140613] Fri, 01 June 2007 13:01 Go to previous message
ghasagar
Messages: 1
Registered: June 2007
Junior Member
Guys,

I was facing the same issue of not being able to connect to Oracle Server using oracle.jdbc.driver.OracleDriver. This worked as a standalone JAVA program(via main()) *NOT* thru *TOMCAT*.

I just renamed classes12.zip (latest) to classes12.jar and wow..it worked..

cheers
sagar

Report message to a moderator

Previous Topic: Can we use two or more values in when condition tag
Next Topic: Please help me with handling PIPELINED
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 23:02:43 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.