[Mashup-dev] [jira] Commented: (MASHUP-1031) Exceptions occur when deploying mashups if the username is greater than 20 characters

[Keith Godwin Chapman (JIRA)]

    [ https://wso2.org/jira/browse/MASHUP-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18400#action_18400 ] 

Keith Godwin Chapman commented on MASHUP-1031:
----------------------------------------------

Fixed in revision 20161 by changing the USER_ID field to 255 characters. Fixed the svn externels to rely on revision 10159 of the registry database scripts

> Exceptions occur when deploying mashups if the username is greater than 20 characters
> -------------------------------------------------------------------------------------
>
>                 Key: MASHUP-1031
>                 URL: https://wso2.org/jira/browse/MASHUP-1031
>             Project: WSO2 Mashup Server
>          Issue Type: Bug
>            Reporter: Keith Godwin Chapman
>            Assignee: Keith Godwin Chapman
>            Priority: Blocker
>             Fix For: 1.5.1
>
>
> ERROR [2008-07-29 22:40:28,850]  Failed to put resource /mashups/abcdefghijklmnopqrstuvwxyz/foo. All database operations will be rolled back. Failed to add log entry for resource /mashups/abcdefghijklmnopqrstuvwxyz/foo. A truncation error was encountered trying to shrink VARCHAR 'abcdefghijklmnopqrstuvwxyz' to length 20.
> org.wso2.registry.exceptions.RegistryException: Failed to add log entry for resource /mashups/abcdefghijklmnopqrstuvwxyz/foo. A truncation error was encountered trying to shrink VARCHAR 'abcdefghijklmnopqrstuvwxyz' to length 20.
> 	at org.wso2.registry.jdbc.dao.LogsDAO.addLog(LogsDAO.java:63)
> 	at org.wso2.registry.jdbc.Repository.add(Repository.java:403)
> 	at org.wso2.registry.jdbc.Repository.put(Repository.java:165)
> 	at org.wso2.registry.jdbc.BasicRegistry.put(BasicRegistry.java:194)
> 	at org.wso2.registry.jdbc.AtomicRegistry.put(AtomicRegistry.java:255)
> 	at org.wso2.registry.jdbc.JDBCRegistry.put(JDBCRegistry.java:329)
> 	at org.wso2.registry.session.UserRegistry.put(UserRegistry.java:209)
> 	at org.wso2.mashup.utils.MashupUtils.addToRegistry(MashupUtils.java:1070)
> 	at org.wso2.mashup.utils.MashupUtils.populateRegistry(MashupUtils.java:969)
> 	at org.wso2.mashup.deployer.JSDeployer.deploy(JSDeployer.java:242)
> 	at org.apache.axis2.deployment.repository.util.DeploymentFileData.deploy(DeploymentFileData.java:136)
> 	at org.apache.axis2.deployment.DeploymentEngine.doDeploy(DeploymentEngine.java:597)
> 	at org.apache.axis2.deployment.repository.util.WSInfoList.update(WSInfoList.java:144)
> 	at org.apache.axis2.deployment.RepositoryListener.update(RepositoryListener.java:330)
> 	at org.apache.axis2.deployment.RepositoryListener.checkServices(RepositoryListener.java:227)
> 	at org.apache.axis2.deployment.RepositoryListener.startListener(RepositoryListener.java:324)
> 	at org.apache.axis2.deployment.scheduler.SchedulerTask.checkRepository(SchedulerTask.java:64)
> 	at org.apache.axis2.deployment.scheduler.SchedulerTask.run(SchedulerTask.java:71)
> 	at org.apache.axis2.deployment.scheduler.Scheduler$SchedulerTimerTask.run(Scheduler.java:83)
> 	at java.util.TimerThread.mainLoop(Timer.java:512)
> 	at java.util.TimerThread.run(Timer.java:462)
> Caused by: SQL Exception: A truncation error was encountered trying to shrink VARCHAR 'abcdefghijklmnopqrstuvwxyz' to length 20.
> 	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.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> 	at org.wso2.registry.jdbc.dao.LogsDAO.addLog(LogsDAO.java:55)
> 	... 20 more
>  INFO [2008-07-29 22:40:28,851]  org.apache.axis2.deployment.DeploymentException: Failed to put resource /mashups/abcdefghijklmnopqrstuvwxyz/foo. All database operations will be rolled back. Failed to add log entry for resource /mashups/abcdefghijklmnopqrstuvwxyz/foo. A truncation error was encountered trying to shrink VARCHAR 'abcdefghijklmnopqrstuvwxyz' to length 20.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira