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
Closed Statement errors during large volume updates
< Previous Thread     Next Thread >
Author
Thread    Post New Thread     Post A Reply
BHLossini
Member

Registered: Jun 2005
Posts: 7

Our installation is using CocoBase 4.5 tied to an Oracle 9.i database running under iPlanet 6.5 application server. We are having an issue with large volume updates (4,000+ rows - 1 at a time) where it appears that CCB is closing or losing DB connections. Within the web application, we have a Java Collection of 4,000+ objects that represent 4,000 database rows that need to updated. The rows are iterated from the Collection and the PersistenceMgr.updateInstance() is called. Within 2-3 minutes we encounter the error.

The actual runtime error is:

2006-04-21 13:44:36,830,ERROR,,[CocoBasePersistenceManager.updateInstance] : Exception: Closed Statement,Closed Statement thought.CocoBase.CocoBaseException: CBMessage=Update failed in Database SQL.CoreMessage=Closed Statement CocoBaseErrorCode=DBUPDATE_FAILURE
at thought.CocoBase.CocoPowder.update(CocoPowder.java:13007)
at thought.CocoBase.CocoPowderPlugin20.update(CocoPowderPlugin20.java:2332)
...etc...
Sometimes we get additional messages from the application server indicating "java.sql.SQLException: Logical handle no longer valid". So perhaps it is a DB issue and not a CCB issue?

Is there a configuration setting someplace that needs to be set for CCB to handle this type of volume?
Is there a way in CCB to have multiple updates occur in the equivelant of a single SQL update statement?
Any other suggestions to help us track down this issues would be appreciated.

04-21-2006 11:05 AM
Click Here to See the Profile for BHLossini    Find more posts by BHLossini        Edit/Delete Message    Reply w/Quote    IP: Logged
support
Super Moderator

Registered: Apr 2001
Posts: 1

Hi,

This seems related to your connection pool timeout configuration. Please check if the timout of your server connection pool/prepared statement cache is to low for the volume of data you are trying to update. Also, consider using batch inserts/updates for better performance.

THOUGHT Support

04-21-2006 01:33 PM
Click Here to See the Profile for support    Find more posts by support        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.