Thanks for all the input guys.
I eventually solved the non-connection problem by replacing
Class.forName("oracle.jdbc.driver.OracleDriver");
with
DriverManager.registerDriver // load driver
(new oracle.jdbc.driver.OracleDriver());
I'm not sure why this works over the previous line...but it does. Perhaps
some of the Java gurus can enlighten us!
As for the CLASSPATH issue...I believe that that has been a complete red
herring! I simply added classes12.zip to my CLASSPATH variable wherever I
found it on the filesystem (ie. $ORACLE_HOME/jdbc/lib ) and that seemed to
work. Despite my earlier attempts, I'm not sure what all the talk about the
ojdbc14.jar file being the CLASSPATH variable was all about - would I be
right in assuming that this is Type 4 driver, and subsequently works better
than that originally shipped with Oracle 8.1.7??? Notwithstanding that the
driver found in 'classes12.zip' also works, but perhaps not as efficiently
as the later ojdbc14.jar?
Cheers
Brad
"Brad" <nospam_at_arach.net.au> wrote in message
news:3fb2eeec_at_funnel.arach.net.au...
> Thanks for quick reply Andrew.
>
> I copied your example and edited it slightly for the Oracle connection
side.
> But am having some problems here. My code is listed below, together with
> the error that I get when running it.
>
>
> =======================
> import java.sql.*;
>
> public class SQLTest
> {
> public static void main(String[] args)
> {
> String sSQL=""; // Used to build up longer SQL strings in chunks
> try
> {
> Class.forName("oracle.jdbc.driver.OracleDriver");
> Connection conn =
>
DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:PROD","scott",
> "tiger");
> Statement st = conn.createStatement();
> sSQL = sSQL + "SELECT job FROM emp";
> sSQL = sSQL + " WHERE ename = '" + args[0] + "'";
> ResultSet rec = st.executeQuery(sSQL);
> System.out.println("job:");
> while (rec.next())
> {
> System.out.println(rec.getString(1));
> }
> st.close();
> }
> catch (ClassNotFoundException e)
> {
> e.printStackTrace();
> System.err.println("Caught Exception: " + e.getMessage());
> }
> catch (SQLException e)
> {
> e.printStackTrace();
> System.err.println("Caught Exception: " + e.getMessage());
> }
> }
> }
>
> =======================
> It seems to compile OK when I use:
>
> javac SQLTest.java
>
>
> My CLASSPATH has been set as (I copied the Oracle .zip files into my $HOME
> directory as .jar files after reading somewhere that sometimes the
> difference could be in the file extension not being '.jar'???) :
>
>
./classes12.jar:./classes111.jar:/apps/oracle/8.1.7/jdbc/lib/classes111.zip:
> /apps/oracle/8.1.7/jdbc/lib/classes12.zip:/usr/java/jre/lib/rt.jar
>
>
> And I execute the above using the following:
>
> java -cp . SQLTest TURNER
>
>
> I get the following error message:
>
> java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
> at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
> at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
> at java.lang.Class.forName0(Native Method)
> at java.lang.Class.forName(Class.java:140)
> at SQLTest.main(SQLTest.java:10)
> Caught Exception: oracle.jdbc.driver.OracleDriver
>
>
>
> Any ideas guys??
>
> Cheers
> Brad
>
>
> "Andrew Jens" <> wrote in message
> news:3fb2dd55$0$1746$5a62ac22_at_freenews.iinet.net.au...
> > "Brad" <nospam_at_arach.net.au> wrote in message
> > news:3fb2b407$1_at_funnel.arach.net.au...
> > > Hi there all,
> > >
> > > I am new to Java and am wondering if anyone can help me with posting
> some
> > > sample code listings for the following.
> > >
> > > I would like to be able to perform a SELECT statement against an
Oracle
> > > database, except passing in the value of my WHERE clause as a paramter
> to
> > > the java program.
> > >
> > > For Example:
> > >
> > > java SimpleSelectJavaCode SMITH
> > >
> > > which would perform a connection to the database and also a SELECT
> > statement
> > > against Oracle something similar to ....WHERE ename = 'SMITH'
> > >
> > >
> > > Ultimately, I'd like to have a JSP page taking the input from a HTML
> FORM,
> > > and passing this to a java bean where the SQL statement is executed
and
> > the
> > > results returned to the browser.
> > >
> > > Can anyone help me with this?
> > >
> > > Thanks in advance.
> > >
> > > Brad
> > >
> > >
> >
> > Hi,
> > Let me start by saying that I'm no expert - plus I don't know much about
> > Oracle, but the following may get you some of the way there. Here is
some
> > source code in a file called SQLTest.java:
> > ==================================================================
> > import java.sql.*;
> >
> > public class SQLTest
> > {
> > public static void main(String[] args)
> > {
> > String sSQL=""; // Used to build up longer SQL strings in chunks
> > try
> > {
> > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > Connection conn =
> > DriverManager.getConnection("jdbc:odbc:Customer","", "");
> > Statement st = conn.createStatement();
> > sSQL = sSQL + "SELECT Firstname FROM Customers";
> > sSQL = sSQL + " WHERE ename = '" + args[0] + "'";
> > ResultSet rec = st.executeQuery(sSQL);
> > System.out.println("Firstnames:");
> > while (rec.next())
> > {
> > System.out.println(rec.getString(1));
> > }
> > st.close();
> > }
> > catch (ClassNotFoundException e)
> > {
> > e.printStackTrace();
> > System.err.println("Caught Exception: " + e.getMessage());
> > }
> > catch (SQLException e)
> > {
> > e.printStackTrace();
> > System.err.println("Caught Exception: " + e.getMessage());
> > }
> > }
> > }
> > ==================================================================
> > After compilation, this can be run with the command line: java SQLTest
> SMITH
> >
> > This works under M$ Windows with a SystemDSN called Customer pointed at
an
> > Access Database. I don't see why you couldn't point the Customer DSN at
an
> > Oracle database instead.
> > The above code loops through a result set, however I realise that if
ename
> > is unique you will only get back one record.
> > I'll leave it to someone else to handle the web page version
> > Cheers,
> > Andrew Jens.
> >
> >
>
>
Received on Mon Nov 17 2003 - 05:30:38 CST
