aspose file tools*
The moose likes JDBC and the fly likes ORA-00600 [ttcgcshnd][0][ ][ ] ...problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ORA-00600 [ttcgcshnd][0][ ][ ] ...problem" Watch "ORA-00600 [ttcgcshnd][0][ ][ ] ...problem" New topic
Author

ORA-00600 [ttcgcshnd][0][ ][ ] ...problem

Ashutosh Limaye
Ranch Hand

Joined: Oct 24, 2005
Posts: 58
hello all,
I'am trying to connect to Oracle database using Type-4 driver.
The problem is the driver gets loaded...I get the connection object.
I also get the statement object form the con obj.
But when i try to call executeQuery() on stmt I get the following error...

SqlException...internal error ORA-00600 [ttcgcshnd-1],[0],[],[],[],[]

I am working with Oracle 9i and Weblogic 6.1 servers
please help...
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61002
    
  65

Moved to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
ORA-600 is generally "call Oracle".

This particular one can show up when using a pre-9i driver with a 9i or later database; the best solution is to upgrade drivers. I think Oracle support may have a workaround if that's not an option.

It can also show up when the driver checks the local character set on the client side and finds it to be invalid.
Ashutosh Limaye
Ranch Hand

Joined: Oct 24, 2005
Posts: 58
The Driver that i am using is a 9i driver...this problem is specifically occuring for Type4 driver it doesn't occur for Type1...
Somebody had suggested me to put the drivers path in the classpath variable
in the config.xml file...but i am unable to locate the variable in the file....
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

I would suggest check the class path , if there are multiple jars available and you are pinting to a wrong one.

Also pick jar file from your oracle installation and use same.

Once I faced similar problem which got resolved by replacing driver.

Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333

The Driver that i am using is a 9i driver...


It wouldn't surprise me if you're actually using an older driver that's installed in Weblogic. It's pretty easy to find out...

Here's a main program I have lying around to get some driver/database info.
You will need to convert it to a JSP and run it in your Weblogic installation. You'll also need to fix the database URL, user and password.

 
It is sorta covered in the JavaRanch Style Guide.
 
subject: ORA-00600 [ttcgcshnd][0][ ][ ] ...problem