org.hibernate.exception.GenericJDBCException: could not insert: [com.xpn.xwiki.d oc.XWikiDocument]

XWiki.org JIRA | Charles BAUD | 9 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Error while Installing XWIki Workspaces with Oracle 10g Enterprise Edition Release 10.2.0.3.0. I dowloaded xwiki-workspaces-web-1.0.war and installed on jboss_4.0.3SP1. It works find with MYSQL but my DB guys can't install it on Oracle 10g. hibernate.cfg.xml : <property name="connection.url">jdbc:oracle:thin:@localhost:1521:MYSID</property> <property name="connection.username">xwiki</property> <property name="connection.password">xwiki</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property> <property name="connection.pool_size">2</property> <property name="statement_cache.size">2</property> <property name="hibernate.connection.SetBigStringTryClob">true</property> <property name="hibernate.jdbc.batch_size">0</property> <mapping resource="xwiki.oracle.hbm.xml"/> <mapping resource="feeds.oracle.hbm.xml"/> <mapping resource="activitystream.hbm.xml"/> Browser error: HTTP Status 500 exception javax.servlet.ServletException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: could not insert: [com.xpn.xwiki.doc.XWikiDocument] org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:535) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:433) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:697) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) root cause com.xpn.xwiki.XWikiException: Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3201 in 3: Exception while saving document XWiki.XWikiPreferences Wrapped Exception: could not insert: [com.xpn.xwiki.doc.XWikiDocument] com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:303) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:491) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:123) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:697) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) 11:35:23,913 ERROR [JDBCExceptionReporter] Data size bigger than max size for th is type: 4210 11:35:23,913 ERROR [AbstractFlushingEventListener] Could not synchronize databas e state with session org.hibernate.exception.GenericJDBCException: could not insert: [com.xpn.xwiki.d oc.XWikiDocument] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException (SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j ava:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp er.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac tEntityPersister.java:2267) at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac tEntityPersister.java:2660) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.ja va:56) 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:141) 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 com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:783) at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:754) at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:447) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97) at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:91) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1083) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1056) at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1050) at com.xpn.xwiki.plugin.applicationmanager.core.doc.objects.classes.AbstractXClassManager.checkClassDocument(AbstractXClassManager.java:402) at com.xpn.xwiki.plugin.applicationmanager.core.doc.objects.classes.AbstractXClassManager.check(AbstractXClassManager.java:368) at com.xpn.xwiki.plugin.applicationmanager.doc.XWikiApplicationClass.getInstance(XWikiApplicationClass.java:260) at com.xpn.xwiki.plugin.applicationmanager.ApplicationManager.getApplicationList(ApplicationManager.java:184) at com.xpn.xwiki.plugin.applicationmanager.ApplicationManager.updateAllApplicationTranslation(ApplicationManager.java:378) at com.xpn.xwiki.plugin.applicationmanager.ApplicationManagerPlugin.init(ApplicationManagerPlugin.java:92) at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:146) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:76) at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:107) at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:858) at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:786) at com.xpn.xwiki.XWiki.<init>(XWiki.java:722) at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:293) at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:491) at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:123) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: Data size bigger than max size for this type: 4210 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:155) at oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2531) at oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1248) at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:1690) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131) at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131) at org.hibernate.type.StringType.set(StringType.java:26) at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136) at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:107) at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1997) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2243) ... 61 more We have tried every solutions provided at http://jira.xwiki.org/jira/browse/XWIKI-838 but we still have the problem. Thanks for your Help. Charles

    XWiki.org JIRA | 9 years ago | Charles BAUD
    org.hibernate.exception.GenericJDBCException: could not insert: [com.xpn.xwiki.d oc.XWikiDocument]
  2. 0

    Bug Reports/Resolved/0.6.x - JAMWiki Java Wiki Engine

    jamwiki.org | 6 months ago
    java.lang.Exception: Failure while executing insert into jam_topic_version ( topic_version_id, topic_id, edit_comment, version_content, wiki_user_id, edit_type, wiki_user_ip_address, edit_date, previous_topic_version_id ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ? )
  3. 0

    Re: CLOB on Oracle

    ibatis-user-java | 1 decade ago | Emiliano Armellin
    java.sql.SQLException: Data size bigger than max size for this type: 5650
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDBC Driver/prepared Statement

    Oracle Community | 1 decade ago | 400049
    java.sql.SQLException: Datengr��e gr��er als max. Gr��e f�r diesen Typ: 230967
  6. 0

    Data size bigger than max size for this type: 6000

    Oracle Community | 7 years ago | 722445
    java.sql.SQLException: Data size bigger than max size for this type: 6000

  1. rp 1 times, last 2 months ago
