Eclipse Community Forums: JFace

Home » Eclipse Projects » JFace » Jface SQLite(Database lock)

Mon, 17 December 2012 00:52

Eclipse User

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 02:07

Eclipse User

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 02:51

Eclipse User

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 03:04

Eclipse User

i mean like synchoronization etc...

Previous Topic:	OwnerDrawLabelProvider#paint receives lots of FocusOut events
Next Topic:	selectionChangedListener and viewer.setSelection

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 27 00:25:05 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter