Eclipse Community Forums: EMF "Technology" (Ecore Tools, EMFatic, etc) » HbDataStore.close() throwing SQLException

Help

Home

Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc) » HbDataStore.close() throwing SQLException

Show: Today's Messages :: Show Polls :: Message Navigator

HbDataStore.close() throwing SQLException [message #82706]

Wed, 09 May 2007 14:27

Paul Gardiner

Messages: 94
Registered: July 2009

Member

Whenever I call HbDataStore.close(), or HbHelper.INSTANCE.closeAll(), I get
a SQLException "Cannot close a connection while a transaction is still
ative.". However, I have not opened any transactions myself, and all of my
sessions are closed, so I figure something during initialize() must have not
committed a transaction. Is there anything I have to do to make sure all
changes during initialization are committed?

Report message to a moderator

Re: HbDataStore.close() throwing SQLException [message #82712 is a reply to message #82706]

Wed, 09 May 2007 14:38

Parvez

Messages: 181
Registered: July 2009

Senior Member

I normally call before that

session.flush();
session.clear();

Paul Gardiner wrote:
> Whenever I call HbDataStore.close(), or HbHelper.INSTANCE.closeAll(), I get
> a SQLException "Cannot close a connection while a transaction is still
> ative.". However, I have not opened any transactions myself, and all of my
> sessions are closed, so I figure something during initialize() must have not
> committed a transaction. Is there anything I have to do to make sure all
> changes during initialization are committed?
>
>

Report message to a moderator

Re: HbDataStore.close() throwing SQLException [message #82715 is a reply to message #82712]

Wed, 09 May 2007 15:37

Paul Gardiner

Messages: 94
Registered: July 2009

Member

Thanks. That seems to do it. I figured a close already flushed and cleared
it, but I guess not.

"PC" <p.chauhan@pilz.ie> wrote in message
news:f1smd7$md9$1@build.eclipse.org...
>I normally call before that
>
> session.flush();
> session.clear();
>
>
>
> Paul Gardiner wrote:
>> Whenever I call HbDataStore.close(), or HbHelper.INSTANCE.closeAll(), I
>> get a SQLException "Cannot close a connection while a transaction is
>> still ative.". However, I have not opened any transactions myself, and
>> all of my sessions are closed, so I figure something during initialize()
>> must have not committed a transaction. Is there anything I have to do to
>> make sure all changes during initialization are committed?

Report message to a moderator