Search...
FAQs
Subscribe
Pie
FAQs
Recent topics
Flagged topics
Hot topics
Best topics
Search...
Search within JDBC and Relational Databases
Search Coderanch
Advance search
Google search
Register / Login
Post Reply
Bookmark Topic
Watch Topic
New Topic
programming forums
Java
Mobile
Certification
Databases
Caching
Books
Engineering
Micro Controllers
OS
Languages
Paradigms
IDEs
Build Tools
Frameworks
Application Servers
Open Source
This Site
Careers
Other
Pie Elite
all forums
this forum made possible by our volunteer staff, including ...
Marshals:
Campbell Ritchie
Jeanne Boyarsky
Ron McLeod
Paul Clapham
Liutauras Vilda
Sheriffs:
paul wheaton
Rob Spoor
Devaka Cooray
Saloon Keepers:
Stephan van Hulst
Tim Holloway
Carey Brown
Frits Walraven
Tim Moores
Bartenders:
Mikalai Zaikin
Forum:
JDBC and Relational Databases
Error in Database Connection
Mohini Dhanaskar
Ranch Hand
Posts: 55
posted 11 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Hello Sir,
I am getting a following error while running an database connection code.
The code is
import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; /* * To change this template, choose Tools | Templates * and open the template in the editor. */ /** * * @author acer */ class DatabaseConnection { public static Connection con = null; public static Connection getConnection() { try { Class.forName("oracle.jdbc.OracleDriver"); con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","manager"); System.out.println(".Connection Established."); } catch (Exception e) { System.out.println(".Connection Problem."); e.printStackTrace(); } return con; } public static void close(Connection con){ try { con.close(); System.out.println(".Connection Closed."); } catch (SQLException ex) { Logger.getLogger(DatabaseConnection.class.getName()).log(Level.SEVERE, null, ex); } } public static void main(String args[]){ getConnection(); } }
The error is run-main:
java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver .Connection Problem. at java.net.URLClassLoader$1.run(URLClassLoader.java:202) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:247) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:169) at DatabaseConnection.getConnection(DatabaseConnection.java:23) at DatabaseConnection.main(DatabaseConnection.java:42) BUILD SUCCESSFUL (total time: 0 seconds)
Swastik Dey
Bartender
Posts: 2270
20
I like...
posted 11 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Have you set the required jar file in to the application class path?
Swastik
Mohini Dhanaskar
Ranch Hand
Posts: 55
posted 11 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Sir,i am running this code in NET beans.
So were should i placed jar files.
Swastik Dey
Bartender
Posts: 2270
20
I like...
posted 11 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Mohini,
Go to project propreties->Libraries->Add jar/Folder and locate ojdbc14.jar.
Swastik
Martin Vashko
Sheriff
Posts: 3837
66
I like...
posted 11 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
You might also want to use a more recent Oracle
JDBC
driver, as explained
here
. That page also contains links to various version of Oracle JDBC drivers.
Mohini Dhanaskar
Ranch Hand
Posts: 55
posted 11 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Thanks a lot Swastik Sir and Martin Sir, my problem is solved.
Swastik Dey
Bartender
Posts: 2270
20
I like...
posted 11 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
You are most welcome Mohini.
Swastik
Mohini Dhanaskar
Ranch Hand
Posts: 55
posted 11 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
reply
reply
Bookmark Topic
Watch Topic
New Topic
Boost this thread!
Similar Threads
Cant connect to oracle.
class loader problem during connection of MySql driver
Oracle DBConnection Problem
java oracle conectivity
exception while running my first jdbc code
More...