Re: Oracle JDBC problem

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.

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0301211553.101f272a_at_posting.google.com>...
> qwert12345_at_boxfrog.com (Doug Baroter) wrote in message news:<fc254714.0301211104.31edddad_at_posting.google.com>...
> > Thanks for the response. Here's more info:
> > - same SQL statement executes fine on the same Oracle9i DB via
> > SQL*PLUS client.
> > - same SQL statement executes fine on an Oracle8i DB either via
> > SQL*PLUS client or via the application interface I'm using now.
> > - my application is excecuted by an application server called CFMX by
> > Macromedia
> > - under my Oracle installation's jdbc directory, the README file reads
> > "Oracle JDBC Drivers release 9.2.0 README", so, I assume it's JDBC 9
> > driver.
> > - I tried some other SQL statement against the Oracle9i DB via the
> > application also failed
> > - and the weird thing is, the datasource connection is verified as OK
> > via the CFMX's interface.
> >
> > Any further thoughts would be appreciated.
>
>
> There is a known bug posted in Oracle metalink about using pre-9i JDBC
> thin driver to connect to 9.0.1 database [ORA-00600 error]. It may
> have been fixed in 9.2 because I tested the same connection from my
> first post using thin JDBC driver from 8i to connect to 9.2 and it
> worked fine.
>
> 1) Check your classpath variable to see that there is no reference to
> ORACLE8i_HOME\jdbc\lib\classesxx.zip. If there is then replace it with
> ORACLE9i_HOME\jdbc\lib\classesxxx.zip|ojdbc<Ver>.jar.
>
> Read section "Setting Up Your Environment" under the readme.txt file
> that you mentioned in your post. It also has other usefull info. If
> problem still persists, I would suggest you visit
> http://metalink.oracle.com and post it there.
>
> Regards
> /Rauf Sarwar
Received on Wed Jan 22 2003 - 18:03:23 CET