Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / March 2004

Tip: Looking for answers? Try searching our database.

com.ibm.db2.jcc.b.SQLException: bug check

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Prakash - 17 Mar 2004 07:41 GMT
Hi

I am wondering whether anyone had this issue earlirt. I haven't seen
any posting on this exception.

Here is the scenario: We migrated from Oracle (US7ASCII) database to
DB2 (UTF8) recently. We used db2load util to load all the data (no
codepage specified in the db2load command)

What we found now is, whenever our application is trying to access a
record which has accent characters on it (like e with accute, HEX
value E9) it throws the following exception

LOCAL EXCEPTION STACK:
EXCEPTION [TOPLINK-4002] (TopLink - 9.0.3 (Build 423)):
oracle.toplink.exceptions.DatabaseException
EXCEPTION DESCRIPTION: com.ibm.db2.jcc.b.SQLException: bug check
INTERNAL EXCEPTION: com.ibm.db2.jcc.b.SQLException: bug check
ERROR CODE: -99999

But I can insert the row with accent characters on it and it is fine.
Its only problem with db2load(ed) rows.

Any idea what this means?

I tried to reload the data with codepage=1250 and it seems to be
working. But I am afraid of setting that codepage, thinking it may
cause any other issue.

I appreciate your help on this.

Thanks

V Prakash
Fan Ruo Xin - 18 Mar 2004 05:27 GMT
Apply the fixpak 4a or fixpak5.
I got some unexpected sql exception (error code = -99999), it looks like the
error I met is fixed after I upgrade to fixpak4a.

> Hi
>
[quoted text clipped - 30 lines]
>
> V Prakash
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.