Field 'update_date' doesn't have a default value

[iagotomas]

Hi all,after installing the latest jasperserver release and importing some old reports generated and maintained in JS 3.5, the generation of new reports produces the exception i add below. The report is being generated successfully, it's sent to the recipient with the report attached and this exception, also the report isn't being saved in the JS folder, does anyone have any clue to solve this?

Code:

com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.ContentRepoFileResource]Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.ContentRepoFileResource]	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.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2108)	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2588)	at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)	at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:290)	at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:180)	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:108)	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:98)	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateCompositeSaveOrUpdateListener.onSaveOrUpdate(HibernateCompositeSaveOrUpdateListener.java:56)	at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507)	at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499)	at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:495)	at org.springframework.orm.hibernate3.HibernateTemplate$16.doInHibernate(HibernateTemplate.java:684)	at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:367)	at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:681)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$5.execute(HibernateRepositoryServiceImpl.java:340)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:76)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:67)	at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:330)	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:597)	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)	at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)	at $Proxy56.saveResource(Unknown Source)	at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.saveToRepository(ReportExecutionJob.java:862)	at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.saveToRepository(ReportExecutionJob.java:516)	at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:383)	at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:188)	at org.quartz.core.JobRunShell.run(JobRunShell.java:195)	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)Caused by: java.sql.SQLException: Field 'update_date' doesn't have a default value	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362)	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2280)	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2265)	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)	at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)	... 41 more

 

Post Edited by iagotomas at 07/29/2010 11:37

[lucianc]

You might still have some old JS 3.5 jars in your application, check that again.

Regards,

Lucian