crazypig Posted September 27, 2011 Share Posted September 27, 2011 Link to comment Share on other sites More sharing options...
tkavanagh Posted October 10, 2011 Share Posted October 10, 2011 You would need to do a little searching on these forums because there are users who are running under SQL Server. You have changed your settings (hibernate dialect, etc). But you will also need to create a js-create.ddl script that is converted to SQL Server. The js-create.ddl script is located here:buildomatic/install_resources/sql/<dbType>/js-create.ddl Under the Community version we support PostgreSQL and MySQL (but not yet mysql 5.5 due to 5.5 deprecating some syntax). Under the Enterprise Commercial version we support Oracle, SQL Server, and DB2. Link to comment Share on other sites More sharing options...
h.aulakh89 Posted November 4, 2015 Share Posted November 4, 2015 Add Property in js.quartz.base.propertiesOpen js.quartz.base.properties from following path:· C:jasperreports-server-6.0.1apache-tomcatwebappsjasperserver-proWEB-INF· #You can tell quartz what SQL to use by adding this property org.quartz.jobStore.selectWithLockSQL in the file like this: org.quartz.jobStore.selectWithLockSQL = SELECT * FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now