You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by zhangenpei <zh...@gmail.com> on 2005/11/27 07:05:08 UTC
Can't add a new user with roller 2.0
Hi,
I just tried roller2.0 ( I am using tomcat5.5 and mysql 5.0 ). But when I
tried to register a new user, I got the following exceptions. Could you
tell me how to resolve it?
ERROR 2005-11-27 05:48:03,284 UserNewAction:add - ERROR in addUser
org.roller.RollerException
at
org.roller.business.hibernate.HibernateStrategy.commit(HibernateStrategy.jav
a:440)
at
org.roller.business.hibernate.HibernateRollerImpl.commit(HibernateRollerImpl
.java:115)
at
org.roller.presentation.website.actions.UserNewAction.add(UserNewAction.java
:160)
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:324)
at
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:
276)
at
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:421)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.roller.presentation.filters.BreadCrumbFilter.doFilter(BreadCrumbFilter.j
ava:77)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.roller.presentation.filters.RequestFilter.doFilter(RequestFilter.java:13
4)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.roller.presentation.filters.PersistenceSessionFilter.doFilter(Persistenc
eSessionFilter.java:53)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeEnfor
cementFilter.java:97)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncodingFilt
er.java:94)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:178)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
.java:407)
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.processConne
ction(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:684)
at java.lang.Thread.run(Thread.java:534)
--- ROOT CAUSE ---
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch
update
at
org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(Error
CodeConverter.java:92)
at
org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:8
0)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java
:43)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:181)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:74)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:69)
at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.jav
a:150)
at
org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersis
ter.java:1839)
at
org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersis
ter.java:2200)
at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(Abst
ractFlushingEventListener.java:274)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventL
istener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at
org.roller.business.hibernate.HibernateStrategy.commit(HibernateStrategy.jav
a:428)
at
org.roller.business.hibernate.HibernateRollerImpl.commit(HibernateRollerImpl
.java:115)
at
org.roller.presentation.website.actions.UserNewAction.add(UserNewAction.java
:160)
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:324)
at
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:
276)
at
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:421)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.roller.presentation.filters.BreadCrumbFilter.doFilter(BreadCrumbFilter.j
ava:77)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.roller.presentation.filters.RequestFilter.doFilter(RequestFilter.java:13
4)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.roller.presentation.filters.PersistenceSessionFilter.doFilter(Persistenc
eSessionFilter.java:53)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeEnfor
cementFilter.java:97)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncodingFilt
er.java:94)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:202)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:178)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
.java:407)
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.processConne
ction(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:684)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.BatchUpdateException: Data too long for column
'isenabled' at row 1
at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1540)
at
org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingState
ment.java:294)
at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
at
org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:174)
... 57 more
RE: Can't add a new user with roller 2.0
Posted by zhangenpei <zh...@gmail.com>.
works fine now. Thanks a lot!
> -----Original Message-----
> From: Anil Gangolli [mailto:anil@busybuddha.org]
> Sent: 28 November 2005 12:23
> To: roller-user@incubator.apache.org
> Subject: Re: Can't add a new user with roller 2.0
>
> I don't know about MySQL 5.x, but the instructions posted
> here work for
> 4.1.x:
>
> http://rollerweblogger.org/wiki/Wiki.jsp?page=SetupUTF8onMySQL
>
> You need to do the equivalent for 5.x; they may work as is,
> or you may have to check the 5.x docs for the precise equivalents.
>
> --a.
Re: Can't add a new user with roller 2.0
Posted by Anil Gangolli <an...@busybuddha.org>.
I don't know about MySQL 5.x, but the instructions posted here work for
4.1.x:
http://rollerweblogger.org/wiki/Wiki.jsp?page=SetupUTF8onMySQL
You need to do the equivalent for 5.x; they may work as is, or you may
have to check the 5.x docs for the precise equivalents.
--a.
zhangenpei wrote:
> Great! When I change mysql jdbc driver to 3.1.11, the problem ""Data too
>long for column '*******'"" is gone! Thanks a lot.
>
>But I met another problem. Now I only can post English titles with English
>text bodis. When I post an Chinese text, I got the following exception:
>
>aused by: java.sql.SQLException: Illegal mix of collations
>(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation
>'='
>....
>
>So, what shall I do now? I know it is something about mysql, I tried but
>can't got the solution.
>
>BTW, I have tried roller1.3 with msql4.1.X, it support bothe Chinese and
>English very well.
>
>
>Thanks again!
>
>
>
>>-----Original Message-----
>>From: Matt Raible [mailto:mraible@gmail.com]
>>Sent: 28 November 2005 10:11
>>To: roller-user@incubator.apache.org
>>Subject: Re: Can't add a new user with roller 2.0
>>
>>Try the latest MySQL JDBC Driver - I believe the version is 3.1.11.
>>
>>Matt
>>
>>On 11/27/05, zhangenpei <zh...@gmail.com> wrote:
>>
>>
>>>Anil wrote:
>>>
>>>
>>>
>>>>Which specific MySQL 5.x server version are you using and
>>>>
>>>>
>>which JDBC
>>
>>
>>>>driver are you using?
>>>>
>>>>
>>>>
>>>mysql-5.0.16 and JDBC driver: mysql-connector-java-3.0.17.
>>>
>>>And I found for every column whose type is "bit" there is
>>>
>>>
>>always an error:
>>
>>
>>>"Data too long for column '*******'".
>>>
>>>Thans a lot!
>>>
>>>
>>>
>>>
>
>
>
>
RE: Can't add a new user with roller 2.0
Posted by zhangenpei <zh...@gmail.com>.
Great! When I change mysql jdbc driver to 3.1.11, the problem ""Data too
long for column '*******'"" is gone! Thanks a lot.
But I met another problem. Now I only can post English titles with English
text bodis. When I post an Chinese text, I got the following exception:
aused by: java.sql.SQLException: Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation
'='
....
So, what shall I do now? I know it is something about mysql, I tried but
can't got the solution.
BTW, I have tried roller1.3 with msql4.1.X, it support bothe Chinese and
English very well.
Thanks again!
> -----Original Message-----
> From: Matt Raible [mailto:mraible@gmail.com]
> Sent: 28 November 2005 10:11
> To: roller-user@incubator.apache.org
> Subject: Re: Can't add a new user with roller 2.0
>
> Try the latest MySQL JDBC Driver - I believe the version is 3.1.11.
>
> Matt
>
> On 11/27/05, zhangenpei <zh...@gmail.com> wrote:
> > Anil wrote:
> >
> > > Which specific MySQL 5.x server version are you using and
> which JDBC
> > > driver are you using?
> > >
> > mysql-5.0.16 and JDBC driver: mysql-connector-java-3.0.17.
> >
> > And I found for every column whose type is "bit" there is
> always an error:
> > "Data too long for column '*******'".
> >
> > Thans a lot!
> >
> >
Re: Can't add a new user with roller 2.0
Posted by Matt Raible <mr...@gmail.com>.
Try the latest MySQL JDBC Driver - I believe the version is 3.1.11.
Matt
On 11/27/05, zhangenpei <zh...@gmail.com> wrote:
> Anil wrote:
>
> > Which specific MySQL 5.x server version are you using and
> > which JDBC driver are you using?
> >
> mysql-5.0.16 and JDBC driver: mysql-connector-java-3.0.17.
>
> And I found for every column whose type is "bit" there is always an error:
> "Data too long for column '*******'".
>
> Thans a lot!
>
>
> > -----Original Message-----
> > From: Anil Gangolli [mailto:anil@busybuddha.org]
> > Sent: 28 November 2005 04:43
> > To: roller-user@incubator.apache.org
> > Subject: Re: Can't add a new user with roller 2.0
> >
> > Which specific MySQL 5.x server version are you using and
> > which JDBC driver are you using?
> >
> > --a.
> >
> >
> > zhangenpei wrote:
> >
> > >Hi,
> > >
> > >I just tried roller2.0 ( I am using tomcat5.5 and mysql 5.0
> > ). But when
> > >I tried to register a new user, I got the following
> > exceptions. Could
> > >you tell me how to resolve it?
> > >
> > >ERROR 2005-11-27 05:48:03,284 UserNewAction:add - ERROR in addUser
> > >org.roller.RollerException
> > > at
> > >org.roller.business.hibernate.HibernateStrategy.commit(Hibern
> > ateStrateg
> > >y.jav
> > >a:440)
> > > at
> > >org.roller.business.hibernate.HibernateRollerImpl.commit(Hibe
> > rnateRolle
> > >rImpl
> > >.java:115)
> > > at
> > >org.roller.presentation.website.actions.UserNewAction.add(Use
> > rNewAction
> > >.java
> > >:160)
> > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > at
> > >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
> > sorImpl.ja
> > >va:39
> > >)
> > > at
> > >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
> > hodAccesso
> > >rImpl
> > >.java:25)
> > > at java.lang.reflect.Method.invoke(Method.java:324)
> > > at
> > >org.apache.struts.actions.DispatchAction.dispatchMethod(Dispa
> > tchAction.java:
> > >276)
> > > at
> > >org.apache.struts.actions.DispatchAction.execute(DispatchActi
> > on.java:196)
> > > at
> > >org.apache.struts.action.RequestProcessor.processActionPerfor
> > m(RequestP
> > >roces
> > >sor.java:421)
> > > at
> > >org.apache.struts.action.RequestProcessor.process(RequestProc
> > essor.java:226)
> > > at
> > >org.apache.struts.action.ActionServlet.process(ActionServlet.
> > java:1164)
> > > at
> > >org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
> > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> > ter(Applic
> > >ation
> > >FilterChain.java:252)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> > icationFil
> > >terCh
> > >ain.java:173)
> > > at
> > >org.roller.presentation.filters.BreadCrumbFilter.doFilter(Bre
> > adCrumbFil
> > >ter.j
> > >ava:77)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> > ter(Applic
> > >ation
> > >FilterChain.java:202)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> > icationFil
> > >terCh
> > >ain.java:173)
> > > at
> > >org.roller.presentation.filters.RequestFilter.doFilter(Reques
> > tFilter.ja
> > >va:13
> > >4)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> > ter(Applic
> > >ation
> > >FilterChain.java:202)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> > icationFil
> > >terCh
> > >ain.java:173)
> > > at
> > >org.roller.presentation.filters.PersistenceSessionFilter.doFi
> > lter(Persi
> > >stenc
> > >eSessionFilter.java:53)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> > ter(Applic
> > >ation
> > >FilterChain.java:202)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> > icationFil
> > >terCh
> > >ain.java:173)
> > > at
> > >org.roller.presentation.filters.SchemeEnforcementFilter.doFil
> > ter(Scheme
> > >Enfor
> > >cementFilter.java:97)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> > ter(Applic
> > >ation
> > >FilterChain.java:202)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> > icationFil
> > >terCh
> > >ain.java:173)
> > > at
> > >org.roller.presentation.filters.CharEncodingFilter.doFilter(C
> > harEncodin
> > >gFilt
> > >er.java:94)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> > ter(Applic
> > >ation
> > >FilterChain.java:202)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> > icationFil
> > >terCh
> > >ain.java:173)
> > > at
> > >org.apache.catalina.core.StandardWrapperValve.invoke(Standard
> > WrapperVal
> > >ve.ja
> > >va:213)
> > > at
> > >org.apache.catalina.core.StandardContextValve.invoke(Standard
> > ContextVal
> > >ve.ja
> > >va:178)
> > > at
> > >org.apache.catalina.authenticator.AuthenticatorBase.invoke(Au
> > thenticato
> > >rBase
> > >.java:407)
> > > at
> > >org.apache.catalina.core.StandardHostValve.invoke(StandardHos
> > tValve.jav
> > >a:126
> > >)
> > > at
> > >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepor
> > tValve.jav
> > >a:105
> > >)
> > > at
> > >org.apache.catalina.core.StandardEngineValve.invoke(StandardE
> > ngineValve
> > >.java
> > >:107)
> > > at
> > >org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAda
> > pter.java:148)
> > > at
> > >org.apache.coyote.http11.Http11Processor.process(Http11Proces
> > sor.java:856)
> > > at
> > >org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandl
> > er.process
> > >Conne
> > >ction(Http11Protocol.java:744)
> > > at
> > >org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Pool
> > TcpEndpoin
> > >t.jav
> > >a:527)
> > > at
> > >org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(L
> > eaderFollo
> > >werWo
> > >rkerThread.java:80)
> > > at
> > >org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> > (ThreadPoo
> > >l.jav
> > >a:684)
> > > at java.lang.Thread.run(Thread.java:534)
> > >--- ROOT CAUSE ---
> > >org.hibernate.exception.GenericJDBCException: Could not execute JDBC
> > >batch update
> > > at
> > >org.hibernate.exception.ErrorCodeConverter.handledNonSpecific
> > Exception(
> > >Error
> > >CodeConverter.java:92)
> > > at
> > >org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeC
> > onverter.j
> > >ava:8
> > >0)
> > > at
> > >org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep
> > tionHelper
> > >.java
> > >:43)
> > > at
> > >org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatch
> > er.java:181)
> > > at
> > >org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractB
> > atcher.java:74)
> > > at
> > >org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractB
> > atcher.java:69)
> > > at
> > >org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(Abst
> > ractBatche
> > >r.jav
> > >a:150)
> > > at
> > >org.hibernate.persister.entity.BasicEntityPersister.insert(Ba
> > sicEntityP
> > >ersis
> > >ter.java:1839)
> > > at
> > >org.hibernate.persister.entity.BasicEntityPersister.insert(Ba
> > sicEntityP
> > >ersis
> > >ter.java:2200)
> > > at
> > >org.hibernate.action.EntityInsertAction.execute(EntityInsertA
> > ction.java:46)
> > > at
> > org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> > > at
> > >org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> > > at
> > >org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> > > at
> > >org.hibernate.event.def.AbstractFlushingEventListener.perform
> > Executions
> > >(Abst
> > >ractFlushingEventListener.java:274)
> > > at
> > >org.hibernate.event.def.DefaultFlushEventListener.onFlush(Def
> > aultFlushE
> > >ventL
> > >istener.java:27)
> > > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> > > at
> > >org.roller.business.hibernate.HibernateStrategy.commit(Hibern
> > ateStrateg
> > >y.jav
> > >a:428)
> > > at
> > >org.roller.business.hibernate.HibernateRollerImpl.commit(Hibe
> > rnateRolle
> > >rImpl
> > >.java:115)
> > > at
> > >org.roller.presentation.website.actions.UserNewAction.add(Use
> > rNewAction
> > >.java
> > >:160)
> > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > > at
> > >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
> > sorImpl.ja
> > >va:39
> > >)
> > > at
> > >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
> > hodAccesso
> > >rImpl
> > >.java:25)
> > > at java.lang.reflect.Method.invoke(Method.java:324)
> > > at
> > >org.apache.struts.actions.DispatchAction.dispatchMethod(Dispa
> > tchAction.java:
> > >276)
> > > at
> > >org.apache.struts.actions.DispatchAction.execute(DispatchActi
> > on.java:196)
> > > at
> > >org.apache.struts.action.RequestProcessor.processActionPerfor
> > m(RequestP
> > >roces
> > >sor.java:421)
> > > at
> > >org.apache.struts.action.RequestProcessor.process(RequestProc
> > essor.java:226)
> > > at
> > >org.apache.struts.action.ActionServlet.process(ActionServlet.
> > java:1164)
> > > at
> > >org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
> > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> > ter(Applic
> > >ation
> > >FilterChain.java:252)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> > icationFil
> > >terCh
> > >ain.java:173)
> > > at
> > >org.roller.presentation.filters.BreadCrumbFilter.doFilter(Bre
> > adCrumbFil
> > >ter.j
> > >ava:77)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> > ter(Applic
> > >ation
> > >FilterChain.java:202)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> > icationFil
> > >terCh
> > >ain.java:173)
> > > at
> > >org.roller.presentation.filters.RequestFilter.doFilter(Reques
> > tFilter.ja
> > >va:13
> > >4)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> > ter(Applic
> > >ation
> > >FilterChain.java:202)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> > icationFil
> > >terCh
> > >ain.java:173)
> > > at
> > >org.roller.presentation.filters.PersistenceSessionFilter.doFi
> > lter(Persi
> > >stenc
> > >eSessionFilter.java:53)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> > ter(Applic
> > >ation
> > >FilterChain.java:202)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> > icationFil
> > >terCh
> > >ain.java:173)
> > > at
> > >org.roller.presentation.filters.SchemeEnforcementFilter.doFil
> > ter(Scheme
> > >Enfor
> > >cementFilter.java:97)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> > ter(Applic
> > >ation
> > >FilterChain.java:202)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> > icationFil
> > >terCh
> > >ain.java:173)
> > > at
> > >org.roller.presentation.filters.CharEncodingFilter.doFilter(C
> > harEncodin
> > >gFilt
> > >er.java:94)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> > ter(Applic
> > >ation
> > >FilterChain.java:202)
> > > at
> > >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> > icationFil
> > >terCh
> > >ain.java:173)
> > > at
> > >org.apache.catalina.core.StandardWrapperValve.invoke(Standard
> > WrapperVal
> > >ve.ja
> > >va:213)
> > > at
> > >org.apache.catalina.core.StandardContextValve.invoke(Standard
> > ContextVal
> > >ve.ja
> > >va:178)
> > > at
> > >org.apache.catalina.authenticator.AuthenticatorBase.invoke(Au
> > thenticato
> > >rBase
> > >.java:407)
> > > at
> > >org.apache.catalina.core.StandardHostValve.invoke(StandardHos
> > tValve.jav
> > >a:126
> > >)
> > > at
> > >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepor
> > tValve.jav
> > >a:105
> > >)
> > > at
> > >org.apache.catalina.core.StandardEngineValve.invoke(StandardE
> > ngineValve
> > >.java
> > >:107)
> > > at
> > >org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAda
> > pter.java:148)
> > > at
> > >org.apache.coyote.http11.Http11Processor.process(Http11Proces
> > sor.java:856)
> > > at
> > >org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandl
> > er.process
> > >Conne
> > >ction(Http11Protocol.java:744)
> > > at
> > >org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Pool
> > TcpEndpoin
> > >t.jav
> > >a:527)
> > > at
> > >org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(L
> > eaderFollo
> > >werWo
> > >rkerThread.java:80)
> > > at
> > >org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> > (ThreadPoo
> > >l.jav
> > >a:684)
> > > at java.lang.Thread.run(Thread.java:534)
> > >Caused by: java.sql.BatchUpdateException: Data too long for column
> > >'isenabled' at row 1
> > > at
> > >com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStateme
> > nt.java:1540)
> > > at
> > >org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(
> > Delegating
> > >State
> > >ment.java:294)
> > > at
> > >org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBat
> > cher.java:57)
> > > at
> > >org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatch
> > er.java:174)
> > > ... 57 more
> > >
> > >
> > >
> > >
> >
> >
>
>
RE: Can't add a new user with roller 2.0
Posted by zhangenpei <zh...@gmail.com>.
Anil wrote:
> Which specific MySQL 5.x server version are you using and
> which JDBC driver are you using?
>
mysql-5.0.16 and JDBC driver: mysql-connector-java-3.0.17.
And I found for every column whose type is "bit" there is always an error:
"Data too long for column '*******'".
Thans a lot!
> -----Original Message-----
> From: Anil Gangolli [mailto:anil@busybuddha.org]
> Sent: 28 November 2005 04:43
> To: roller-user@incubator.apache.org
> Subject: Re: Can't add a new user with roller 2.0
>
> Which specific MySQL 5.x server version are you using and
> which JDBC driver are you using?
>
> --a.
>
>
> zhangenpei wrote:
>
> >Hi,
> >
> >I just tried roller2.0 ( I am using tomcat5.5 and mysql 5.0
> ). But when
> >I tried to register a new user, I got the following
> exceptions. Could
> >you tell me how to resolve it?
> >
> >ERROR 2005-11-27 05:48:03,284 UserNewAction:add - ERROR in addUser
> >org.roller.RollerException
> > at
> >org.roller.business.hibernate.HibernateStrategy.commit(Hibern
> ateStrateg
> >y.jav
> >a:440)
> > at
> >org.roller.business.hibernate.HibernateRollerImpl.commit(Hibe
> rnateRolle
> >rImpl
> >.java:115)
> > at
> >org.roller.presentation.website.actions.UserNewAction.add(Use
> rNewAction
> >.java
> >:160)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
> sorImpl.ja
> >va:39
> >)
> > at
> >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
> hodAccesso
> >rImpl
> >.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:324)
> > at
> >org.apache.struts.actions.DispatchAction.dispatchMethod(Dispa
> tchAction.java:
> >276)
> > at
> >org.apache.struts.actions.DispatchAction.execute(DispatchActi
> on.java:196)
> > at
> >org.apache.struts.action.RequestProcessor.processActionPerfor
> m(RequestP
> >roces
> >sor.java:421)
> > at
> >org.apache.struts.action.RequestProcessor.process(RequestProc
> essor.java:226)
> > at
> >org.apache.struts.action.ActionServlet.process(ActionServlet.
> java:1164)
> > at
> >org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> ter(Applic
> >ation
> >FilterChain.java:252)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> icationFil
> >terCh
> >ain.java:173)
> > at
> >org.roller.presentation.filters.BreadCrumbFilter.doFilter(Bre
> adCrumbFil
> >ter.j
> >ava:77)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> ter(Applic
> >ation
> >FilterChain.java:202)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> icationFil
> >terCh
> >ain.java:173)
> > at
> >org.roller.presentation.filters.RequestFilter.doFilter(Reques
> tFilter.ja
> >va:13
> >4)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> ter(Applic
> >ation
> >FilterChain.java:202)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> icationFil
> >terCh
> >ain.java:173)
> > at
> >org.roller.presentation.filters.PersistenceSessionFilter.doFi
> lter(Persi
> >stenc
> >eSessionFilter.java:53)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> ter(Applic
> >ation
> >FilterChain.java:202)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> icationFil
> >terCh
> >ain.java:173)
> > at
> >org.roller.presentation.filters.SchemeEnforcementFilter.doFil
> ter(Scheme
> >Enfor
> >cementFilter.java:97)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> ter(Applic
> >ation
> >FilterChain.java:202)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> icationFil
> >terCh
> >ain.java:173)
> > at
> >org.roller.presentation.filters.CharEncodingFilter.doFilter(C
> harEncodin
> >gFilt
> >er.java:94)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> ter(Applic
> >ation
> >FilterChain.java:202)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> icationFil
> >terCh
> >ain.java:173)
> > at
> >org.apache.catalina.core.StandardWrapperValve.invoke(Standard
> WrapperVal
> >ve.ja
> >va:213)
> > at
> >org.apache.catalina.core.StandardContextValve.invoke(Standard
> ContextVal
> >ve.ja
> >va:178)
> > at
> >org.apache.catalina.authenticator.AuthenticatorBase.invoke(Au
> thenticato
> >rBase
> >.java:407)
> > at
> >org.apache.catalina.core.StandardHostValve.invoke(StandardHos
> tValve.jav
> >a:126
> >)
> > at
> >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepor
> tValve.jav
> >a:105
> >)
> > at
> >org.apache.catalina.core.StandardEngineValve.invoke(StandardE
> ngineValve
> >.java
> >:107)
> > at
> >org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAda
> pter.java:148)
> > at
> >org.apache.coyote.http11.Http11Processor.process(Http11Proces
> sor.java:856)
> > at
> >org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandl
> er.process
> >Conne
> >ction(Http11Protocol.java:744)
> > at
> >org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Pool
> TcpEndpoin
> >t.jav
> >a:527)
> > at
> >org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(L
> eaderFollo
> >werWo
> >rkerThread.java:80)
> > at
> >org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPoo
> >l.jav
> >a:684)
> > at java.lang.Thread.run(Thread.java:534)
> >--- ROOT CAUSE ---
> >org.hibernate.exception.GenericJDBCException: Could not execute JDBC
> >batch update
> > at
> >org.hibernate.exception.ErrorCodeConverter.handledNonSpecific
> Exception(
> >Error
> >CodeConverter.java:92)
> > at
> >org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeC
> onverter.j
> >ava:8
> >0)
> > at
> >org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep
> tionHelper
> >.java
> >:43)
> > at
> >org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatch
> er.java:181)
> > at
> >org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractB
> atcher.java:74)
> > at
> >org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractB
> atcher.java:69)
> > at
> >org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(Abst
> ractBatche
> >r.jav
> >a:150)
> > at
> >org.hibernate.persister.entity.BasicEntityPersister.insert(Ba
> sicEntityP
> >ersis
> >ter.java:1839)
> > at
> >org.hibernate.persister.entity.BasicEntityPersister.insert(Ba
> sicEntityP
> >ersis
> >ter.java:2200)
> > at
> >org.hibernate.action.EntityInsertAction.execute(EntityInsertA
> ction.java:46)
> > at
> org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> > at
> >org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> > at
> >org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> > at
> >org.hibernate.event.def.AbstractFlushingEventListener.perform
> Executions
> >(Abst
> >ractFlushingEventListener.java:274)
> > at
> >org.hibernate.event.def.DefaultFlushEventListener.onFlush(Def
> aultFlushE
> >ventL
> >istener.java:27)
> > at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> > at
> >org.roller.business.hibernate.HibernateStrategy.commit(Hibern
> ateStrateg
> >y.jav
> >a:428)
> > at
> >org.roller.business.hibernate.HibernateRollerImpl.commit(Hibe
> rnateRolle
> >rImpl
> >.java:115)
> > at
> >org.roller.presentation.website.actions.UserNewAction.add(Use
> rNewAction
> >.java
> >:160)
> > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> > at
> >sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
> sorImpl.ja
> >va:39
> >)
> > at
> >sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
> hodAccesso
> >rImpl
> >.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:324)
> > at
> >org.apache.struts.actions.DispatchAction.dispatchMethod(Dispa
> tchAction.java:
> >276)
> > at
> >org.apache.struts.actions.DispatchAction.execute(DispatchActi
> on.java:196)
> > at
> >org.apache.struts.action.RequestProcessor.processActionPerfor
> m(RequestP
> >roces
> >sor.java:421)
> > at
> >org.apache.struts.action.RequestProcessor.process(RequestProc
> essor.java:226)
> > at
> >org.apache.struts.action.ActionServlet.process(ActionServlet.
> java:1164)
> > at
> >org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> ter(Applic
> >ation
> >FilterChain.java:252)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> icationFil
> >terCh
> >ain.java:173)
> > at
> >org.roller.presentation.filters.BreadCrumbFilter.doFilter(Bre
> adCrumbFil
> >ter.j
> >ava:77)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> ter(Applic
> >ation
> >FilterChain.java:202)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> icationFil
> >terCh
> >ain.java:173)
> > at
> >org.roller.presentation.filters.RequestFilter.doFilter(Reques
> tFilter.ja
> >va:13
> >4)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> ter(Applic
> >ation
> >FilterChain.java:202)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> icationFil
> >terCh
> >ain.java:173)
> > at
> >org.roller.presentation.filters.PersistenceSessionFilter.doFi
> lter(Persi
> >stenc
> >eSessionFilter.java:53)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> ter(Applic
> >ation
> >FilterChain.java:202)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> icationFil
> >terCh
> >ain.java:173)
> > at
> >org.roller.presentation.filters.SchemeEnforcementFilter.doFil
> ter(Scheme
> >Enfor
> >cementFilter.java:97)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> ter(Applic
> >ation
> >FilterChain.java:202)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> icationFil
> >terCh
> >ain.java:173)
> > at
> >org.roller.presentation.filters.CharEncodingFilter.doFilter(C
> harEncodin
> >gFilt
> >er.java:94)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.internalDoFil
> ter(Applic
> >ation
> >FilterChain.java:202)
> > at
> >org.apache.catalina.core.ApplicationFilterChain.doFilter(Appl
> icationFil
> >terCh
> >ain.java:173)
> > at
> >org.apache.catalina.core.StandardWrapperValve.invoke(Standard
> WrapperVal
> >ve.ja
> >va:213)
> > at
> >org.apache.catalina.core.StandardContextValve.invoke(Standard
> ContextVal
> >ve.ja
> >va:178)
> > at
> >org.apache.catalina.authenticator.AuthenticatorBase.invoke(Au
> thenticato
> >rBase
> >.java:407)
> > at
> >org.apache.catalina.core.StandardHostValve.invoke(StandardHos
> tValve.jav
> >a:126
> >)
> > at
> >org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepor
> tValve.jav
> >a:105
> >)
> > at
> >org.apache.catalina.core.StandardEngineValve.invoke(StandardE
> ngineValve
> >.java
> >:107)
> > at
> >org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAda
> pter.java:148)
> > at
> >org.apache.coyote.http11.Http11Processor.process(Http11Proces
> sor.java:856)
> > at
> >org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandl
> er.process
> >Conne
> >ction(Http11Protocol.java:744)
> > at
> >org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Pool
> TcpEndpoin
> >t.jav
> >a:527)
> > at
> >org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(L
> eaderFollo
> >werWo
> >rkerThread.java:80)
> > at
> >org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPoo
> >l.jav
> >a:684)
> > at java.lang.Thread.run(Thread.java:534)
> >Caused by: java.sql.BatchUpdateException: Data too long for column
> >'isenabled' at row 1
> > at
> >com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStateme
> nt.java:1540)
> > at
> >org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(
> Delegating
> >State
> >ment.java:294)
> > at
> >org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBat
> cher.java:57)
> > at
> >org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatch
> er.java:174)
> > ... 57 more
> >
> >
> >
> >
>
>
Re: Can't add a new user with roller 2.0
Posted by Anil Gangolli <an...@busybuddha.org>.
Which specific MySQL 5.x server version are you using and which JDBC
driver are you using?
--a.
zhangenpei wrote:
>Hi,
>
>I just tried roller2.0 ( I am using tomcat5.5 and mysql 5.0 ). But when I
>tried to register a new user, I got the following exceptions. Could you
>tell me how to resolve it?
>
>ERROR 2005-11-27 05:48:03,284 UserNewAction:add - ERROR in addUser
>org.roller.RollerException
> at
>org.roller.business.hibernate.HibernateStrategy.commit(HibernateStrategy.jav
>a:440)
> at
>org.roller.business.hibernate.HibernateRollerImpl.commit(HibernateRollerImpl
>.java:115)
> at
>org.roller.presentation.website.actions.UserNewAction.add(UserNewAction.java
>:160)
> 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:324)
> at
>org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:
>276)
> at
>org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
> at
>org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
>sor.java:421)
> at
>org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
> at
>org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
> at
>org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:252)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:173)
> at
>org.roller.presentation.filters.BreadCrumbFilter.doFilter(BreadCrumbFilter.j
>ava:77)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:202)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:173)
> at
>org.roller.presentation.filters.RequestFilter.doFilter(RequestFilter.java:13
>4)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:202)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:173)
> at
>org.roller.presentation.filters.PersistenceSessionFilter.doFilter(Persistenc
>eSessionFilter.java:53)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:202)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:173)
> at
>org.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeEnfor
>cementFilter.java:97)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:202)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:173)
> at
>org.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncodingFilt
>er.java:94)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:202)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:173)
> at
>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
>va:213)
> at
>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
>va:178)
> at
>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
>.java:407)
> 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.processConne
>ction(Http11Protocol.java:744)
> at
>org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
>a:527)
> at
>org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
>rkerThread.java:80)
> at
>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
>a:684)
> at java.lang.Thread.run(Thread.java:534)
>--- ROOT CAUSE ---
>org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch
>update
> at
>org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(Error
>CodeConverter.java:92)
> at
>org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:8
>0)
> at
>org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java
>:43)
> at
>org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:181)
> at
>org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:74)
> at
>org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:69)
> at
>org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.jav
>a:150)
> at
>org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersis
>ter.java:1839)
> at
>org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersis
>ter.java:2200)
> at
>org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
> at
>org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
> at
>org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
> at
>org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(Abst
>ractFlushingEventListener.java:274)
> at
>org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventL
>istener.java:27)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
> at
>org.roller.business.hibernate.HibernateStrategy.commit(HibernateStrategy.jav
>a:428)
> at
>org.roller.business.hibernate.HibernateRollerImpl.commit(HibernateRollerImpl
>.java:115)
> at
>org.roller.presentation.website.actions.UserNewAction.add(UserNewAction.java
>:160)
> 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:324)
> at
>org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:
>276)
> at
>org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
> at
>org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
>sor.java:421)
> at
>org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
> at
>org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
> at
>org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:252)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:173)
> at
>org.roller.presentation.filters.BreadCrumbFilter.doFilter(BreadCrumbFilter.j
>ava:77)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:202)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:173)
> at
>org.roller.presentation.filters.RequestFilter.doFilter(RequestFilter.java:13
>4)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:202)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:173)
> at
>org.roller.presentation.filters.PersistenceSessionFilter.doFilter(Persistenc
>eSessionFilter.java:53)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:202)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:173)
> at
>org.roller.presentation.filters.SchemeEnforcementFilter.doFilter(SchemeEnfor
>cementFilter.java:97)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:202)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:173)
> at
>org.roller.presentation.filters.CharEncodingFilter.doFilter(CharEncodingFilt
>er.java:94)
> at
>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
>FilterChain.java:202)
> at
>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
>ain.java:173)
> at
>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
>va:213)
> at
>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
>va:178)
> at
>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase
>.java:407)
> 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.processConne
>ction(Http11Protocol.java:744)
> at
>org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
>a:527)
> at
>org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
>rkerThread.java:80)
> at
>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
>a:684)
> at java.lang.Thread.run(Thread.java:534)
>Caused by: java.sql.BatchUpdateException: Data too long for column
>'isenabled' at row 1
> at
>com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1540)
> at
>org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingState
>ment.java:294)
> at
>org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:57)
> at
>org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:174)
> ... 57 more
>
>
>
>