Re: JDBC + Oracle 8.1.5 personal

Hi,
  the classes111.zip file is for the thin driver. (not oci). So change your getConnection to use ("jdbc:oracle:thin@<your machinesIP>:<dblistener port>:<dbname>", "scott", "tiger");

 Also, since you are using jdk1.3, you should be using the java2 thin driver, which will be found in a classes12.zip file.

You can find useful information at
http://technet.oracle.com/tech/java/sqlj_jdbc/index.htm. This requires a technet account, but those are free, so go and register and enjoy!

hth,
cindy

peter30 wrote:

> Hi,
>
> I am a newbie. I am writing a java application to access oracle
> databases. I use JDK1.3 and oracle 8.1.5 personal edition, which are
> all installed on the same PC running windows98. The environment was set
> as:
>
> Path=d:\oracle\ora81\bin;d:\oracle\ora81\jdbc\lib;d:\jdk1.3\bin;
> CLASSPATH=d:\oracle\ora81\jdbc\lib\classes111.zip;d:\oracle\ora81\jdbc\lib\nls_chaset11.zip;
>
> The JDBC part of java program like this:
> Class.forName("oracle.jdbc.driver.OracleDriver");
> Connection conn = DriverManager.getConnection ("jdbc:oracle:oci8",
> "scott","tiger");
>
> The program was compiled with no error. But when excuting it, "No valid
> driver" was reported for getConnection line.
>
> I don't know why? Do I need to configure Listener and Net service name
> ? How to do it? It seems that the java program don't know where the
> database is, though they are running on the same computer.
>
> Thanks a lot.
>
> Peter.
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Tue Aug 08 2000 - 00:00:00 CDT