Admin Center: Category Mngmt: Long key or value name raise an hibernate exception: better truncate long name!

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