26 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Data size bigger than max size for this type: 4210

    at oracle.jdbc.dbaccess.DBError.throwSqlException()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    2. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
    2 frames
  3. oracle.jdbc.ttc7
    TTCItem.setArrayData
    1. oracle.jdbc.ttc7.TTCItem.setArrayData(TTCItem.java:155)
    1 frame
  4. oracle.jdbc.dbaccess
    DBDataSetImpl.setBytesBindItem
    1. oracle.jdbc.dbaccess.DBDataSetImpl.setBytesBindItem(DBDataSetImpl.java:2531)
    1 frame
  5. Oracle jdbc
    OraclePreparedStatement.setString
    1. oracle.jdbc.driver.OraclePreparedStatement.setItem(OraclePreparedStatement.java:1248)
    2. oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:1690)
    2 frames
  6. Commons DBCP
    DelegatingPreparedStatement.setString
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131)
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:131)
    2 frames
  7. Hibernate
    AbstractEntityPersister.insert
    1. org.hibernate.type.StringType.set(StringType.java:26)
    2. org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136)
    3. org.hibernate.type.NullableType.nullSafeSet(NullableType.java:107)
    4. org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1997)
    5. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2243)
    6. org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
    6 frames
  8. Hibernate
    EntityInsertAction.execute
    1. org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
    1 frame
  9. Hibernate
    ActionQueue.executeActions
    1. org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
    2. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
    3. org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
    3 frames
  10. Hibernate
    SessionImpl.managedFlush
    1. org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
    2. org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
    3. org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
    4. org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
    4 frames
  11. Hibernate
    JDBCTransaction.commit
    1. org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
    1 frame
  12. com.xpn.xwiki
    XWikiAction.execute
    1. com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:783)
    2. com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:754)
    3. com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:447)
    4. com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:97)
    5. com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:91)
    6. com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1083)
    7. com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1056)
    8. com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1050)
    9. com.xpn.xwiki.plugin.applicationmanager.core.doc.objects.classes.AbstractXClassManager.checkClassDocument(AbstractXClassManager.java:402)
    10. com.xpn.xwiki.plugin.applicationmanager.core.doc.objects.classes.AbstractXClassManager.check(AbstractXClassManager.java:368)
    11. com.xpn.xwiki.plugin.applicationmanager.doc.XWikiApplicationClass.getInstance(XWikiApplicationClass.java:260)
    12. com.xpn.xwiki.plugin.applicationmanager.ApplicationManager.getApplicationList(ApplicationManager.java:184)
    13. com.xpn.xwiki.plugin.applicationmanager.ApplicationManager.updateAllApplicationTranslation(ApplicationManager.java:378)
    14. com.xpn.xwiki.plugin.applicationmanager.ApplicationManagerPlugin.init(ApplicationManagerPlugin.java:92)
    15. com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:146)
    16. com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:76)
    17. com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:107)
    18. com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:858)
    19. com.xpn.xwiki.XWiki.initXWiki(XWiki.java:786)
    20. com.xpn.xwiki.XWiki.<init>(XWiki.java:722)
    21. com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:293)
    22. com.xpn.xwiki.XWiki.getXWiki(XWiki.java:491)
    23. com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:123)
    23 frames
  13. struts
    ActionServlet.doGet
    1. org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
    2. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
    3. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
    4. org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
    4 frames
  14. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
    2. javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    2 frames
  15. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2 frames
  16. com.xpn.xwiki
    SetCharacterEncodingFilter.doFilter
    1. com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
    1 frame
  17. Glassfish Core
    ApplicationFilterChain.doFilter
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2 frames
  18. JBoss Application Server Tomcat
    ReplyHeaderFilter.doFilter
    1. org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
    1 frame
  19. Glassfish Core
    StandardContextValve.invoke
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    4 frames
  20. JBoss Application Server Tomcat
    JaccContextValve.invoke
    1. org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
    2. org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
    3. org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
    3 frames
  21. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    3. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    4. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    4 frames
  22. Grizzly HTTP
    MasterSlaveWorkerThread.run
    1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
    3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    4. org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    4 frames
  23. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:595)
    1 frame