Re: Oracle JDBC problem

Rauf,

Thanks. I created the java class in DOS Edit, then Set classpath accordingly,
but I don't know why I got compilation error as follows: jdbc\lib\Test.java:15: unclosed string literal (

   ResultSet rset = stmt.executeQuery ("select banner from v$version");
^
another ^ under the double quote before select.

jdbc\lib\Test.java:18: ')' expected
  System.out.println(rset.getString(1)); ^ under semicolon

Could it relate to OCI driver setup/configuration etc.? since database connection fails when I tried JDBC url config using "jdbc:oracle:oci:_at_db"
while JDBC url config using "jdbc:oracle:jdbc:_at_serverName..." verfies that the connection is established but actually not via the third party. Again thanks.

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0301221458.cb98c0b_at_posting.google.com>...
> qwert12345_at_boxfrog.com (Doug Baroter) wrote in message news:<fc254714.0301220903.5ebda61d_at_posting.google.com>...
> > Rauf,
> >
> > Thank you very much for the follow-up, though I've modified the
> > classpath according to your suggestion and verfied setup with
> > recommendation from README, same error persists; as for Oracle
> > metalink, unfortunately, I'm using Oracle9i eval, so, I don't have
> > account to register at the site, hence, unable to post the question
> > there. Any other remedy? Thanks.
>
>
> You can copy the test java code from my previous post. Compile and run
> and see if you get the error from there. If you do then it is driver
> related otherwise it may be related to your third party AS.
>
> C:\> set classpath=ORACLE_HOME\ora92\jdbc\lib\<.zip or
> .jar>;%classpath%
> C:\> javac Test.java
> C:\> java or jview Test.class <Service name from tnsnames.ora> <sys>
> <password>
>
> I used Jdk1.3.1_02 to compile and test.
>
> Good luck
> /Rauf Sarwar
Received on Thu Jan 23 2003 - 16:17:26 CET