Admin Center: Category Mngmt: Long key or value name raise an hibernate
exception: better truncate long name!
-------------------------------------------------------------------------------------------------------------
Key: JAHIA-3562
URL: http://www.jahia.net/jira/browse/JAHIA-3562
Project: Jahia Web Content Management Server (WCMS)
Issue Type: Bug
Components: Administration Center
Affects Versions: WCM 6.0 (Andromeda)
Environment: 22692
Reporter: Stephane Croisier
Assignee: Khaled Tlili
Priority: Major
Fix For: WCM 6.0 (Andromeda)
I entered a liong, long name (as long as I could) in the category input form.
This lead to an Hibernate exception (using Postgtres)
2008-10-21 10:02:51,468: INFO [org.jahia.bin.Jahia] - Processed
[/cms/engineName/categoryEdit/site/tck/op/edit/pid/3] user=[root]
ip=[127.0.0.1] in [312ms]
2008-10-21 10:13:41,000: ERROR [org.hibernate.util.JDBCExceptionReporter] -
L'ΘlΘment du batch 0 insert into jahia_category (key_category,
aclid_category, id_category) values (sdfds sgdsfdg fsgsfsdfds sgdsfdg fsgsfdg
sfdg sfdgsfd gsfdgsfdg sfdgsfd gsfdgsfdg fg sfdgfdsgsfd gfdsgsfdgsfd sfdg
fdgfds gf
dsgsfd gfdsg fdsg dfgsfd gsfdgsfd gsfdg fdsgfdsgfd gsfdg fdgfdgfdg
fdgfdgfdgfdgfdsdfds sgdsfdg fsgsfdg sfdg sfdgsfd gsfdgsfdg sfdgsfd gsfdgsfdg fg
sfdgfdsgsfd gfdsgsfdgsfd sfdg fdgfds gfdsgsfd gfdsg fdsg dfgsfd gsfdgsfd gsfdg
fdsgfdsgfd gsfdg fdgfdgfdg fdgfdgfdgfdgfdsdfds sgdsfdg fsgsfdg sfdg sfdg
sfd gsfdgsfdg sfdgsfd gsfdgsfdg fg sfdgfdsgsfd gfdsgsfdgsfd sfdg fdgfds
gfdsgsfd gfdsg fdsg dfgsfd gsfdgsfd gsfdg fdsgfdsgfd gsfdg fdgfdgfdg
fdgfdgfdgfdgfdsdfds sgdsfdg fsgsfdg sfdg sfdgsfd gsfdgsfdg sfdgsfd gsfdgsfdg fg
sfdgfdsgsfd gfdsgsfdgsfd sfdg fdgfds gfdsgsfd gfdsg fdsg dfgsfd gsfdgsfd gsfdg
fdsgfdsgfd gsfdg fdgfdgfdg fdgfdgfdgfdgfddg sfdg sfdgsfd gsfdgsfdg sfdgsfd
gsfdgsfdg fg sfdgfdsgsfd gfdsgsfdgsfd sfdg fdgfds gfdsgsfd gfdsg fdsg dfgsfd
gsfdgsfd gsfdg fdsgfdsgfd gsfdg fdgfdgfdg fdgfdgfdgfdgfd, 178, 7) a
ΘtΘ annulΘ. Appeler getNextException pour en connaεtre la
cause.
2008-10-21 10:13:41,000: ERROR [org.hibernate.util.JDBCExceptionReporter] -
ERROR: value too long for type character varying(250)
2008-10-21 10:13:41,000: ERROR
[org.hibernate.event.def.AbstractFlushingEventListener] - Could not synchronize
database state with session
org.hibernate.exception.DataException: Could not execute JDBC batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
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.springframework.orm.hibernate3.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:135)
at
org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:72)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:882)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:692)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at
org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:113)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at
org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:582)
at
org.jahia.hibernate.manager.JahiaCategoryManager$$EnhancerByCGLIB$$d52c1a58.createCategory(<generated>)
at
org.jahia.services.categories.CategoryServiceImpl.addCategory(CategoryServiceImpl.java:200)
at
org.jahia.services.categories.Category.createCategory(Category.java:87)
at
org.jahia.ajax.gwt.engines.categories.server.GWTCategorySeviceImpl.createCategory(GWTCategorySeviceImpl.java:262)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:164)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.jahia.bin.filters.jcr.JcrSessionFilter.doFilter(JcrSessionFilter.java:23)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:164)
at
org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
at
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
at
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.BatchUpdateException: L'ΘlΘment du batch 0 insert
into jahia_category (key_category, aclid_category, id_category) values (sdfds
sgdsfdg fsgsfsdfds sgdsfdg fsgsfdg sfdg sfdgsfd gsfdgsfdg sfdgsfd gsfdgsfdg fg
sfdgfdsgsfd gfdsgsfdgsfd sfdg fdgfds gfdsgsfd gfdsg fdsg dfgsfd gsfdgsfd
gsfdg fdsgfdsgfd gsfdg fdgfdgfdg fdgfdgfdgfdgfdsdfds sgdsfdg fsgsfdg sfdg
sfdgsfd gsfdgsfdg sfdgsfd gsfdgsfdg fg sfdgfdsgsfd gfdsgsfdgsfd sfdg fdgfds
gfdsgsfd gfdsg fdsg dfgsfd gsfdgsfd gsfdg fdsgfdsgfd gsfdg fdgfdgfdg
fdgfdgfdgfdgfdsdfds sgdsfdg fsgsfdg sfdg sfdgsfd gsfdgsfdg sfdgsfd gsfdgsfdg fg
sfdgfdsgsfd gfdsgsfdgsfd sfdg fdgfds gfdsgsfd gfdsg fdsg dfgsfd gsfdgsfd gsfdg
fdsgfdsgfd gsfdg fdgfdgfdg fdgfdgfdgfdgfdsdfds sgdsfdg fsgsfdg sfdg sfdgsfd
gsfdgsfdg sfdgsfd gsfdgsfdg fg sfdgfdsgsfd gfdsgsfdgsfd sfdg fdgfds gfdsgsfd
gfdsg fdsg dfgsfd gsfdgsfd gsfdg fdsgfdsgfd gsfdg fdgfdgfdg fdgfd
gfdgfdgfddg sfdg sfdgsfd gsfdgsfdg sfdgsfd gsfdgsfdg fg sfdgfdsgsfd
gfdsgsfdgsfd sfdg fdgfds gfdsgsfd gfdsg fdsg dfgsfd gsfdgsfd gsfdg fdsgfdsgfd
gsfdg fdgfdgfdg fdgfdgfdgfdgfd, 178, 7) a ΘtΘ annulΘ. Appeler
getNextException pour en connaεtre la cause.
at
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2537)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1328)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:351)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2674)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 51 more
2008-10-21 10:13:41,015: ERROR
[org.hibernate.event.def.AbstractFlushingEventListener] - Could not synchronize
database state with session
org.hibernate.exception.DataException: Could not execute JDBC batch update
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
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.springframework.orm.hibernate3.SpringSessionSynchronization.beforeCommit(SpringSessionSynchronization.java:135)
at
org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:72)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:882)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:692)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:678)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at
org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:113)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at
org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:582)
at
org.jahia.hibernate.manager.JahiaCategoryManager$$EnhancerByCGLIB$$d52c1a58.createCategory(<generated>)
at
org.jahia.services.categories.CategoryServiceImpl.addCategory(CategoryServiceImpl.java:200)
at
org.jahia.services.categories.Category.createCategory(Category.java:87)
at
org.jahia.ajax.gwt.engines.categories.server.GWTCategorySeviceImpl.createCategory(GWTCategorySeviceImpl.java:262)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:164)
at
com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.jahia.bin.filters.jcr.JcrSessionFilter.doFilter(JcrSessionFilter.java:23)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:164)
at
org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:141)
at
org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:90)
at
org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:417)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.BatchUpdateException: L'ΘlΘment du batch 0 insert
into jahia_category (key_category, aclid_category, id_category) values (sdfds
sgdsfdg fsgsfsdfds sgdsfdg fsgsfdg sfdg sfdgsfd gsfdgsfdg sfdgsfd gsfdgsfdg fg
sfdgfdsgsfd gfdsgsfdgsfd sfdg fdgfds gfdsgsfd gfdsg fdsg dfgsfd gsfdgsfd
gsfdg fdsgfdsgfd gsfdg fdgfdgfdg fdgfdgfdgfdgfdsdfds sgdsfdg fsgsfdg sfdg
sfdgsfd gsfdgsfdg sfdgsfd gsfdgsfdg fg sfdgfdsgsfd gfdsgsfdgsfd sfdg fdgfds
gfdsgsfd gfdsg fdsg dfgsfd gsfdgsfd gsfdg fdsgfdsgfd gsfdg fdgfdgfdg
fdgfdgfdgfdgfdsdfds sgdsfdg fsgsfdg sfdg sfdgsfd gsfdgsfdg sfdgsfd gsfdgsfdg fg
sfdgfdsgsfd gfdsgsfdgsfd sfdg fdgfds gfdsgsfd gfdsg fdsg dfgsfd gsfdgsfd gsfdg
fdsgfdsgfd gsfdg fdgfdgfdg fdgfdgfdgfdgfdsdfds sgdsfdg fsgsfdg sfdg sfdgsfd
gsfdgsfdg sfdgsfd gsfdgsfdg fg sfdgfdsgsfd gfdsgsfdgsfd sfdg fdgfds gfdsgsfd
gfdsg fdsg dfgsfd gsfdgsfd gsfdg fdsgfdsgfd gsfdg fdgfdgfdg fdgfd
gfdgfdgfddg sfdg sfdgsfd gsfdgsfdg sfdgsfd gsfdgsfdg fg sfdgfdsgsfd
gfdsgsfdgsfd sfdg fdgfds gfdsgsfd gfdsg fdsg dfgsfd gsfdgsfd gsfdg fdsgfdsgfd
gsfdg fdgfdgfdg fdgfdgfdgfdgfd, 178, 7) a ΘtΘ annulΘ. Appeler
getNextException pour en connaεtre la cause.
at
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2537)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1328)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:351)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2674)
at
org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)
... 51 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://www.jahia.net/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
jira_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/jira_list
