I use IntelliJIDEA 9.0.3 for my
j2ee web application development. One of my module uses oracle database connection. But I get the error package oracle.jdbc.driver does not exist, package oracle.sql does not exist. I did some google and looked into previous posts and
I tried the following solutions but I still get the error
1. In the module setting -> dependencies-> classes12. Created the project library called classes12 and I have included the sources for classes12.jar.
This is my path C:/app/username/product/11.1.0/client_1/oui/jlib/classes12.jar
2. I have copied the classes12.jar to the C:\Program Files\Java\jdk1.6.0_21\jre\lib\classes12.jar.
I have my
path
C:\app\username\product\11.1.0\client_1\bin;C:\app\username\product\11.1.0\client_1\oui\jlib;C:\Program Files\Java\jdk1.6.0_21\jre\lib\classes12.jar;C:\Program Files\Java\jdk1.6.0_21\jre\lib\classes12.jar;C:\app\username\product\11.1.0\db_1\oc4j\jdbc\lib\orai18n.jar;C:\app\username\product\11.1.0\db_1\owb\wf\ojdbc14.jar;
and
classpath set to
.;C:\Program Files\Java\jdk1.6.0_21\jre\lib\classes12.jar;C:\app\username\product\11.1.0\db_1\oc4j\jdbc\lib\orai18n.jar;C:\app\username\product\11.1.0\db_1\owb\wf\ojdbc14.jar;
3. The module also has the jar file in its package folder
I am not sure what I am missing. Can anyone please help me solve this issue.