Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Standard Widget Toolkit (SWT) » SWT DB Exception(java.sql.SQLException: database is locked While using SWT)
SWT DB Exception [message #982177] Mon, 12 November 2012 20:02
Prashant p is currently offline Prashant p
Messages: 57
Registered: October 2012
Member
I am trying to connect 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
Previous Topic:Problem with Flash object in SWT Browser
Next Topic:Drawing Artifacts on UI space
Goto Forum:
  


Current Time: Wed Jul 30 05:09:14 EDT 2014

Powered by FUDForum. Page generated in 0.01842 seconds