JDBC Thin Oracle 11g

Question

I am using oracle 11g. I am writing code to connect an oracle database with java 1.6, but I cannot connect to it. When adjust the guide line below:

I have ojdbc6.jar, orai18n.jarand class12.jar I installed:

Class_Path:

%ORACLE_HOME%\jlib\orai18n.jar;r;%Oracle_home%\jdbc\ojdbc6.jar

After that, I run a sample java code to connect to the oracle database, but I met this error below:

C:\Program Files\Java\jdk1.6.0_11\bin>javac c:\JDBCVersion.java
c:\JDBCVersion.java:2: package oracle.jdbc does not exist
import oracle.jdbc.*;
^
c:\JDBCVersion.java:3: package oracle.jdbc.pool does not exist
import oracle.jdbc.pool.OracleDataSource;
                       ^
c:\JDBCVersion.java:8: cannot find symbol
symbol  : class OracleDataSource
location: class JDBCVersion
OracleDataSource ods = new OracleDataSource();
^
c:\JDBCVersion.java:8: cannot find symbol
symbol  : class OracleDataSource
location: class JDBCVersion
OracleDataSource ods = new OracleDataSource();
                           ^
4 errors

Can someone help me solve this problem?

Thanks, Sopolin

Answer 1

I'm not sure what you meant here.

Class_Path: %ORACLE_HOME%\jlib\orai18n.jar;%ORACLE_HOME%\oui\jlib\classes12.jar 
Path: %Oracle_home%\jdbc\ojdbc6.jar

All banks should be in class_path.

You will need dll directories on your PATH.

Answer 2

JDBC Oracle, ojdbc6.jar CLASSPATH. , - JAR PATH .

JDBC Oracle JDBC/UCP Oracle.

, classes12.jar , ojdbcX.jar CLASSPATH.

, Oracle Thin Driver JDBC 11g, ojdbc5.jar/ojdbc6.jar orai18.jar CLASSPATH. OCI.

Answer 3

, - JAR- JDBC. , , 12.jar ojdbc6.jar. - JDK 1.2; . JDK 6, ojdbc6.jar.

I would also advise you to use the java.sql interfaces, rather than the special Oracle classes for your static types, in order to support generic code. This is just a sample, but you will want to keep this for your real applications.