topic Hibernate Exception Handling Japanese against SQL Server in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/hibernate-exception-handling-japanese-against-sql-server/m-p/67937#M43470 <HTML><HEAD></HEAD><BODY><SPAN>I run Alfresco tomcat bundle 1.4.0beta on windows 2003, sql server 2000. When I was trying to import a file named : （提出不要）mn-翻訳者用語リスト_翻訳コメント_10676982.txt, the following error occurred:</SPAN><BR /><SPAN>Either jtds-1.2.jar or msdriver.jar does not work. However, this file name can be handled correctly if I switched to mysql 5.0. </SPAN><BR /><SPAN>Any hints will be appreciated. </SPAN><BR /><PRE class="language-none line-numbers"><CODE>org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute update query; uncategorized SQLException for SQL [update alf_child_assoc set child_node_name=?, child_node_name_crc=? where id=?]; SQL state [01004]; error code [0]; Data truncation; nested exception is java.sql.DataTruncation: Data truncation<BR />java.sql.DataTruncation: Data truncation<BR />&nbsp;&nbsp;&nbsp;at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:379)<BR />&nbsp;&nbsp;&nbsp;at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)<BR />&nbsp;&nbsp;&nbsp;at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)<BR />&nbsp;&nbsp;&nbsp;at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)<BR />&nbsp;&nbsp;&nbsp;at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)<BR />&nbsp;&nbsp;&nbsp;at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)<BR />&nbsp;&nbsp;&nbsp;at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)<BR />&nbsp;&nbsp;&nbsp;at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:334)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:209)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1126)<BR />&nbsp;&nbsp;&nbsp;at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:94)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$4.doInHibernate(HibernateNodeDaoServiceImpl.java:591)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:365)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:333)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.setChildNameUnique(HibernateNodeDaoServiceImpl.java:596)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor491.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:60)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)<BR />&nbsp;&nbsp;&nbsp;at $Proxy1.setChildNameUnique(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.setChildUniqueName(DbNodeServiceImpl.java:1853)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.node.db.DbNodeServiceImpl.createNode(DbNodeServiceImpl.java:312)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor662.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:213)<BR />&nbsp;&nbsp;&nbsp;at $Proxy2.createNode(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.model.filefolder.FileFolderServiceImpl.create(FileFolderServiceImpl.java:683)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.GeneratedMethodAccessor714.invoke(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:116)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)<BR />&nbsp;&nbsp;&nbsp;at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:41)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditComponentImpl.auditImpl(AuditComponentImpl.java:210)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:156)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:61)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)<BR />&nbsp;&nbsp;&nbsp;at $Proxy29.create(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.filesys.smb.server.repo.CifsHelper.createNode(CifsHelper.java:355)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.filesys.smb.server.repo.ContentDiskDriver.createFile(ContentDiskDriver.java:1230)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.filesys.smb.server.NTProtocolHandler.procNTCreateAndX(NTProtocolHandler.java:5292)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.filesys.smb.server.NTProtocolHandler.runProtocol(NTProtocolHandler.java:305)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.filesys.smb.server.SMBSrvSession.runHandler(SMBSrvSession.java:1662)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.filesys.smb.server.SMBSrvSession.run(SMBSrvSession.java:1563)<BR />&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:595)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Wed, 15 Nov 2006 07:18:33 GMT hfrank 2006-11-15T07:18:33Z Hibernate Exception Handling Japanese against SQL Server https://connect.hyland.com/t5/alfresco-archive/hibernate-exception-handling-japanese-against-sql-server/m-p/67937#M43470 I run Alfresco tomcat bundle 1.4.0beta on windows 2003, sql server 2000. When I was trying to import a file named : （提出不要）mn-翻訳者用語リスト_翻訳コメント_10676982.txt, the following error occurred:Either jtds-1.2.jar or msdriver.jar does not work. However, this file name can be handled correctly if I switched to Wed, 15 Nov 2006 07:18:33 GMT https://connect.hyland.com/t5/alfresco-archive/hibernate-exception-handling-japanese-against-sql-server/m-p/67937#M43470 hfrank 2006-11-15T07:18:33Z Re: Hibernate Exception Handling Japanese against SQL Server https://connect.hyland.com/t5/alfresco-archive/hibernate-exception-handling-japanese-against-sql-server/m-p/67938#M43471 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>Try manually increasing the size of the </SPAN><STRONG>child_node_name</STRONG><SPAN> column in </SPAN><STRONG>alf_child_assoc</STRONG><SPAN>.</SPAN><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Mon, 04 Dec 2006 14:31:13 GMT https://connect.hyland.com/t5/alfresco-archive/hibernate-exception-handling-japanese-against-sql-server/m-p/67938#M43471 derek 2006-12-04T14:31:13Z Re: Hibernate Exception Handling Japanese against SQL Server https://connect.hyland.com/t5/alfresco-archive/hibernate-exception-handling-japanese-against-sql-server/m-p/67939#M43472 <HTML><HEAD></HEAD><BODY><SPAN>Hi Derek,</SPAN><BR /><BR /><SPAN>It works.</SPAN><BR /><SPAN>Thank you for your help. </SPAN><BR /><BR /><SPAN>However, could you tell me why mysql5.0 works well even without this change ?</SPAN><BR /><BR /><SPAN>Best Regards</SPAN></BODY></HTML> Thu, 08 Feb 2007 08:46:29 GMT https://connect.hyland.com/t5/alfresco-archive/hibernate-exception-handling-japanese-against-sql-server/m-p/67939#M43472 hfrank 2007-02-08T08:46:29Z Re: Hibernate Exception Handling Japanese against SQL Server https://connect.hyland.com/t5/alfresco-archive/hibernate-exception-handling-japanese-against-sql-server/m-p/67940#M43473 <HTML><HEAD></HEAD><BODY><SPAN>What encoding are you using for the database?</SPAN><BR /><SPAN>What length did you assign to the column?</SPAN></BODY></HTML> Mon, 12 Feb 2007 16:01:24 GMT https://connect.hyland.com/t5/alfresco-archive/hibernate-exception-handling-japanese-against-sql-server/m-p/67940#M43473 derek 2007-02-12T16:01:24Z