File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Oracle database connection in eclipse/ remote server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle database connection in eclipse/ remote server" Watch "Oracle database connection in eclipse/ remote server" New topic

Oracle database connection in eclipse/ remote server

Sean Cormican

Joined: Aug 25, 2011
Posts: 8

I know this is probably a fairly common problem but if anyone can point me to where I can find the resources to join a remote Oracle database,
namely the problem that I'm having is that I get this error :

oracle.jdbc.driver.OracleDriver cannot be resolved to a type

which as I understand is a result of not having the correct .jar files or classpaths in place.
Any information on this problem is greatly appreciated!!

thanks in advance.
Vigneswaran Marimuthu

Joined: Aug 30, 2011
Posts: 24

i do not know about the oracle drivers. even i am new to JAVA. but i used mysql. i guess you should have place the .jar file in the project which you have created through eclipse and you need to configure the build path in eclipse so that eclipse will automatically include the .jar file in the project.


Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33111

Vigneswaran is correct. You need to have classes12 or ojdbc14 or whatever driver you are doing in your runtime classpath. For a standalone program this is java -cp .... For a web application, it is a server setting.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Oracle database connection in eclipse/ remote server
It's not a secret anymore!