Re: Oracle JDBC problem

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.  

rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0301201935.56d719d_at_posting.google.com>...
> qwert12345_at_boxfrog.com (Doug Baroter) wrote in message news:<fc254714.0301201527.be52044@posting.google.com>...
> > SQL: select banner from v$version
> > against an Oracle9i db resulted in the following error:
> >
> > ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [],
> > [], [], [], []
> >
> > I don't have access to Oracle's bug reporting web site, could some one
> > kindly post it?
> >
> > Secondly, is there any alternative to find current server version
> > other than the above query? Thanks.
>
>
> ORA-00600 is an internal error and should be reported to Oracle by
> you. I just tested this code against a 9i R2 database without any
> errors... so problem must be somewhere in your
> code/installation/database.
>
> import java.sql.*;
>
> public class Test {
>
> public static void main (String args[])
> throws Exception {
>
> DriverManager.registerDriver(new
> oracle.jdbc.driver.OracleDriver());
> String url = "jdbc:oracle:oci8:_at_" + args[0];
> Connection conn =
> DriverManager.getConnection (url, args[1], args[2]);
>
> Statement stmt = conn.createStatement ();
> ResultSet rset = stmt.executeQuery ("select banner from
> v$version");
> while (rset.next())
> System.out.println(rset.getString(1));
> rset.close();
> stmt.close();
> conn.close();
> }
> }
>
> Here is command prompt output
>
> C:\JavaDev\test>javac Test.java
>
> C:\JavaDev\test>jview Test.class test920 "sys as sysdba" password
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> PL/SQL Release 9.2.0.1.0 - Production
> CORE 9.2.0.1.0 Production
> TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
> NLSRTL Version 9.2.0.1.0 - Production
>
> Regards
> /Rauf Sarwar
Received on Tue Jan 21 2003 - 20:04:02 CET