Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » JFace » Jface SQLite(Database lock)
Jface SQLite [message #991026] Mon, 17 December 2012 05:52 Go to next message
Prashant p is currently offline Prashant p
Messages: 57
Registered: October 2012
Member
Hi,

I am developing an SWT/Jface application. Using ibatis as middleware and SQLite as DB. My issue is when ever i try to insert values into DB after hitting submit button, SQLite database get locked/hanged. But this doesn't happen when i do direct unit test with Ibatis SQL lite. Below is the exception i am getting

ERROR [main] - Error calling Connection.commit:
java.sql.SQLException: database is locked
Re: Jface SQLite [message #991035 is a reply to message #991026] Mon, 17 December 2012 07:07 Go to previous messageGo to next message
Thomas Schindl is currently offline Thomas Schindl
Messages: 5400
Registered: July 2009
Senior Member
This has nothing to do with JFace, ask at an SQLLite forum

Tom

Am 17.12.12 06:52, schrieb Prashant p:
> Hi,
>
> I am developing an SWT/Jface application. Using ibatis as middleware and
> SQLite as DB. My issue is when ever i try to insert values into DB after
> hitting submit button, SQLite database get locked/hanged. But this
> doesn't happen when i do direct unit test with Ibatis SQL lite. Below is
> the exception i am getting
>
> ERROR [main] - Error calling Connection.commit:
> java.sql.SQLException: database is locked
Re: Jface SQLite [message #991046 is a reply to message #991035] Mon, 17 December 2012 07:51 Go to previous messageGo to next message
Prashant p is currently offline Prashant p
Messages: 57
Registered: October 2012
Member
Since SQLite is single threaded...i guess threading priority need to be taken care at Jface/SWT end
Re: Jface SQLite [message #991049 is a reply to message #991046] Mon, 17 December 2012 08:04 Go to previous message
Prashant p is currently offline Prashant p
Messages: 57
Registered: October 2012
Member
i mean like synchoronization etc...
Previous Topic:OwnerDrawLabelProvider#paint receives lots of FocusOut events
Next Topic:selectionChangedListener and viewer.setSelection
Goto Forum:
  


Current Time: Tue Oct 21 09:05:51 GMT 2014

Powered by FUDForum. Page generated in 0.03481 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software