Hello everyone!
I´m developing an app with 3 parts:
- JavaFX Desktop app.
- Java Server WebApp
- AndroidApp
I´m using Hibernate for mapping a SQLite Database.
But when the desktop app is open and try to insert a new ibject from the
AndroidApp throug the Server it gives me an error: `java.sql.SQLException:
database is locked`
My hibernate.cfg.xml file:
<property name="show_sql">true</property>
<property name="format_sql">true</property>
<property name="dialect">dialect.SQLiteDialect</property>
<property
name="connection.driver_class">org.sqlite.JDBC</property>
<property
name="connection.url">jdbc:sqlite:grainsa_provisional.sqlite</property>
<property name="connection.username"></property>
<property name="connection.password"></property>
And my "Objects Manager",the same way in the Server and in the Desktop by
example:
private Session mSession;
private Transaction mTransaction;
private void initQuery() throws HibernateException {
mSession = HibernateUtil.getSessionFactory().openSession();
mTransaction = mSession.beginTransaction();
}
private void manejaExcepcion(HibernateException hibernateException) {
mTransaction.rollback();
throw new HibernateException("ha ocurrido un error con la Base
de
Datos!!!", hibernateException);
}
public Conductor selectConductorByID(Integer id) {
Conductor conductor = new Conductor();
try{
initQuery();
conductor = (Conductor) mSession.get(Conductor.class,
id);
} catch (HibernateException e){
manejaExcepcion(e);
throw e;
} finally {
mSession.close();
}
return conductor;
}
If you need more information please ask!
What i´m doing wrong?I close everytime the sesion with mSession.close()...
Thanks everyone and sorry about my english!
Edit: ím thinking to change the acces mode of mi desktop JavaFX app to make
the query through the server, but it will take me alot of time, and i do not
think that is the best way to do it..
Please help! and thanks again!
--
View this message in context:
http://sqlite.1065341.n5.nabble.com/concurrency-acces-from-desktop-and-web-service-tp74798.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
