org.hibernate.exception.GenericJDBCException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • When you publish the metadata.xmi file to the server, it is sent in 1 chunk to the database. This works in MySQL as long as the wmi file is smaller then the max_allowed_packet variable. As you cannot make this value too high, you will end up with the following error message in some cases (If the size of metadata.xmi is big enough). In mu case metadata.xmi=3810136 while max_allowed_packet=1048576 2008-02-07 10:53:15,578 INFO [STDOUT] 10:53:15,578 DEBUG [JDBCTransaction] commit 2008-02-07 10:53:15,890 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: S1000 2008-02-07 10:53:15,890 ERROR [JDBCExceptionReporter] Packet for query is too large (3810136 > 1048576). You can change this value on the server by setting the max_allowed_packet' variabl 2008-02-07 10:53:15,890 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: could not update: [com.pentaho.repository.dbbased.solution.RepositoryFile#c6107913-ca68-11dc-98dc-5d7c50ee1b1e] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.pentaho.repository.HibernateUtil.commitTransaction(Unknown Source) at com.pentaho.repository.dbbased.solution.SolutionRepository.addSolutionFile(Unknown Source) at org.pentaho.ui.servlet.RepositoryFilePublisher.doGet(Unknown Source) at org.pentaho.ui.servlet.RepositoryFilePublisher.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
    via by gunter rombauts,
  • When you publish the metadata.xmi file to the server, it is sent in 1 chunk to the database. This works in MySQL as long as the wmi file is smaller then the max_allowed_packet variable. As you cannot make this value too high, you will end up with the following error message in some cases (If the size of metadata.xmi is big enough). In mu case metadata.xmi=3810136 while max_allowed_packet=1048576 2008-02-07 10:53:15,578 INFO [STDOUT] 10:53:15,578 DEBUG [JDBCTransaction] commit 2008-02-07 10:53:15,890 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: S1000 2008-02-07 10:53:15,890 ERROR [JDBCExceptionReporter] Packet for query is too large (3810136 > 1048576). You can change this value on the server by setting the max_allowed_packet' variabl 2008-02-07 10:53:15,890 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: could not update: [com.pentaho.repository.dbbased.solution.RepositoryFile#c6107913-ca68-11dc-98dc-5d7c50ee1b1e] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.pentaho.repository.HibernateUtil.commitTransaction(Unknown Source) at com.pentaho.repository.dbbased.solution.SolutionRepository.addSolutionFile(Unknown Source) at org.pentaho.ui.servlet.RepositoryFilePublisher.doGet(Unknown Source) at org.pentaho.ui.servlet.RepositoryFilePublisher.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
    via by gunter rombauts,
  • insert/update timeout
    via by hhale21,
  • Error Endeca baseline_update.sh
    via by 3145960,
    • org.hibernate.exception.GenericJDBCException: could not update: [com.pentaho.repository.dbbased.solution.RepositoryFile#c6107913-ca68-11dc-98dc-5d7c50ee1b1e] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.pentaho.repository.HibernateUtil.commitTransaction(Unknown Source) at com.pentaho.repository.dbbased.solution.SolutionRepository.addSolutionFile(Unknown Source) at org.pentaho.ui.servlet.RepositoryFilePublisher.doGet(Unknown Source) at org.pentaho.ui.servlet.RepositoryFilePublisher.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    esaaresaar
    4 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    17 more bugmates