js 4.0.0 to 4.2.1 upgrade, function nextval missing

[roosit]

 

I wanted to do an easy upgrade (copied the war in webapps) from 4.0.0 to 4.2.1 because nothing has been changed in the database.

I have configured a new test environment with jre-6u37, tomcat-6.0.36, postgresql-8.4-703.jdbc3.jar, mysql-connector-java-5.1.22.tar.gz and changed META-INF/context.xml and tomcat/conf/Catalina/localhost/jasperserver.xml, to link it to the same mysql database.

This new installation is complaining about the non existence of nextval function

Anybody had the same?

 

 

[roosit]

 

 

added org.hibernate.dialect.MySQLInnoDBDialect

tomcat/webapps/jasperserver/WEB-INF/js.jdbc.properties
tomcat/webapps/jasperserver/WEB-INF/hibernate.properties

[mgeise]

This resolved the issue, correct? if so, go ahead and mark it as the best answer with the check mark. Thanks for following up with your findings...this will help others!