java.sql.SQLException: database is locked while using in SWT

Question

I am trying to delete SWT table row using SWT/Jface datadinding to DB through ibatis implementation.

I am getting below exception whenever i try to do insert or delete operation from client side (SWT).

org.apache.ibatis.exceptions.PersistenceException: 
### Error committing transaction.  Cause: java.sql.SQLException: database is locked

This doesn't happen when i try to hit DB (SQLite) through ibatis directly.

Below is the code section for delete operation i am doing with SWT button and trying to delete SWT table row.

SWT Code....

btnDeleteWorkspaceRow.addSelectionListener(new SelectionAdapter() {
      @Override
      public void widgetSelected(SelectionEvent e) {
        IStructuredSelection selection = (IStructuredSelection) m_workplaceViewer.getSelection();                       
WorkplaceDetail workplaceDetail = (WorkplaceDetail) selection.getFirstElement();
boolean confirm = MessageDialog.openConfirm(shell,                          "Confirm Delete", "Are you sure you want to delete row"+                                    + workplaceDetail.getCode() + "'?");
if (confirm) {

 **int code =186;**   (Hardcoded row value- actual DB row number)                                       
 WorkplaceDaoImpl workplaceDaoImpl = new WorkplaceDaoImpl();

try {
**WorkplaceDaoImpl.deleteWorkplaceDetail(code);**                               
} catch (SQLException e1) {
                                                e1.printStackTrace();
}
m_bindingContext.updateModels();
}
}           
});

This is Ibatis DAO implementation code which i am invoking in SWT

**WorkplacseDaoImpl.java**

public void deleteWorkplaceDetail(int code)
            throws SQLException {
         SqlSession session = sqlSessionFactory.openSession();      
         session.delete("WorkplaceDetail.deleteWorkplaceById", code);    
         session.commit();
         session.close();        
}

**Ibatis Configuration**

  <delete id="deleteWorkplaceById">
    delete from Workplace where workplaceCode=#{code}
  </delete>

Please help me to resolve this issue. I am using SQLite DB

Community · Accepted Answer · 2017-05-23 12:27:45Z

0

From your description and related question before, I think you are trying to access SQLite database in different threads at the same time. Button event handler code is running inside of SWT UI thread. You may have other code trying to connect to database in other threads.

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Nov 13, 2012 at 9:23

Fu Cheng

3,3951 gold badge24 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Prashant P Over a year ago

Yes you are true Alex... I am using SQLite and Ibatis. Is there any way to resolve this...since i am not using JDBC directly...instead using ibatis.So how can i make sure Single connection...instead of going through multiple DB connection.

Prashant P Over a year ago

I have added below tag to make sure i have single active connection in sqlmap configuration, <property name="poolMaximumActiveConnections" value="1"/> <property name="poolMaximumIdleConnections" value="1"/>

Collectives™ on Stack Overflow

java.sql.SQLException: database is locked while using in SWT

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related