Re: JDBC driver problem

adachtler_at_web.de (Axel Dachtler) wrote in message news:<d6193773.0312160407.39c45273_at_posting.google.com>...
> Hello,
>
> my Java-program can't load the JDBC driver.
> I always get a java.lang.NoClassDefFoundError when I run it.
>
> The JDBC Driver is in the directory: C:\programs\ora92\jdbc\lib
>
> I think I have to set ORACLE_HOME environment variable and CLASSPATH,

You don't need ORACLE_HOME. To set CLASSPATH type in the same command session where you want to execure java program:

SET CLASSPATH=C:\programs\ora92\jdbc\lib\classes12.zip

If CLASSPATH is set already (check it with "echo %CLASSPATH%" command) use:
SET CLASSPATH=%CLASSPATH%;C:\programs\ora92\jdbc\lib\classes12.zip

Make sure you use correct name of the driver file.

> but I have no idea how ?????????
>
> Thanks
>
> Axel
>
>
> --------------------------------------------------
> program:
>
> import java.sql.*;
>
> class Employee
> {
> public static void main (String args [])
> throws SQLException
> {
> // Load the Oracle JDBC driver
> DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
>
> // Connect to the database
> // You can put a database name after the _at_ sign in the connection URL.
> Connection conn =
> DriverManager.getConnection
> ("jdbc:oracle:oci8:_at_axel-0560nntbn1:1521:oracle", "scott", "tiger");
>
> // Create a Statement
> Statement stmt = conn.createStatement ();
>
> // Select the ENAME column from the EMP table
> ResultSet rset = stmt.executeQuery ("select ENAME from EMP");
>
> // Iterate through the result and print the employee names
> while (rset.next ())
> System.out.println (rset.getString (1));
>
> // Close the RseultSet
> rset.close();
>
> // Close the Statement
> stmt.close();
>
> // Close the connection
> conn.close();
> }
> }
Received on Thu Dec 18 2003 - 19:51:28 CET