1.8.0.10 empty database Caused by java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [delete from

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

1.8.0.10 empty database Caused by java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [delete from

zimmiman
Hi

After deleting some rows in the database, the following error happens. After shutdown of the database, the .data and .log files were still big. After restart, the database was empty. How could that happen?

--------------------

Exception details.



Class: javax.persistence.PersistenceException

Message: org.hibernate.exception.GenericJDBCException: could not delete:
[ch.futurelab.dendroid.model.impl.Node#1256051249959]



Stack trace:



org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:637)

org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:74)

ch.futurelab.dendroid.dao.impl.jpa.FinalDelete.sync(FinalDelete.java:51)

ch.futurelab.dendroid.dao.impl.JpaDao.finalDelete(JpaDao.java:152)

ch.futurelab.dendroid.DendroidMain.startApplication(DendroidMain.java:286)

org.java.plugin.boot.Boot.boot(Boot.java:347)

org.java.plugin.boot.Boot.main(Boot.java:244)

ch.futurelab.dendroid.DendroidMain.main(DendroidMain.java:165)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

java.lang.reflect.Method.invoke(Unknown Source)

com.sun.javaws.Launcher.executeApplication(Unknown Source)

com.sun.javaws.Launcher.executeMainClass(Unknown Source)

com.sun.javaws.Launcher.doLaunchApp(Unknown Source)

com.sun.javaws.Launcher.run(Unknown Source)

java.lang.Thread.run(Unknown Source)



Caused by org.hibernate.exception.GenericJDBCException: could not
delete: [ch.futurelab.dendroid.model.impl.Node#1256051249959]



org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)

org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)

org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2546)

org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2702)

org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:77)

org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)

org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)

org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)

org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)

org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)

org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)

org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)

org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:65)

ch.futurelab.dendroid.dao.impl.jpa.FinalDelete.sync(FinalDelete.java:51)

ch.futurelab.dendroid.dao.impl.JpaDao.finalDelete(JpaDao.java:152)

ch.futurelab.dendroid.DendroidMain.startApplication(DendroidMain.java:286)

org.java.plugin.boot.Boot.boot(Boot.java:347)

org.java.plugin.boot.Boot.main(Boot.java:244)

ch.futurelab.dendroid.DendroidMain.main(DendroidMain.java:165)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

java.lang.reflect.Method.invoke(Unknown Source)

com.sun.javaws.Launcher.executeApplication(Unknown Source)

com.sun.javaws.Launcher.executeMainClass(Unknown Source)

com.sun.javaws.Launcher.doLaunchApp(Unknown Source)

com.sun.javaws.Launcher.run(Unknown Source)

java.lang.Thread.run(Unknown Source)



Caused by java.sql.SQLException: S1000 General error
java.lang.NullPointerException in statement [delete from
HIERARCHICAL_ITEM where id=?]



org.hsqldb.jdbc.Util.throwError(Unknown Source)

org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)

org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)

org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2525)

org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2702)

org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:77)

org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)

org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)

org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)

org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:41)

org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:969)

org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114)

org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)

org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:65)

ch.futurelab.dendroid.dao.impl.jpa.FinalDelete.sync(FinalDelete.java:51)

ch.futurelab.dendroid.dao.impl.JpaDao.finalDelete(JpaDao.java:152)

ch.futurelab.dendroid.DendroidMain.startApplication(DendroidMain.java:286)

org.java.plugin.boot.Boot.boot(Boot.java:347)

org.java.plugin.boot.Boot.main(Boot.java:244)

ch.futurelab.dendroid.DendroidMain.main(DendroidMain.java:165)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

java.lang.reflect.Method.invoke(Unknown Source)

com.sun.javaws.Launcher.executeApplication(Unknown Source)

com.sun.javaws.Launcher.executeMainClass(Unknown Source)

com.sun.javaws.Launcher.doLaunchApp(Unknown Source)

com.sun.javaws.Launcher.run(Unknown Source)

java.lang.Thread.run(Unknown Source)
Loading...