You are viewing a plain text version of this content. The canonical link for it is here.
Posted to sandesha-dev@ws.apache.org by Jerome Camilleri <je...@bull.net> on 2007/03/13 17:18:55 UTC
Sandesha PermanentStorageManager Derby/Hibernate SQL error
Hi,
I try to used the permanent storage manager give by WSO2 for sandesha
(thanks about this contribution).
That run well but after some exchanges I have systematicly an SQL error
throws on the server during accessing database :
"A truncation error was encountered trying to shrink VARCHAR
'[urn:uuid:FC5F69C3DA38EEBF8D1173802071062, urn:uuid:FC5F69C3&' to
length 255."
Currently I have the simply solution to delete this database and launch
my server which create during sandesha intialisation the new database.
But if I would like to used this configuration into a real system, I
can't do this !
So adding permanent storage of message into database increase the
reliable of the system but on the other hands I had to deal with
database problem...
Does someone already had this kind of error ?
If yes do you arrived to solve your problem with a DB tools of Derby for
example ?
Sandesha2.1.1
derby10.2.2.0
hibernate3.2.2
axis2-1.1.1
Regards
Jerome
Re: Sandesha PermanentStorageManager Derby/Hibernate SQL error
Posted by Chamikara Jayalath <ch...@gmail.com>.
Hi Jerome,
I'll look into this problem in detail.
As a temporary solution can u try increasing the length of the 'value' entry
of the SequencePropertyTable.
To do this change to following line of the Sandesha2beans.hbm.xml,
<property name="value" column="c_value" />
to
<property name="value" column="c_value" type="text" length="1000" />
Thanks,
Chamikara
On 3/13/07, Jerome Camilleri <je...@bull.net> wrote:
>
> Hi,
>
> I try to used the permanent storage manager give by WSO2 for sandesha
> (thanks about this contribution).
> That run well but after some exchanges I have systematicly an SQL error
> throws on the server during accessing database :
> "A truncation error was encountered trying to shrink VARCHAR
> '[urn:uuid:FC5F69C3DA38EEBF8D1173802071062, urn:uuid:FC5F69C3&' to
> length 255."
>
> Currently I have the simply solution to delete this database and launch
> my server which create during sandesha intialisation the new database.
> But if I would like to used this configuration into a real system, I
> can't do this !
> So adding permanent storage of message into database increase the
> reliable of the system but on the other hands I had to deal with
> database problem...
> Does someone already had this kind of error ?
> If yes do you arrived to solve your problem with a DB tools of Derby for
> example ?
>
> Sandesha2.1.1
> derby10.2.2.0
> hibernate3.2.2
> axis2-1.1.1
>
> Regards
>
>
> Jerome
>
> 2007-03-13 17:10:30,180 WARN org.hibernate.util.JDBCExceptionReporter -
> SQL Error: 20000, SQLState: 22001
> 2007-03-13 17:10:30,180 ERROR org.hibernate.util.JDBCExceptionReporter - A
> truncation error was encountered trying to shrink VARCHAR
> '[urn:uuid:FC5F69C3DA38EEBF8D1173802071062, urn:uuid:FC5F69C3&' to length
> 255.
> 2007-03-13 17:10:30,180 ERROR
> org.hibernate.event.def.AbstractFlushingEventListener - Could not
> synchronize database state with session
> org.hibernate.exception.DataException: could not update: [
> org.apache.sandesha2.storage.beans.SequencePropertyBean#11]
> at org.hibernate.exception.SQLStateConverter.convert(
> SQLStateConverter.java:77)
> at org.hibernate.exception.JDBCExceptionHelper.convert(
> JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.AbstractEntityPersister.update(
> AbstractEntityPersister.java:2421)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(
> AbstractEntityPersister.java:2303)
> at org.hibernate.persister.entity.AbstractEntityPersister.update(
> AbstractEntityPersister.java:2603)
> at org.hibernate.action.EntityUpdateAction.execute(
> EntityUpdateAction.java:92)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
> at org.hibernate.engine.ActionQueue.executeActions(
> ActionQueue.java:232)
> at org.hibernate.engine.ActionQueue.executeActions(
> ActionQueue.java:140)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
> AbstractFlushingEventListener.java:298)
> at
> org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(
> DefaultAutoFlushEventListener.java:41)
> at org.hibernate.impl.SessionImpl.autoFlushIfRequired(
> SessionImpl.java:969)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1562)
> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
> at
> org.wso2.sandesha2.storage.persistent.hibernate.PersistentSequencePropertyBeanMgr.retrieve
> (PersistentSequencePropertyBeanMgr.java:76)
> at org.apache.sandesha2.util.SandeshaUtil.getRMVersion(
> SandeshaUtil.java:929)
> at
> org.apache.sandesha2.util.RMMsgCreator.createCreateSeqResponseMsg(
> RMMsgCreator.java:504)
> at
> org.apache.sandesha2.msgprocessors.CreateSeqMsgProcessor.processInMessage(
> CreateSeqMsgProcessor.java:128)
> at org.apache.sandesha2.handlers.SandeshaInHandler.invoke(
> SandeshaInHandler.java:155)
> at org.apache.axis2.engine.Phase.invoke(Phase.java:382)
> at org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:522)
> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:487)
> at
> org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(
> HTTPTransportUtils.java:328)
> at org.apache.axis2.transport.http.AxisServlet.doPost(
> AxisServlet.java:254)
> 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(
> ApplicationFilterChain.java:252)
> 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.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:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> (Http11BaseProtocol.java:664)
> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> PoolTcpEndpoint.java:527)
> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:80)
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:684)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.SQLException: A truncation error was encountered
> trying to shrink VARCHAR '[urn:uuid:FC5F69C3DA38EEBF8D1173802071062,
> urn:uuid:FC5F69C3&' to length 255.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
> Source)
> at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(
> NonBatchingBatcher.java:23)
> at org.hibernate.persister.entity.AbstractEntityPersister.update(
> AbstractEntityPersister.java:2399)
> ... 37 more
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: sandesha-dev-unsubscribe@ws.apache.org
> For additional commands, e-mail: sandesha-dev-help@ws.apache.org
>
Re: Sandesha PermanentStorageManager Derby/Hibernate SQL error
Posted by Chamikara Jayalath <ch...@gmail.com>.
Hi Jerome,
I'll look into this problem in detail.
As a temporary solution can u try increasing the length of the 'value' entry
of the SequencePropertyTable.
To do this change to following line of the Sandesha2beans.hbm.xml,
<property name="value" column="c_value" />
to
<property name="value" column="c_value" type="text" length="1000" />
Thanks,
Chamikara
On 3/13/07, Jerome Camilleri <je...@bull.net> wrote:
>
> Hi,
>
> I try to used the permanent storage manager give by WSO2 for sandesha
> (thanks about this contribution).
> That run well but after some exchanges I have systematicly an SQL error
> throws on the server during accessing database :
> "A truncation error was encountered trying to shrink VARCHAR
> '[urn:uuid:FC5F69C3DA38EEBF8D1173802071062, urn:uuid:FC5F69C3&' to
> length 255."
>
> Currently I have the simply solution to delete this database and launch
> my server which create during sandesha intialisation the new database.
> But if I would like to used this configuration into a real system, I
> can't do this !
> So adding permanent storage of message into database increase the
> reliable of the system but on the other hands I had to deal with
> database problem...
> Does someone already had this kind of error ?
> If yes do you arrived to solve your problem with a DB tools of Derby for
> example ?
>
> Sandesha2.1.1
> derby10.2.2.0
> hibernate3.2.2
> axis2-1.1.1
>
> Regards
>
>
> Jerome
>
> 2007-03-13 17:10:30,180 WARN org.hibernate.util.JDBCExceptionReporter -
> SQL Error: 20000, SQLState: 22001
> 2007-03-13 17:10:30,180 ERROR org.hibernate.util.JDBCExceptionReporter - A
> truncation error was encountered trying to shrink VARCHAR
> '[urn:uuid:FC5F69C3DA38EEBF8D1173802071062, urn:uuid:FC5F69C3&' to length
> 255.
> 2007-03-13 17:10:30,180 ERROR
> org.hibernate.event.def.AbstractFlushingEventListener - Could not
> synchronize database state with session
> org.hibernate.exception.DataException: could not update: [
> org.apache.sandesha2.storage.beans.SequencePropertyBean#11]
> at org.hibernate.exception.SQLStateConverter.convert(
> SQLStateConverter.java:77)
> at org.hibernate.exception.JDBCExceptionHelper.convert(
> JDBCExceptionHelper.java:43)
> at org.hibernate.persister.entity.AbstractEntityPersister.update(
> AbstractEntityPersister.java:2421)
> at
> org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(
> AbstractEntityPersister.java:2303)
> at org.hibernate.persister.entity.AbstractEntityPersister.update(
> AbstractEntityPersister.java:2603)
> at org.hibernate.action.EntityUpdateAction.execute(
> EntityUpdateAction.java:92)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
> at org.hibernate.engine.ActionQueue.executeActions(
> ActionQueue.java:232)
> at org.hibernate.engine.ActionQueue.executeActions(
> ActionQueue.java:140)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
> AbstractFlushingEventListener.java:298)
> at
> org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(
> DefaultAutoFlushEventListener.java:41)
> at org.hibernate.impl.SessionImpl.autoFlushIfRequired(
> SessionImpl.java:969)
> at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1562)
> at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
> at
> org.wso2.sandesha2.storage.persistent.hibernate.PersistentSequencePropertyBeanMgr.retrieve
> (PersistentSequencePropertyBeanMgr.java:76)
> at org.apache.sandesha2.util.SandeshaUtil.getRMVersion(
> SandeshaUtil.java:929)
> at
> org.apache.sandesha2.util.RMMsgCreator.createCreateSeqResponseMsg(
> RMMsgCreator.java:504)
> at
> org.apache.sandesha2.msgprocessors.CreateSeqMsgProcessor.processInMessage(
> CreateSeqMsgProcessor.java:128)
> at org.apache.sandesha2.handlers.SandeshaInHandler.invoke(
> SandeshaInHandler.java:155)
> at org.apache.axis2.engine.Phase.invoke(Phase.java:382)
> at org.apache.axis2.engine.AxisEngine.invoke(AxisEngine.java:522)
> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:487)
> at
> org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(
> HTTPTransportUtils.java:328)
> at org.apache.axis2.transport.http.AxisServlet.doPost(
> AxisServlet.java:254)
> 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(
> ApplicationFilterChain.java:252)
> 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.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:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> (Http11BaseProtocol.java:664)
> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> PoolTcpEndpoint.java:527)
> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:80)
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:684)
> at java.lang.Thread.run(Thread.java:595)
> Caused by: java.sql.SQLException: A truncation error was encountered
> trying to shrink VARCHAR '[urn:uuid:FC5F69C3DA38EEBF8D1173802071062,
> urn:uuid:FC5F69C3&' to length 255.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
> Source)
> at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(
> NonBatchingBatcher.java:23)
> at org.hibernate.persister.entity.AbstractEntityPersister.update(
> AbstractEntityPersister.java:2399)
> ... 37 more
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: sandesha-dev-unsubscribe@ws.apache.org
> For additional commands, e-mail: sandesha-dev-help@ws.apache.org
>