File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes The import oracle.sql cannot be resolved Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "The import oracle.sql cannot be resolved" Watch "The import oracle.sql cannot be resolved" New topic
Author

The import oracle.sql cannot be resolved

Ivan Turner
Ranch Hand

Joined: Feb 27, 2012
Posts: 37
Hi, I'm having a problem as I learn Java. I'm trying JDBC with Oracle drivers. My error is "The import oracle.sql cannot be resolved" I need the import of

I have Oracle on the laptop. I've discovered the jars are in ORACLE_HOME\jdbc\lib. How do I get the imports to see/locate the jar files in Eclipse?
Ivan Turner
Ranch Hand

Joined: Feb 27, 2012
Posts: 37
Project > Properties > Java Build Path is the solution. On the Library tab, use the add button and point to the files.
Pyla Rao
Ranch Hand

Joined: Jul 10, 2012
Posts: 50
we need to import oracle jdbc driver api into your project libraries. its seems to solve solution.
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19718
    
  20

Why do you need to import those? JDBC works best if you only program to the interfaces in java.sql and javax.sql, keeping the database specific stuff localized to loading the class and setting up the connection String. That allows you to switch to a different database system with only little effort.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: The import oracle.sql cannot be resolved