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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
