Thought inc.

The Dynamic O/R Mapping Company

CocoBase Technical Support Forums
For access to developer site with software download and doc's, please request CocoBase download and password
will be emailed to you. Response to posts will appear when answered by THOUGHT Support team.
NOTE:You must register separately with forum in order to post your questions, please click on register icon below.
Home   Frequently Asked Questions   Search   Edit your profile   Registration is free!  
Email This Page to Someone!
Show a Printable Version
CocoBase Enterprise O/R Forums > CocoBase Questions
CocoBase 4.5 with Oracle 10g, incompatible?
< Previous Thread     Next Thread >
Thread    Post New Thread     Post A Reply

Registered: Jun 2007
Posts: 9


I'm using cocobase 4.5, in fact, I think it is 4.5 as not sure how to check it.

I'm trying to migrate this application from oracle 8i to 10g and my first question is if they are compatible as I'm having some issues not sure how to fix, for example this one:

2007-06-18 11:57:27,731 [P=393711:O=0:CT] loadSAllObjects failed, no objects have been loaded: Cannot load all objects object; session invalid
error code: INVALIDSTATE_ERROR detail message: thought.CocoBase.CocoBaseException: CBMessage=Select failed due to a low level exception.CoreMessage=Negative scale CocoBaseErrorCode=DBSELECT_FAILURE

All answers will be apreciated

many thanks

06-18-2007 08:11 AM
Click Here to See the Profile for CristianRubio    Find more posts by CristianRubio        Edit/Delete Message    Reply w/Quote    IP: Logged

Registered: Apr 2001
Posts: 19

To confirm your version of CocoBase:

You can check which version of CocoBase you're using, either by instantiating an instance of thought.CocoBase.CocoPowder, and printing the string cocopowderinstance.getVersion(), and/or you can check the version.txt file in your %coco_home%\version.txt file.

To resolve your issue with the NegativeScale, most likely this is resulting from bad jdbc result set meta data. By default, the CocoBase runtime in recent releases sets the cocoprop property of "use.resultscale" to true. What this property does is uses the Result Set Metadata to determine the scale of bigdecimal numbers (resultSetMetadata.getScale(fieldposition) is the specific facility. Sometimes jdbc drivers return invalid (negative) result scale values - and then when that jdbc value is used, then the resulting jdbc resultSet.getBigDecimal(fieldposition,scale) fails to read the value properly.

Have you enabled debug to confirm what's actually happening with the SQL to see if this is the problem?


06-18-2007 10:56 AM
Click Here to See the Profile for admin    Find more posts by admin        Edit/Delete Message    Reply w/Quote    IP: Logged
All times are PST (US)    Post New Thread     Post A Reply
Forum Jump:
< Previous Thread     Next Thread >

Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author. Messages can be deleted by their author.
Posts: HTML code is OFF. Smilies are OFF. vB code is OFF. [IMG] code is OFF.

Admin Options:
Open / Close Thread
Move Thread
Delete Thread
Edit Thread

< Contact Us - THOUGHT Inc. >

Copyright © Jelsoft Enterprises Limited 2000.
Copyright 2001 All Rights Reserved, THOUGHT Inc.