jasperserver problem with mysql 5.5 reserved word maxvalue

[ismails]

Hello everyone I'm in trouble with jasperreport server for 3 weaks. I will be very very greatfull for any idea to solve this problem. Thank you in advance

I have changed sections that

type=InnoDB to engine=InnoDB
and
maxValue to `maxValue` (this change is needed only in js-create.dll. It's a field in JIDataType table)

- mysql/js-create.dll and
- mysql/quartz.dll
I did this because the word maxValue is a reserved word for many sql servers so I told mysql maxValue is a variable name not comman by backticking it.
but now I'm getting another error.
Here is some part of my installation log:

-java- Imported resource /datasources/JServerJNDIDS

-java- About to save resource /datasources/repositoryDS

-java- Imported resource /datasources/repositoryDS

-java- About to save resource /datatypes/date

-java- 2012-09-23 21:55:54,299  WARN JDBCExceptionReporter:100 - SQL Error: 1064, SQLState: 42000

-java- 2012-09-23 21:55:54,301 ERROR JDBCExceptionReporter:101 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'maxValue, strictMin, strictMax, id) values (3, null, null, null, null, null, 0, ' at line 1

-java- 2012-09-23 21:55:54,303 ERROR HibernateDaoImpl:79 - Hibernate DataAccessException

-java- org.springframework.dao.InvalidDataAccessResourceUsageException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoDataType]; nested exception is org.hibernate.exception.SQLGrammarException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoDataType]

-java- at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)

-java- at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)

-java- at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)

-java- at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)

-java- at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:748)

-java- at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$12.execute(HibernateRepositoryServiceImpl.java:459)

-java- at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:73)

-java- at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeWriteCallback(HibernateDaoImpl.java:64)

-java- at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.saveResource(HibernateRepositoryServiceImpl.java:430)

-java- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

-java- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

-java- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

-java- at java.lang.reflect.Method.invoke(Method.java:601)

-java- at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

-java- at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

-java- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

-java- at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

-java- at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

-java- at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

-java- at $Proxy1.saveResource(Unknown Source)

(it is very long so I think this is enough)
Probably, hibernate xml file which is reponsible for filling the table named JIDataType with data has to be fixed too because it sends maxvalue in a way that mysql percieves it as a reserved word again

[ernestoo]

I thought 5.5 was supported as of a few versions ago, Does this help?

http://community.jaspersoft.com/questions/532505/maxvalue-table-jidatatype-mysql-55

[ismails]

thanks for replying. I read it. It will be helpfull if I can rebuilt the source.

 

[ismails]

Thanks again i solve my problem with using an upper version which is 4.5