Re: jdbc problem

From: Claus E. Petersen <cepeters_at_bellesystems.com>
Date: Wed, 31 Jan 2001 17:55:28 +0100
Message-ID: <3a78493e$0$3191$73beb97d_at_news.dk.uu.net>

It worked for me, with a few minor changes:

import java.sql.*;
import java.io.*;

class JdbcCheck
{

        public static void main (String args []) throws SQLException,IOException

        {
                DriverManager.registerDriver(new

oracle.jdbc.driver.OracleDriver());

               // My compiler never heard of a defaultConnection() method, so i used this instead:

               Connection conn =
DriverManager.getConnection("jdbc:oracle:thin:_at_hostname:port:SID",username,p assword);

                // Connection conn = new

oracle.jdbc.driver.OracleDriver().defaultConnection();

                Statement stmt = conn.createStatement ();
                ResultSet rset = stmt.executeQuery ("select 'Hello World'
from dual");
                while (rset.next ())
                System.out.println (rset.getString (1));
        }

}

compiled with javac -classpath .:classes111.zip JdbcCheck.java run with:java -cp .:classes111.zip JdbcCheck

I'm running Oracle 8.0.6 on a Solaris, using classes111.zip for Oracle specific classes, Java is JDK1.2.

Regards, claus petersen

edipko01 <edipko01_at_home.com> wrote in message news:3A6BB778.7020603_at_home.com...
> Having problems executing jdbc sample program:
>
> import java.sql.*;
> import java.io.*;
> class JdbcCheck
> {
> public static void main (String args []) throws
> SQLException,IOException
> {
> DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
> Connection conn =
> new oracle.jdbc.driver.OracleDriver ().defaultConnection ();
> Statement stmt = conn.createStatement ();
> ResultSet rset = stmt.executeQuery ("select 'Hello World' from
 dual");
> while (rset.next ())
> System.out.println (rset.getString (1));
> }
> }
>
> ********************************
>
> Code compilies ok, but when execute I get:
> Exception in thread "main" java.lang.NoClassDefFoundError: JdbcCheck
>
> Also, if I do:
> loadjava -thin -user baskets/baskets_at_C717244-A:1521:db -resolve
> JdbcCheck.java
>
> I get:
> internal error: unanticipated exception: java.lang.NoClassDefFoundError:
> oracle/aurora/sqljdecl/SqljDecl
> java.lang.NoClassDefFoundError: oracle/aurora/sqljdecl/SqljDecl
> at
> oracle.aurora.server.tools.loadjava.SourceFileReader.getScanner(Compiled
> Code)
> at
> oracle.aurora.server.tools.loadjava.SourceFileReader.getFirstName(Compiled
> Code)
> at
> oracle.aurora.server.tools.loadjava.LoadJava.noteSource(Compiled Code)
> at
> oracle.aurora.server.tools.loadjava.LoadJava.processLoadAndCreate(Compiled
> Code)
> at
> oracle.aurora.server.tools.loadjava.LoadJava.process(Compiled Code)
> at
> oracle.aurora.server.tools.loadjava.LoadJavaMain.run(Compiled Code)
> at
> oracle.aurora.server.tools.loadjava.LoadJavaMain.main(Compiled Code)
> loadjava: 1 errors
>
>
> I have set the CLASSPATH and LD_LIBRARY_PATH variables as instructed in
> the $ORACLE_HOME/jdbc/Readme.txt file. I am running 8.1.6 on Redhat
> Linux 7.
>
> Any help will be greatly appreciated.
> Ernie
>
Received on Wed Jan 31 2001 - 17:55:28 CET