wood burning stoves*
The moose likes JDBC 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


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle database connection in eclipse/ remote server" Watch "Oracle database connection in eclipse/ remote server" New topic
Author

Oracle database connection in eclipse/ remote server

Sean Cormican
Greenhorn

Joined: Aug 25, 2011
Posts: 8
Hi,

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
Greenhorn

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.


Regards,

Vigneswaran.M
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29279
    
140

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Oracle database connection in eclipse/ remote server
 
Similar Threads
problem - db2 database configuration in datasource
distribution of resourcse
connecting database
how to connect to a remote database
"oracle 9i Client" and "Oracle 9i personal edition"