Normal Topic Transaction Rollback without XResultSetClose (Read 704 times)
MP
Full Member
***
Offline



Posts: 104
Joined: Sep 3rd, 2007
Transaction Rollback without XResultSetClose
Jan 30th, 2008 at 12:24am
Print Post Print Post  
(Cross-posted to Lantica Online Support)

I didn't verify if this is new to 2.0.5, but today is the first time I noticed this.  In Client/Server mode, if you add records using XResultSetCreateNewRecord but fail to properly call XResultSetClose, the records are deleted from the database when the client application that made the calls is shut down.  It's hard for me to classify this as a bug, since technically this is a legitimate response to a failure to explicitly close a resource.  And if Lantica choses not to classify this as a bug, then this thread acts as a forewarning to other Sesame developers...always close your result set!
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Transaction Rollback without XResultSetClose
Reply #1 - Jan 30th, 2008 at 12:26am
Print Post Print Post  
Definitely always close your result sets. Otherwise, your last affected record may never get an opportunity to commit. As you've discovered.  Smiley
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged