Advertisement

04.27.2008 at 07:15AM PDT, ID: 23356977 | Points: 500
[x]
Attachment Details
ORA-00600
Hi

When iam trying to retretive varchar2 from Oracle 9i DB to Netbeans Jtabel, the system give me this error (with arguments), but no problems with number.

ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []

this is my code:

try{
Class.forName ("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
Statement stmt = conn.createStatement();

ResultSet rset = stmt.executeQuery("select SUPPLIER_NAME from suppliers");

int i = 0;
//Vector rows = new Vector();
while (rset.next()){

String s1=null,s;
//Vector<Object> newRow = new Vector<Object>();
//String s = null;

s = s1.valueOf(rset.getObject(1));
//newRow.addElement(rset.getObject(1));
System.out.println (s);

//jTable1.setValueAt(s, i, 0);
//jTable1.setValueAt(newRow.elementAt(0), i, 0);
i++;
//rows.addElement(newRow);
}

rset.close();
stmt.close();
} catch (Exception e) {
e.printStackTrace();
}

I think its Datatype Converstion Problem, help me.
Start your free trial to view this solution
Question Stats
Zone: Software
Question Asked By: declofeeen
Question Asked On: 04.27.2008
Participating Experts: 2
Points: 500
Views: 0
Translate:
Loading Advertisement...
04.27.2008 at 08:38AM PDT, ID: 21449402

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.27.2008 at 10:06AM PDT, ID: 21449669

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.27.2008 at 10:54AM PDT, ID: 21449794

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.27.2008 at 11:30AM PDT, ID: 21449913

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
04.27.2008 at 12:51PM PDT, ID: 21450192

Rank: Sage

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
04.27.2008 at 08:38AM PDT, ID: 21449402

Rank: Master

I don't get why are you using getObject to retrieve a varchar2?...

use getString method to retrieve it...
some jdbc drivers have problem if you call getObject, getClob, getBlob or getXML methods...
 
04.27.2008 at 10:06AM PDT, ID: 21449669
Ok, I using getString but also it dosent work, it gives the same error

try{
        Class.forName ("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
//                DriverManager.getConnection("jdbc:oracle:oci8:@127.0.0.1:1521:ORCL", "scott", "tiger");    
Statement stmt = conn.createStatement();
       
ResultSet rset = stmt.executeQuery("select SUPPLIER_NAME from suppliers");
       
        int i = 0;
        //Vector rows = new Vector();
        while (rset.next()){
           
            String s1=null,s;
            //Vector<Object> newRow = new Vector<Object>();
            //String s = null;
           
            s = s1.valueOf(rset.getString(1));
            //newRow.addElement(rset.getString(1));
                         System.out.println (s);
                         
                         jTable1.setValueAt(s, i, 0);
                         //jTable1.setValueAt(newRow.elementAt(0), i, 0);
                         i++;
                   //rows.addElement(newRow);
       }
       
        rset.close();
        stmt.close();
} catch (Exception e) {
              e.printStackTrace();
        }
 
04.27.2008 at 10:54AM PDT, ID: 21449794

Rank: Master

Which statement this error is encountered at?
at executeQuery? or at rset.getString();

i believe this is the problem with your jdbc driver.. which one are you using? try downloading the latest oracle jdbc driver...
 
04.27.2008 at 11:30AM PDT, ID: 21449913
the problem is
at Suppliers.jButton3ActionPerformed(Suppliers.java:312)

that means in executeQuery
ResultSet rset = stmt.executeQuery("select SUPPLIER_NAME from suppliers");

my JDBC driver version is 8.1.6.0.0
if i need to download the latest version oracle jdbc driver, please give me the latest version or give me a link to download it.
 
04.27.2008 at 12:51PM PDT, ID: 21450192

Rank: Sage

Note: For additional ORA-600 related information please read Note 146580.1

PURPOSE:
  This article discusses the internal error "ORA-600 [ttcgcshnd-1]", what
  it means and possible actions. The information here is only applicable
  to the versions listed and is provided only for guidance.

ERROR:
  ORA-600 [ttcgcshnd-1] [a]

VERSIONS:
  versions 9.0 to 9.2

DESCRIPTION:

  Oracle is checking that the local character set id is valid as part
  of the process to do character data conversions between different
  character sets.

  This error is raised when the local character set id is found to
  be invalid.

ARGUMENTS:
  Arg [a] Local character set id

FUNCTIONALITY:
  Two Task Common Convert type x to type y
  client/server connect using JCBC Thin Driver

IMPACT:
  PROCESS FAILURE
  NON CORRUPTIVE - No underlying data corruption.

SUGGESTIONS:

  Known Issues:

  Bug# 1725012   See Note 1725012.8
      OERI:ttcgcshnd-1 using JDBC thin pre-9i to 9i database
      Fixed: 8.1.7.2, 9.0.1.0
 
 
 
20080236-EE-VQP-29 / EE_QW_2_20070628