• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Ashutosh Limaye
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 64617
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moved to the JDBC forum.
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic