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