Problem in using mysql+alfresco

[mialfresco]

Hi team, from the last few days i'm facing a problem with configuring the mysql with alfresco.
Environment:

OS: windows XP professional edition
Alfresco: 3.0 labs stable version
My SQL: mysql-essential-5.0.18-win32

what i have done is, i installed My SQL sucessfully in my local machine.

custom-repository.properties

db.driver=org.gjt.mm.mysql.Driver#db.driver=com.mysql.jdbc.Driverdb.url=jdbc:mysql://localhost:3306/alfresco‍‍‍‍

i kept mysql-connector-java-5.1.6-bin.jar as it is in tomcat/lib.
and even tried db.driver=com.mysql.jdbc.Driver and db.url=jdbc:mysql://localhost:3306/alfresco  in custom-repository.properties.


custom-hibernate-dialect.properties

## MySQL dialect (default)#hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect#hibernate.dialect=org.hibernate.dialect.MySQLDialect‍‍‍‍‍

even i tried with hibernate.dialect=org.hibernate.dialect.MySQLDialect

NOTE: even i tired this jar mysql-connector-java-3.1.6-bin.jar and removed the existing jar and viceversa and i intslled alfresco and mysql in C:\ drive and still there is 3 gb free space avaiable in this drive.

But still no luck. any compatible issues.

15:28:16,493  INFO  [config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]15:28:50,551  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.15:28:56,443  ERROR [domain.schema.SchemaBootstrap] Schema auto-update failedorg.hibernate.exception.GenericJDBCException: could not get table metadata: alf_audit_fact        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:105)        at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:954)        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:649)        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1123)        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)        at org.apache.catalina.core.StandardService.start(StandardService.java:516)        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)        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:585)        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)Caused by: java.sql.SQLException: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_f0c_0.MYD' (Errcode: 17)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2291)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)        at com.mysql.jdbc.Statement.executeQuery(Statement.java:1159)        at com.mysql.jdbc.DatabaseMetaData.getColumns(DatabaseMetaData.java:890)        at org.hibernate.tool.hbm2ddl.TableMetadata.initColumns(TableMetadata.java:146)        at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:32)        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:90)        … 36 more15:28:56,459  ERROR [web.context.ContextLoader] Context initialization failedorg.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1192)        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)        at org.apache.catalina.core.StandardService.start(StandardService.java:516)        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)        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:585)        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)Caused by: org.hibernate.exception.GenericJDBCException: could not get table metadata: alf_audit_fact        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)        at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:105)        at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:954)        at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:649)        at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1123)        … 33 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

any help is appriciated.

[mialfresco]

I think this is causing the problem.

Caused by: java.sql.SQLException: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_f0c_0.MYD' (Errcode: 17)        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2291)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)        at com.mysql.jdbc.Statement.executeQuery(Statement.java:1159‍‍‍‍‍‍‍‍

How to cross this?

[mikeh]

Disable your McAfee (or other) virus scanner for .myd and .myi files.

Mike

[mialfresco]

Hi mike,
thanks for your quick reply.
Yes, you are right.
After disabling the McAfee the previous error was gone.
And there was some column lenght problem in a table.
the following error i'm getting now.

17:49:45,096  INFO  [config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]17:50:18,373  INFO  [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.17:50:22,077  INFO  [domain.schema.SchemaBootstrap] No changes were made to theschema.17:51:10,359 User:System ERROR [web.context.ContextLoader] Context initialization failedorg.alfresco.error.AlfrescoRuntimeException: Bootstrap failed        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:351)        at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:702)        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)        at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)        at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:830)        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:719)        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)        at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)        at org.apache.catalina.core.StandardService.start(StandardService.java:516)        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)        at org.apache.catalina.startup.Catalina.start(Catalina.java:578)        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:585)        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: [org.alfresco.repo.domain.hibernate.NodeImpl]; nested exception is org.hibernate.exception.DataException: could not insert: [org.alfresco.repo.domain.hibernate.NodeImpl]        at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:616)        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:377)        at org.springframework.orm.hibernate3.HibernateTemplate.save(HibernateTemplate.java:632)        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.newNode(HibernateNodeDaoServiceImpl.java:859)        at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.createStore(HibernateNodeDaoServiceImpl.java:635)        at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)        at java.lang.reflect.Method.invoke(Method.java:585)        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)        at org.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)        at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:381)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)        at $Proxy2.createStore(Unknown Source)        at org.alfresco.repo.node.db.DbNodeServiceImpl.createStore(DbNodeServiceImpl.java:214)        at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)        at java.lang.reflect.Method.invoke(Method.java:585)        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)        at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:163)        at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)        at $Proxy7.createStore(Unknown Source)        at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)        at java.lang.reflect.Method.invoke(Method.java:585)        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)        at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)        at $Proxy7.createStore(Unknown Source)        at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)        at java.lang.reflect.Method.invoke(Method.java:585)        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)        at $Proxy8.createStore(Unknown Source)        at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)        at java.lang.reflect.Method.invoke(Method.java:585)        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:306)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:306)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:274)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:274)        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)        at $Proxy7.createStore(Unknown Source)        at org.alfresco.repo.importer.ImporterBootstrap.doImport(ImporterBootstrap.java:376)        at org.alfresco.repo.importer.ImporterBootstrap.access$000(ImporterBootstrap.java:72)        at org.alfresco.repo.importer.ImporterBootstrap$1$1.execute(ImporterBootstrap.java:340)        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)        at org.alfresco.repo.importer.ImporterBootstrap$1.doWork(ImporterBootstrap.java:344)        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:437)        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:347)        … 34 moreCaused by: org.hibernate.exception.DataException: could not insert: [org.alfresco.repo.domain.hibernate.NodeImpl]        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)        at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2163)        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2643)        at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:51)        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:322)        at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)        at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)        at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)        at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)        at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)        at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)        at org.springframework.orm.hibernate3.HibernateTemplate$12.doInHibernate(HibernateTemplate.java:635)        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)        … 99 moreCaused by: java.sql.SQLException: Data too long for column 'node_deleted' at row 1        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)        at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1812)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1906)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1831)        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1693)        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)        at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)        at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)        … 116 moreJul 27, 2009 5:51:10 PM org.apache.catalina.core.StandardContext startSEVERE: Error listenerStartJul 27, 2009 5:51:10 PM org.apache.catalina.core.StandardContext startSEVERE: Context [/alfresco] startup failed due to previous errorslog4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.Jul 27, 2009 5:51:17 PM org.apache.catalina.startup.HostConfig deployWARINFO: Deploying web application archive share.war17:51:40,870  INFO  [web.site.FrameworkHelper] Successfully Initialized Web FrameworkJul 27, 2009 5:51:41 PM org.apache.catalina.startup.HostConfig deployWARINFO: Deploying web application archive studio.war‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[mialfresco]

even i tried with a new (version) jar mysql-connector-java-5.1.7-bin.jar

but still no luck.

[mialfresco]

Hi team,
can anyone suggest me what is the solution for this problem?