khsam2001

i used a jasperServer vers 3.7.0 and i have creatde a report unit, i have a sql query with the temporay table like : SELECT dvi.code_dvi, .................... INTO #elisData FROM exp_exploitation exp, ------------ WHERE dvi.code_dvi = XXXXXXX where i run this report at the first there are no pb,but at the second it show me an exception, "There is already an object named '#elisData' in the database : i don t know why he did t drop this table after close connection !! !!! I use a sybase server dataBase PLEASE !! Code:com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : estimate_master at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:161) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.createQueryDataSource(EngineServiceImpl.java:761) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillQueryReport(EngineServiceImpl.java:779) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:728) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:385) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:871) at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:57) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:319) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:383) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:373) at com.jaspersoft.jasperserver.war.action.ViewReportAction.runReport(ViewReportAction.java:255).... at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Thread.java:619)Caused by: com.sybase.jdbc3.jdbc.SybSQLException: There is already an object named '#elisData' in the database. at com.sybase.jdbc3.tds.Tds.a(Unknown Source) at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source) at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source) at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135)... 114 more Post Edited by khsam2001 at 07/19/2010 09:36

hi i have posted in forum a script for make un sybase the database for jasperserver; here is the url : http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=51965 by

hi i post at this url a script for Sybase or/and SQLserver, if you want to use anyone!! http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=51966 by

hi i post here the database script for jasperServer, this script work well with Sybase ASE , and to test them with SQLServer. if you have this exception : [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure.] clear the conent of "js.quartz.base.properties" at : <tomcatHome>webapps/jasperserver/WEB-INF/ and insert this lignes : # This file contains only properties that don't normally change. # It gets used in the Spring bean for the Quartz scheduler. # Other properties are set by referring to settings in js.quartz.properties org.quartz.scheduler.instanceName=JasperServerScheduler org.quartz.threadPool.threadCount=2 org.quartz.threadPool.threadPriority=3 org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.MSSQLDelegate org.quartz.jobStore.misfireThreshold=180000 org.quartz.jobStore.selectWithLockSQL=SELECT * FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ? org.quartz.jobStore.class=org.springframework.scheduling.quartz.LocalDataSourceJobStore org.quartz.jobStore.dontSetNonManagedTXConnectionAutoCommitFalse=true org.quartz.jobStore.dontSetAutoCommitFalse=true good luck !!! ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- script "create tables" : /* * * date : 10/02/2009 * author : @SKH */ IF OBJECT_ID ('dbo.JIBeanDatasource') IS NOT NULL DROP TABLE dbo.JIBeanDatasource GO IF OBJECT_ID ('dbo.JIContentResource') IS NOT NULL DROP TABLE dbo.JIContentResource GO IF OBJECT_ID ('dbo.JICustomDatasourceproperty') IS NOT NULL DROP TABLE dbo.JICustomDatasourceproperty GO IF OBJECT_ID ('dbo.JIInputControlQueryColumn') IS NOT NULL DROP TABLE dbo.JIInputControlQueryColumn GO IF OBJECT_ID ('dbo.JIJNDIJdbcDatasource') IS NOT NULL DROP TABLE dbo.JIJNDIJdbcDatasource GO IF OBJECT_ID ('dbo.JIJdbcDatasource') IS NOT NULL DROP TABLE dbo.JIJdbcDatasource GO IF OBJECT_ID ('dbo.JIListOfValuesItem') IS NOT NULL DROP TABLE dbo.JIListOfValuesItem GO IF OBJECT_ID ('dbo.JILogEvent') IS NOT NULL DROP TABLE dbo.JILogEvent GO IF OBJECT_ID ('dbo.JIMondrianXMLADefinition') IS NOT NULL DROP TABLE dbo.JIMondrianXMLADefinition GO IF OBJECT_ID ('dbo.JIObjectPermission') IS NOT NULL DROP TABLE dbo.JIObjectPermission GO IF OBJECT_ID ('dbo.JIReportJobCalendarTrigger') IS NOT NULL DROP TABLE dbo.JIReportJobCalendarTrigger GO IF OBJECT_ID ('dbo.JIReportJobMailRecipient') IS NOT NULL DROP TABLE dbo.JIReportJobMailRecipient GO IF OBJECT_ID ('dbo.JIReportJobOutputFormat') IS NOT NULL DROP TABLE dbo.JIReportJobOutputFormat GO IF OBJECT_ID ('dbo.JIReportJobParameter') IS NOT NULL DROP TABLE dbo.JIReportJobParameter GO IF OBJECT_ID ('dbo.JIOlapUnit') IS NOT NULL DROP TABLE dbo.JIOlapUnit GO IF OBJECT_ID ('dbo.JIProfileAttribute') IS NOT NULL DROP TABLE dbo.JIProfileAttribute GO IF OBJECT_ID ('dbo.JIReportJobSimpleTrigger') IS NOT NULL DROP TABLE dbo.JIReportJobSimpleTrigger GO IF OBJECT_ID ('dbo.JIReportUnitInputControl') IS NOT NULL DROP TABLE dbo.JIReportUnitInputControl GO IF OBJECT_ID ('dbo.JIReportUnitResource') IS NOT NULL DROP TABLE dbo.JIReportUnitResource GO IF OBJECT_ID ('dbo.JIRepositoryCache') IS NOT NULL DROP TABLE dbo.JIRepositoryCache GO IF OBJECT_ID ('dbo.JIUserRole') IS NOT NULL DROP TABLE dbo.JIUserRole GO IF OBJECT_ID ('dbo.JIXMLAConnection') IS NOT NULL DROP TABLE dbo.JIXMLAConnection GO IF OBJECT_ID ('dbo.JICustomDatasource') IS NOT NULL DROP TABLE dbo.JICustomDatasource GO IF OBJECT_ID ('dbo.JIInputControl') IS NOT NULL DROP TABLE dbo.JIInputControl GO IF OBJECT_ID ('dbo.JIListOfValues') IS NOT NULL DROP TABLE dbo.JIListOfValues GO IF OBJECT_ID ('dbo.JIMondrianConnection') IS NOT NULL DROP TABLE dbo.JIMondrianConnection GO IF OBJECT_ID ('dbo.JIOlapClientConnection') IS NOT NULL DROP TABLE dbo.JIOlapClientConnection GO IF OBJECT_ID ('dbo.JIReportJob') IS NOT NULL DROP TABLE dbo.JIReportJob GO IF OBJECT_ID ('dbo.JIReportJobMail') IS NOT NULL DROP TABLE dbo.JIReportJobMail GO IF OBJECT_ID ('dbo.JIReportJobRepoDest') IS NOT NULL DROP TABLE dbo.JIReportJobRepoDest GO IF OBJECT_ID ('dbo.JIReportJobTrigger') IS NOT NULL DROP TABLE dbo.JIReportJobTrigger GO IF OBJECT_ID ('dbo.JIReportUnit') IS NOT NULL DROP TABLE dbo.JIReportUnit GO IF OBJECT_ID ('dbo.JIRole') IS NOT NULL DROP TABLE dbo.JIRole GO IF OBJECT_ID ('dbo.JIUser') IS NOT NULL DROP TABLE dbo.JIUser GO IF OBJECT_ID ('dbo.JIDataType') IS NOT NULL DROP TABLE dbo.JIDataType GO IF OBJECT_ID ('dbo.JIFileResource') IS NOT NULL DROP TABLE dbo.JIFileResource GO IF OBJECT_ID ('dbo.JIQuery') IS NOT NULL DROP TABLE dbo.JIQuery GO IF OBJECT_ID ('dbo.JIResource') IS NOT NULL DROP TABLE dbo.JIResource GO IF OBJECT_ID ('dbo.JIResourceFolder') IS NOT NULL DROP TABLE dbo.JIResourceFolder GO CREATE TABLE JIBeanDatasource ( id INT NOT NULL, beanName VARCHAR(100) NOT NULL, beanMethod VARCHAR(100) NULL ) ALTER TABLE JIBeanDatasource ADD CONSTRAINT pk_JIBeanDatasource PRIMARY KEY (id) CREATE TABLE JIContentResource ( id INT NOT NULL, data IMAGE NULL, file_type VARCHAR(20) NULL ) ALTER TABLE JIContentResource ADD CONSTRAINT pk_JIContentResource PRIMARY KEY (id) CREATE TABLE JICustomDatasource ( id INT NOT NULL, serviceClass VARCHAR(250) NOT NULL ) ALTER TABLE JICustomDatasource ADD CONSTRAINT pk_JICustomDatasource PRIMARY KEY (id) CREATE TABLE JICustomDatasourceproperty ( ds_id INT NOT NULL, value TEXT NULL, name VARCHAR(100) NOT NULL ) ALTER TABLE JICustomDatasourceproperty ADD CONSTRAINT pk_JICustomDatasourceproperty PRIMARY KEY (ds_id, name) CREATE TABLE JIDataType ( id INT NOT NULL, type TINYINT NULL, maxLength INT NULL, decimals INT NULL, regularExpr VARCHAR(255) NULL, minValue IMAGE NULL, maxValue IMAGE NULL, strictMin BIT , strictMax BIT ) ALTER TABLE JIDataType ADD CONSTRAINT pk_JIDataType PRIMARY KEY (id) CREATE TABLE JIFileResource ( id INT NOT NULL, data IMAGE NULL, file_type VARCHAR(20) NULL, reference INT NULL ) ALTER TABLE JIFileResource ADD CONSTRAINT pk_JIFileResource PRIMARY KEY (id) CREATE TABLE JIInputControl ( id INT NOT NULL, type TINYINT NULL, mandatory BIT , readOnly BIT , visible BIT , data_type INT NULL, list_of_values INT NULL, list_query INT NULL, query_value_column VARCHAR(200) NULL, defaultValue IMAGE NULL ) ALTER TABLE JIInputControl ADD CONSTRAINT pk_JIInputControl PRIMARY KEY (id) CREATE TABLE JIInputControlQueryColumn ( input_control_id INT NOT NULL, query_column VARCHAR(200) NOT NULL, column_index INT NOT NULL ) ALTER TABLE JIInputControlQueryColumn ADD CONSTRAINT pk_JIInputControlQueryColumn PRIMARY KEY (input_control_id, column_index) CREATE TABLE JIJNDIJdbcDatasource ( id INT NOT NULL, jndiName VARCHAR(100) NOT NULL, timezone VARCHAR(100) NULL ) ALTER TABLE JIJNDIJdbcDatasource ADD CONSTRAINT pk_JIJNDIJdbcDatasource PRIMARY KEY (id) CREATE TABLE JIJdbcDatasource ( id INT NOT NULL, driver VARCHAR(100) NOT NULL, password VARCHAR(100) NULL, connectionUrl TEXT NULL, username VARCHAR(100) NULL, timezone VARCHAR(100) NULL ) ALTER TABLE JIJdbcDatasource ADD CONSTRAINT pk_JIJdbcDatasource PRIMARY KEY (id) CREATE TABLE JIListOfValues ( id INT NOT NULL ) ALTER TABLE JIListOfValues ADD CONSTRAINT pk_JIListOfValues PRIMARY KEY (id) CREATE TABLE JIListOfValuesItem ( id INT NOT NULL, label VARCHAR(255) NULL, value IMAGE NULL, idx INT NOT NULL ) ALTER TABLE JIListOfValuesItem ADD CONSTRAINT pk_JIListOfValuesItem PRIMARY KEY (id,idx) CREATE TABLE JILogEvent ( id INT IDENTITY NOT NULL, occurrence_date DATETIME NOT NULL, event_type TINYINT NOT NULL, username VARCHAR(100) NULL, component VARCHAR(100) NULL, message VARCHAR(250) NOT NULL, resource_uri VARCHAR(250) NULL, event_text IMAGE NULL, event_data IMAGE NULL, event_state TINYINT NULL ) ALTER TABLE JILogEvent ADD CONSTRAINT pk_JILogEvent PRIMARY KEY (id) CREATE TABLE JIMondrianConnection ( id INT NOT NULL, reportDataSource INT NULL, mondrianSchema INT NULL ) ALTER TABLE JIMondrianConnection ADD CONSTRAINT pk_JIMondrianConnection PRIMARY KEY (id) CREATE TABLE JIMondrianXMLADefinition ( id INT NOT NULL, catalog VARCHAR(100) NOT NULL, mondrianConnection INT NULL ) ALTER TABLE JIMondrianXMLADefinition ADD CONSTRAINT pk_JIMondrianXMLADefinition PRIMARY KEY (id) CREATE TABLE JIObjectPermission ( id INT IDENTITY NOT NULL, uri VARCHAR(255) NOT NULL, recipientobjectclass VARCHAR(100) NULL, recipientobjectid INT NULL, permissionMask INT NOT NULL ) ALTER TABLE JIObjectPermission ADD CONSTRAINT pk_JIObjectPermission PRIMARY KEY (id) CREATE TABLE JIOlapClientConnection ( id INT NOT NULL ) ALTER TABLE JIOlapClientConnection ADD CONSTRAINT pk_JIOlapClientConnection PRIMARY KEY (id) CREATE TABLE JIOlapUnit ( id INT NOT NULL, olapClientConnection INT NULL, mdx_query TEXT NOT NULL, view_options IMAGE NULL ) ALTER TABLE JIOlapUnit ADD CONSTRAINT pk_JIOlapUnit PRIMARY KEY (id) CREATE TABLE JIProfileAttribute ( id INT IDENTITY NOT NULL, attrName VARCHAR(255) NOT NULL, attrValue VARCHAR(255) NOT NULL, principalobjectclass VARCHAR(255) NOT NULL, principalobjectid INT NOT NULL ) ALTER TABLE JIProfileAttribute ADD CONSTRAINT pk_JIProfileAttribute PRIMARY KEY (id) CREATE TABLE JIQuery ( id INT NOT NULL, dataSource INT NULL, query_language VARCHAR(40) NOT NULL, sql_query TEXT NOT NULL ) ALTER TABLE JIQuery ADD CONSTRAINT pk_JIQuery PRIMARY KEY (id) CREATE TABLE JIReportJob ( id INT IDENTITY NOT NULL, version INT NOT NULL, username VARCHAR(100) NOT NULL, label VARCHAR(100) NOT NULL, description TEXT NULL, report_unit_uri VARCHAR(200) NOT NULL, job_trigger INT NOT NULL, base_output_name VARCHAR(100) NOT NULL, output_locale VARCHAR(20) NULL, content_destination INT NULL, mail_notification INT NULL ) ALTER TABLE JIReportJob ADD CONSTRAINT pk_JIReportJob PRIMARY KEY (id) CREATE TABLE JIReportJobCalendarTrigger ( id INT NOT NULL, minutes VARCHAR(200) NOT NULL, hours VARCHAR(80) NOT NULL, days_type TINYINT NOT NULL, week_days VARCHAR(20) NULL, month_days VARCHAR(100) NULL, months VARCHAR(40) NOT NULL ) ALTER TABLE JIReportJobCalendarTrigger ADD CONSTRAINT pk_JIReportJobCalendarTrigger PRIMARY KEY (id) CREATE TABLE JIReportJobMail ( id INT IDENTITY NOT NULL, version INT NOT NULL, subject VARCHAR(100) NOT NULL, message TEXT NOT NULL, send_type TINYINT NOT NULL, skip_empty BIT NOT NULL ) ALTER TABLE JIReportJobMail ADD CONSTRAINT pk_JIReportJobMail PRIMARY KEY (id) CREATE TABLE JIReportJobMailRecipient ( destination_id INT NOT NULL, recipient_type TINYINT NOT NULL, address VARCHAR(100) NOT NULL, recipient_idx INT NOT NULL ) ALTER TABLE JIReportJobMailRecipient ADD CONSTRAINT pk_JIReportJobMailRecipient PRIMARY KEY (destination_id, recipient_idx) CREATE TABLE JIReportJobOutputFormat ( report_job_id INT NOT NULL, output_format TINYINT NOT NULL ) ALTER TABLE JIReportJobOutputFormat ADD CONSTRAINT pk_JIReportJobOutputFormat PRIMARY KEY (report_job_id, output_format) CREATE TABLE JIReportJobParameter ( job_id INT NOT NULL, parameter_value IMAGE NULL, parameter_name VARCHAR(100) NOT NULL ) ALTER TABLE JIReportJobParameter ADD CONSTRAINT pk_JIReportJobParameter PRIMARY KEY (job_id, parameter_name) CREATE TABLE JIReportJobRepoDest ( id INT IDENTITY NOT NULL, version INT NOT NULL, folder_uri VARCHAR(200) NOT NULL, sequential_filenames BIT NOT NULL, overwrite_files BIT NOT NULL, output_description VARCHAR(100) NULL, timestamp_pattern VARCHAR(250) NULL ) ALTER TABLE JIReportJobRepoDest ADD CONSTRAINT pk_JIReportJobRepoDest PRIMARY KEY (id) CREATE TABLE JIReportJobSimpleTrigger ( id INT NOT NULL, occurrence_count INT NOT NULL, recurrence_interval INT NULL, recurrence_interval_unit TINYINT NULL ) ALTER TABLE JIReportJobSimpleTrigger ADD CONSTRAINT pk_JIReportJobSimpleTrigger PRIMARY KEY (id) CREATE TABLE JIReportJobTrigger ( id INT IDENTITY NOT NULL, version INT NOT NULL, timezone VARCHAR(40) NULL, start_type TINYINT NOT NULL, start_date DATETIME NULL, end_date DATETIME NULL ) ALTER TABLE JIReportJobTrigger ADD CONSTRAINT pk_JIReportJobTrigger PRIMARY KEY (id) CREATE TABLE JIReportUnit ( id INT NOT NULL, reportDataSource INT NULL, query INT NULL, mainReport INT NULL, controlrenderer VARCHAR(100) NULL, reportrenderer VARCHAR(100) NULL, promptcontrols BIT , controlslayout TINYINT NULL ) ALTER TABLE JIReportUnit ADD CONSTRAINT pk_JIReportUnit PRIMARY KEY (id) CREATE TABLE JIReportUnitInputControl ( report_unit_id INT NOT NULL, input_control_id INT NOT NULL, control_index INT NOT NULL ) ALTER TABLE JIReportUnitInputControl ADD CONSTRAINT pk_JIReportUnitInputControl PRIMARY KEY (report_unit_id, control_index) CREATE TABLE JIReportUnitResource ( report_unit_id INT NOT NULL, resource_id INT NOT NULL, resource_index INT NOT NULL ) ALTER TABLE JIReportUnitResource ADD CONSTRAINT pk_JIReportUnitResource PRIMARY KEY (report_unit_id, resource_index) CREATE TABLE JIRepositoryCache ( id INT IDENTITY NOT NULL, uri VARCHAR(200) NOT NULL, cache_name VARCHAR(20) NOT NULL, data IMAGE NULL, version INT NOT NULL, version_date DATETIME NOT NULL, item_reference INT NULL ) ALTER TABLE JIRepositoryCache ADD CONSTRAINT pk_JIRepositoryCache PRIMARY KEY (id) CREATE TABLE JIResource ( id INT IDENTITY NOT NULL, version INT NOT NULL, name VARCHAR(100) NOT NULL, parent_folder INT NOT NULL, childrenFolder INT NULL, label VARCHAR(100) NOT NULL, description VARCHAR(250) NULL, creation_date DATETIME NOT NULL ) ALTER TABLE JIResource ADD CONSTRAINT pk_JIResource PRIMARY KEY (id) CREATE TABLE JIResourceFolder ( id INT IDENTITY NOT NULL, version INT NOT NULL, uri VARCHAR(250) NOT NULL, hidden BIT , name VARCHAR(100) NOT NULL, label VARCHAR(100) NOT NULL, description VARCHAR(250) NULL, parent_folder INT NULL, creation_date DATETIME NOT NULL ) ALTER TABLE JIResourceFolder ADD CONSTRAINT pk_JIResourceFolder PRIMARY KEY (id) CREATE TABLE JIUserRole ( roleId INT NOT NULL, userId INT NOT NULL ) ALTER TABLE JIUserRole ADD CONSTRAINT pk_JIUserRole PRIMARY KEY (userId, roleId) CREATE TABLE JIXMLAConnection ( id INT NOT NULL, catalog VARCHAR(100) NOT NULL, username VARCHAR(100) NOT NULL, password VARCHAR(100) NOT NULL, datasource VARCHAR(100) NOT NULL, uri VARCHAR(100) NOT NULL ) ALTER TABLE JIXMLAConnection ADD CONSTRAINT pk_JIXMLAConnection PRIMARY KEY (id) CREATE INDEX FK674BF34A8BF376D ON JIBeanDatasource (id ) CREATE INDEX FKE466FC68A8BF376D ON JIContentResource (id ) CREATE INDEX FK2BBCEDF5A8BF376D ON JICustomDatasource (id ) CREATE INDEX FKB8A66AEA858A89D1 ON JICustomDatasourceproperty (ds_id ) CREATE INDEX FK533BCC63A8BF376D ON JIDataType (id ) CREATE INDEX FKF75B58895A0C539 ON JIFileResource (reference ) CREATE INDEX FKF75B5889A8BF376D ON JIFileResource (id ) CREATE INDEX FKCAC6A512120E06F7 ON JIInputControl (data_type ) CREATE INDEX FKCAC6A51262A86F04 ON JIInputControl (list_of_values ) CREATE INDEX FKCAC6A512A8BF376D ON JIInputControl (id ) CREATE INDEX FKCAC6A512B37DB6EB ON JIInputControl (list_query ) CREATE INDEX FKE436A5CCE7922149 ON JIInputControlQueryColumn (input_control_id ) CREATE INDEX FKC8BDFCBFA8BF376D ON JIJdbcDatasource (id ) CREATE INDEX FK7F9DA248A8BF376D ON JIJNDIJdbcDatasource (id ) CREATE INDEX FK4E86A776A8BF376D ON JIListOfValues (id ) CREATE INDEX FKD37CEBA993F0E1F6 ON JIListOfValuesItem (id ) CREATE INDEX FK4FF53B191D51BFAD ON JIMondrianConnection (id ) CREATE INDEX FK4FF53B19324CFECB ON JIMondrianConnection (reportDataSource ) CREATE INDEX FK4FF53B19C495A60B ON JIMondrianConnection (mondrianSchema ) CREATE INDEX FK313B2AB8A8BF376D ON JIMondrianXMLADefinition (id ) CREATE INDEX FK313B2AB8DC098B1 ON JIMondrianXMLADefinition (mondrianConnection ) CREATE INDEX FK3CA3B7D4A8BF376D ON JIOlapClientConnection (id ) CREATE INDEX FKF034DCCF8F542247 ON JIOlapUnit (olapClientConnection ) CREATE INDEX FKF034DCCFA8BF376D ON JIOlapUnit (id ) CREATE INDEX FKCBCB0EC92B329A97 ON JIQuery (dataSource ) CREATE INDEX FKCBCB0EC9A8BF376D ON JIQuery (id ) CREATE INDEX FK156F5F6A74D2696E ON JIReportJob (job_trigger ) CREATE INDEX FK156F5F6A9EEC902C ON JIReportJob (content_destination ) CREATE INDEX FK156F5F6AE4D73E35 ON JIReportJob (mail_notification ) CREATE INDEX FKC374C7D0D2B2EB53 ON JIReportJobCalendarTrigger (id ) CREATE INDEX FKBB6DB6D880001AAE ON JIReportJobMailRecipient (destination_id ) CREATE INDEX FKB42A5CE2C3389A8 ON JIReportJobOutputFormat (report_job_id ) CREATE INDEX FKEAC52B5F2EC643D ON JIReportJobParameter (job_id ) CREATE INDEX FKB9337C5CD2B2EB53 ON JIReportJobSimpleTrigger (id ) CREATE INDEX FK98818B77324CFECB ON JIReportUnit (reportDataSource ) CREATE INDEX FK98818B778C8DF21B ON JIReportUnit (mainReport ) CREATE INDEX FK98818B778FDA11CC ON JIReportUnit (query ) CREATE INDEX FK98818B77A8BF376D ON JIReportUnit (id ) CREATE INDEX FK5FBE934AA6A48880 ON JIReportUnitInputControl (report_unit_id ) CREATE INDEX FK5FBE934AE7922149 ON JIReportUnitInputControl (input_control_id ) CREATE INDEX FK8B1C4CA5865B10DA ON JIReportUnitResource (resource_id ) CREATE INDEX FK8B1C4CA5A6A48880 ON JIReportUnitResource (report_unit_id ) CREATE INDEX FKE7338B19E7C5A6 ON JIRepositoryCache (item_reference ) CREATE UNIQUE INDEX uri ON JIRepositoryCache (uri , cache_name ) CREATE INDEX FKD444826DA08E2155 ON JIResource (parent_folder ) CREATE INDEX FKD444826DA58002DF ON JIResource (childrenFolder ) CREATE UNIQUE INDEX name ON JIResource (name , parent_folder ) CREATE INDEX FK7F24453BA08E2155 ON JIResourceFolder (parent_folder ) CREATE UNIQUE INDEX uri ON JIResourceFolder (uri ) CREATE INDEX FKD8B5C1403C31045 ON JIUserRole (roleId ) CREATE INDEX FKD8B5C14091865AF ON JIUserRole (userId ) ALTER TABLE JIBeanDatasource ADD CONSTRAINT FK674BF34A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIContentResource ADD CONSTRAINT FKE466FC68A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JICustomDatasource ADD CONSTRAINT FK2BBCEDF5A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JICustomDatasourceproperty ADD CONSTRAINT FKB8A66AEA858A89D1 FOREIGN KEY (ds_id) REFERENCES JICustomDatasource (id) ALTER TABLE JIDataType ADD CONSTRAINT FK533BCC63A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIFileResource ADD CONSTRAINT FKF75B58895A0C539 FOREIGN KEY (reference) REFERENCES JIFileResource (id) ALTER TABLE JIFileResource ADD CONSTRAINT FKF75B5889A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIInputControl ADD CONSTRAINT FKCAC6A512120E06F7 FOREIGN KEY (data_type) REFERENCES JIDataType (id) ALTER TABLE JIInputControl ADD CONSTRAINT FKCAC6A512B37DB6EB FOREIGN KEY (list_query) REFERENCES JIQuery (id) ALTER TABLE JIInputControl ADD CONSTRAINT FKCAC6A51262A86F04 FOREIGN KEY (list_of_values) REFERENCES JIListOfValues (id) ALTER TABLE JIInputControl ADD CONSTRAINT FKCAC6A512A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIInputControlQueryColumn ADD CONSTRAINT FKE436A5CCE7922149 FOREIGN KEY (input_control_id) REFERENCES JIInputControl (id) ALTER TABLE JIJNDIJdbcDatasource ADD CONSTRAINT FK7F9DA248A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIJdbcDatasource ADD CONSTRAINT FKC8BDFCBFA8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIListOfValues ADD CONSTRAINT FK4E86A776A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIListOfValuesItem ADD CONSTRAINT FKD37CEBA993F0E1F6 FOREIGN KEY (id) REFERENCES JIListOfValues (id) ALTER TABLE JIMondrianConnection ADD CONSTRAINT FK4FF53B19C495A60B FOREIGN KEY (mondrianSchema) REFERENCES JIFileResource (id) ALTER TABLE JIMondrianConnection ADD CONSTRAINT FK4FF53B19324CFECB FOREIGN KEY (reportDataSource) REFERENCES JIResource (id) ALTER TABLE JIMondrianConnection ADD CONSTRAINT FK4FF53B191D51BFAD FOREIGN KEY (id) REFERENCES JIOlapClientConnection (id) ALTER TABLE JIMondrianXMLADefinition ADD CONSTRAINT FK313B2AB8DC098B1 FOREIGN KEY (mondrianConnection) REFERENCES JIMondrianConnection (id) ALTER TABLE JIMondrianXMLADefinition ADD CONSTRAINT FK313B2AB8A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIOlapClientConnection ADD CONSTRAINT FK3CA3B7D4A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIOlapUnit ADD CONSTRAINT FKF034DCCF8F542247 FOREIGN KEY (olapClientConnection) REFERENCES JIOlapClientConnection (id) ALTER TABLE JIOlapUnit ADD CONSTRAINT FKF034DCCFA8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIQuery ADD CONSTRAINT FKCBCB0EC92B329A97 FOREIGN KEY (dataSource) REFERENCES JIResource (id) ALTER TABLE JIQuery ADD CONSTRAINT FKCBCB0EC9A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIReportJob ADD CONSTRAINT FK156F5F6AE4D73E35 FOREIGN KEY (mail_notification) REFERENCES JIReportJobMail (id) ALTER TABLE JIReportJob ADD CONSTRAINT FK156F5F6A9EEC902C FOREIGN KEY (content_destination) REFERENCES JIReportJobRepoDest (id) ALTER TABLE JIReportJob ADD CONSTRAINT FK156F5F6A74D2696E FOREIGN KEY (job_trigger) REFERENCES JIReportJobTrigger (id) ALTER TABLE JIReportJobCalendarTrigger ADD CONSTRAINT FKC374C7D0D2B2EB53 FOREIGN KEY (id) REFERENCES JIReportJobTrigger (id) ALTER TABLE JIReportJobMailRecipient ADD CONSTRAINT FKBB6DB6D880001AAE FOREIGN KEY (destination_id) REFERENCES JIReportJobMail (id) ALTER TABLE JIReportJobOutputFormat ADD CONSTRAINT FKB42A5CE2C3389A8 FOREIGN KEY (report_job_id) REFERENCES JIReportJob (id) ALTER TABLE JIReportJobParameter ADD CONSTRAINT FKEAC52B5F2EC643D FOREIGN KEY (job_id) REFERENCES JIReportJob (id) ALTER TABLE JIReportJobSimpleTrigger ADD CONSTRAINT FKB9337C5CD2B2EB53 FOREIGN KEY (id) REFERENCES JIReportJobTrigger (id) ALTER TABLE JIReportUnit ADD CONSTRAINT FK98818B778FDA11CC FOREIGN KEY (query) REFERENCES JIQuery (id) ALTER TABLE JIReportUnit ADD CONSTRAINT FK98818B77324CFECB FOREIGN KEY (reportDataSource) REFERENCES JIResource (id) ALTER TABLE JIReportUnit ADD CONSTRAINT FK98818B778C8DF21B FOREIGN KEY (mainReport) REFERENCES JIFileResource (id) ALTER TABLE JIReportUnit ADD CONSTRAINT FK98818B77A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIReportUnitInputControl ADD CONSTRAINT FK5FBE934AE7922149 FOREIGN KEY (input_control_id) REFERENCES JIInputControl (id) ALTER TABLE JIReportUnitInputControl ADD CONSTRAINT FK5FBE934AA6A48880 FOREIGN KEY (report_unit_id) REFERENCES JIReportUnit (id) ALTER TABLE JIReportUnitResource ADD CONSTRAINT FK8B1C4CA5865B10DA FOREIGN KEY (resource_id) REFERENCES JIFileResource (id) ALTER TABLE JIReportUnitResource ADD CONSTRAINT FK8B1C4CA5A6A48880 FOREIGN KEY (report_unit_id) REFERENCES JIReportUnit (id) ALTER TABLE JIRepositoryCache ADD CONSTRAINT FKE7338B19E7C5A6 FOREIGN KEY (item_reference) REFERENCES JIRepositoryCache (id) ALTER TABLE JIResource ADD CONSTRAINT FKD444826DA08E2155 FOREIGN KEY (parent_folder) REFERENCES JIResourceFolder (id) ALTER TABLE JIResource ADD CONSTRAINT FKD444826DA58002DF FOREIGN KEY (childrenFolder) REFERENCES JIResourceFolder (id) ALTER TABLE JIResourceFolder ADD CONSTRAINT FK7F24453BA08E2155 FOREIGN KEY (parent_folder) REFERENCES JIResourceFolder (id) ALTER TABLE JIXMLAConnection ADD CONSTRAINT FK94C688A71D51BFAD FOREIGN KEY (id) REFERENCES JIOlapClientConnection (id) CREATE TABLE JIRole ( id INT IDENTITY NOT NULL, rolename VARCHAR(100) NOT NULL unique, externallyDefined BIT ) ALTER TABLE JIRole ADD CONSTRAINT pk_JIRole PRIMARY KEY (id) CREATE TABLE JIUser ( id INT IDENTITY NOT NULL, username VARCHAR(100) NOT NULL unique, fullname VARCHAR(100) NOT NULL, emailAddress VARCHAR(100) NULL, password VARCHAR(100) NULL, externallyDefined BIT , enabled BIT , previousPasswordChangeTime DATETIME NULL ) ALTER TABLE JIUser ADD CONSTRAINT pk_JIUser PRIMARY KEY (id) CREATE UNIQUE INDEX rolename ON JIRole (rolename ) CREATE UNIQUE INDEX username ON JIUser (username ) ALTER TABLE JIUserRole ADD CONSTRAINT FKD8B5C14091865AF FOREIGN KEY (userId) REFERENCES JIUser (id) ALTER TABLE JIUserRole ADD CONSTRAINT FKD8B5C1403C31045 FOREIGN KEY (roleId) REFERENCES JIRole (id) /*==============================================================================*/ /* End of script. */ /*==============================================================================*/ script Quartz Tables : /*==============================================================================================*/ /* Quartz database tables creation script for Sybase ASE 12.5 */ /* Written by Pertti Laiho (email: pertti.laiho@deio.net), 9th May 2003 */ /* */ /* Compatible with Quartz version 1.1.2 */ /* */ /* Sybase ASE works ok with the MSSQL delegate class. That means in your Quartz properties */ /* file, you'll need to set: */ /* org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.MSSQLDelegate */ /*==============================================================================================*/ use jasperserver go /*==============================================================================*/ /* Clear all tables: */ /*==============================================================================*/ IF OBJECT_ID('QRTZ_JOB_LISTENERS') IS NOT NULL delete from QRTZ_JOB_LISTENERS go IF OBJECT_ID('QRTZ_TRIGGER_LISTENERS') IS NOT NULL delete from QRTZ_TRIGGER_LISTENERS go IF OBJECT_ID('QRTZ_FIRED_TRIGGERS') IS NOT NULL delete from QRTZ_FIRED_TRIGGERS go IF OBJECT_ID('QRTZ_PAUSED_TRIGGER_GRPS') IS NOT NULL delete from QRTZ_PAUSED_TRIGGER_GRPS go IF OBJECT_ID('QRTZ_SCHEDULER_STATE') IS NOT NULL delete from QRTZ_SCHEDULER_STATE go IF OBJECT_ID('QRTZ_LOCKS') IS NOT NULL delete from QRTZ_LOCKS go IF OBJECT_ID('QRTZ_SIMPLE_TRIGGERS') IS NOT NULL delete from QRTZ_SIMPLE_TRIGGERS go IF OBJECT_ID('QRTZ_CRON_TRIGGERS') IS NOT NULL delete from QRTZ_CRON_TRIGGERS go IF OBJECT_ID('QRTZ_BLOB_TRIGGERS') IS NOT NULL delete from QRTZ_BLOB_TRIGGERS go IF OBJECT_ID('QRTZ_TRIGGERS') IS NOT NULL delete from QRTZ_TRIGGERS go IF OBJECT_ID('QRTZ_JOB_DETAILS') IS NOT NULL delete from QRTZ_JOB_DETAILS go IF OBJECT_ID('QRTZ_CALENDARS') IS NOT NULL delete from QRTZ_CALENDARS go /*==============================================================================*/ /* Drop constraints: */ /*==============================================================================*/ alter table QRTZ_JOB_LISTENERS drop constraint FK_job_listeners_job_details go alter table QRTZ_TRIGGERS drop constraint FK_triggers_job_details go alter table QRTZ_CRON_TRIGGERS drop constraint FK_cron_triggers_triggers go alter table QRTZ_SIMPLE_TRIGGERS drop constraint FK_simple_triggers_triggers go alter table QRTZ_TRIGGER_LISTENERS drop constraint FK_trigger_listeners_triggers go alter table QRTZ_BLOB_TRIGGERS drop constraint FK_blob_triggers_triggers go /*==============================================================================*/ /* Drop tables: */ /*==============================================================================*/ drop table QRTZ_JOB_LISTENERS go drop table QRTZ_TRIGGER_LISTENERS go drop table QRTZ_FIRED_TRIGGERS go drop table QRTZ_PAUSED_TRIGGER_GRPS go drop table QRTZ_SCHEDULER_STATE go drop table QRTZ_LOCKS go drop table QRTZ_SIMPLE_TRIGGERS go drop table QRTZ_CRON_TRIGGERS go drop table QRTZ_BLOB_TRIGGERS go drop table QRTZ_TRIGGERS go drop table QRTZ_JOB_DETAILS go drop table QRTZ_CALENDARS go /*==============================================================================*/ /* Create tables: */ /*==============================================================================*/ create table QRTZ_CALENDARS ( CALENDAR_NAME varchar(80) not null, CALENDAR image not null ) go create table QRTZ_CRON_TRIGGERS ( TRIGGER_NAME varchar(80) not null, TRIGGER_GROUP varchar(80) not null, CRON_EXPRESSION varchar(120) not null, TIME_ZONE_ID varchar(80) null ) go create table QRTZ_PAUSED_TRIGGER_GRPS ( TRIGGER_GROUP varchar(80) not null ) go create table QRTZ_FIRED_TRIGGERS( ENTRY_ID varchar(95) not null, TRIGGER_NAME varchar(80) not null, TRIGGER_GROUP varchar(80) not null, IS_VOLATILE bit not null, INSTANCE_NAME varchar(80) not null, FIRED_TIME numeric(13,0) not null, STATE varchar(16) not null, JOB_NAME varchar(80) null, JOB_GROUP varchar(80) null, IS_STATEFUL bit not null, REQUESTS_RECOVERY bit not null ) go create table QRTZ_SCHEDULER_STATE ( INSTANCE_NAME varchar(80) not null, LAST_CHECKIN_TIME numeric(13,0) not null, CHECKIN_INTERVAL numeric(13,0) not null, RECOVERER VARCHAR(80) NULL ) go create table QRTZ_LOCKS ( LOCK_NAME varchar(40) not null ) go insert into QRTZ_LOCKS values('TRIGGER_ACCESS') go insert into QRTZ_LOCKS values('JOB_ACCESS') go insert into QRTZ_LOCKS values('CALENDAR_ACCESS') go insert into QRTZ_LOCKS values('STATE_ACCESS') go INSERT INTO QRTZ_LOCKS values('MISFIRE_ACCESS') go create table QRTZ_JOB_DETAILS ( JOB_NAME varchar(80) not null, JOB_GROUP varchar(80) not null, DESCRIPTION varchar(120) null, JOB_CLASS_NAME varchar(128) not null, IS_DURABLE bit not null, IS_VOLATILE bit not null, IS_STATEFUL bit not null, REQUESTS_RECOVERY bit not null, JOB_DATA image null ) go create table QRTZ_JOB_LISTENERS ( JOB_NAME varchar(80) not null, JOB_GROUP varchar(80) not null, JOB_LISTENER varchar(80) not null ) go create table QRTZ_SIMPLE_TRIGGERS ( TRIGGER_NAME varchar(80) not null, TRIGGER_GROUP varchar(80) not null, REPEAT_COUNT numeric(13,0) not null, REPEAT_INTERVAL numeric(13,0) not null, TIMES_TRIGGERED numeric(13,0) not null ) go create table QRTZ_BLOB_TRIGGERS ( TRIGGER_NAME varchar(80) not null, TRIGGER_GROUP varchar(80) not null, BLOB_DATA image null ) go create table QRTZ_TRIGGER_LISTENERS ( TRIGGER_NAME varchar(80) not null, TRIGGER_GROUP varchar(80) not null, TRIGGER_LISTENER varchar(80) not null ) go create table QRTZ_TRIGGERS ( TRIGGER_NAME varchar(80) not null, TRIGGER_GROUP varchar(80) not null, JOB_NAME varchar(80) not null, JOB_GROUP varchar(80) not null, IS_VOLATILE bit not null, DESCRIPTION varchar(120) null, NEXT_FIRE_TIME numeric(13,0) null, PREV_FIRE_TIME numeric(13,0) null, TRIGGER_STATE varchar(16) not null, TRIGGER_TYPE varchar(8) not null, START_TIME numeric(13,0) not null, END_TIME numeric(13,0) null, CALENDAR_NAME varchar(80) null, MISFIRE_INSTR smallint null, JOB_DATA image null ) go /*==============================================================================*/ /* Create primary key constraints: */ /*==============================================================================*/ alter table QRTZ_CALENDARS add constraint PK_qrtz_calendars primary key clustered (CALENDAR_NAME) go alter table QRTZ_CRON_TRIGGERS add constraint PK_qrtz_cron_triggers primary key clustered (TRIGGER_NAME, TRIGGER_GROUP) go alter table QRTZ_FIRED_TRIGGERS add constraint PK_qrtz_fired_triggers primary key clustered (ENTRY_ID) go alter table QRTZ_PAUSED_TRIGGER_GRPS add constraint PK_qrtz_paused_trigger_grps primary key clustered (TRIGGER_GROUP) go alter table QRTZ_SCHEDULER_STATE add constraint PK_qrtz_scheduler_state primary key clustered (INSTANCE_NAME) go alter table QRTZ_LOCKS add constraint PK_qrtz_locks primary key clustered (LOCK_NAME) go alter table QRTZ_JOB_DETAILS add constraint PK_qrtz_job_details primary key clustered (JOB_NAME, JOB_GROUP) go alter table QRTZ_JOB_LISTENERS add constraint PK_qrtz_job_listeners primary key clustered (JOB_NAME, JOB_GROUP, JOB_LISTENER) go alter table QRTZ_SIMPLE_TRIGGERS add constraint PK_qrtz_simple_triggers primary key clustered (TRIGGER_NAME, TRIGGER_GROUP) go alter table QRTZ_TRIGGER_LISTENERS add constraint PK_qrtz_trigger_listeners primary key clustered (TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_LISTENER) go alter table QRTZ_TRIGGERS add constraint PK_qrtz_triggers primary key clustered (TRIGGER_NAME, TRIGGER_GROUP) go alter table QRTZ_BLOB_TRIGGERS add constraint PK_qrtz_blob_triggers primary key clustered (TRIGGER_NAME, TRIGGER_GROUP) go /*==============================================================================*/ /* Create foreign key constraints: */ /*==============================================================================*/ alter table QRTZ_CRON_TRIGGERS add constraint FK_cron_triggers_triggers foreign key (TRIGGER_NAME,TRIGGER_GROUP) references QRTZ_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP) go alter table QRTZ_JOB_LISTENERS add constraint FK_job_listeners_job_details foreign key (JOB_NAME,JOB_GROUP) references QRTZ_JOB_DETAILS (JOB_NAME,JOB_GROUP) go alter table QRTZ_SIMPLE_TRIGGERS add constraint FK_simple_triggers_triggers foreign key (TRIGGER_NAME,TRIGGER_GROUP) references QRTZ_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP) go alter table QRTZ_TRIGGER_LISTENERS add constraint FK_trigger_listeners_triggers foreign key (TRIGGER_NAME,TRIGGER_GROUP) references QRTZ_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP) go alter table QRTZ_TRIGGERS add constraint FK_triggers_job_details foreign key (JOB_NAME,JOB_GROUP) references QRTZ_JOB_DETAILS (JOB_NAME,JOB_GROUP) go alter table QRTZ_BLOB_TRIGGERS add constraint FK_blob_triggers_triggers foreign key (TRIGGER_NAME,TRIGGER_GROUP) references QRTZ_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP) go /*==============================================================================*/ /* End of script. */ /*==============================================================================*/ script insert Role : /* * * date : 06/02/2009 * author : @skh */ IF OBJECT_ID('JIRole') IS NOT NULL delete from JIRole go INSERT INTO JIRole (rolename,externallyDefined) VALUES ("ROLE_USER",0) INSERT INTO JIRole (rolename,externallyDefined) VALUES ("ROLE_ADMINISTRATOR",0) INSERT INTO JIRole (rolename,externallyDefined) VALUES ("ROLE_ANONYMOUS",0) INSERT INTO JIRole (rolename,externallyDefined) VALUES ("ROLE_PORTLET",0) IF OBJECT_ID('JIUser') IS NOT NULL delete from JIUser go INSERT INTO JIUser (username, fullname, emailAddress, password, externallyDefined, enabled ) VALUES ("anonymoususer","Anonymous User",NULL,"",0,1) INSERT INTO JIUserRole ( userId,roleId) select u.id, r.id from JIUser u, JIRole r where u.username = "anonymoususer" and r.rolename = "ROLE_ANONYMOUS" -- add jasperadmin user INSERT INTO JIUser (username,fullname,emailAddress,password,externallyDefined,enabled) VALUES ("jasperadmin","Jasper Administrator",NULL,"jasperadmin",0,1) INSERT INTO JIUserRole (userId,roleId) select u.id, r.id from JIUser u, JIRole r where u.username = "jasperadmin" and r.rolename = "ROLE_ADMINISTRATOR" INSERT INTO JIUserRole (userId,roleId) select u.id, r.id from JIUser u, JIRole r where u.username = "jasperadmin" and r.rolename = "ROLE_USER" IF OBJECT_ID('JIResourceFolder') IS NOT NULL delete from JIResourceFolder go INSERT INTO JIResourceFolder (version,uri,hidden,name,label,description,parent_folder,creation_date) VALUES (0,"/",0,"/","root","Root of the folder hierarchy", NULL, getdate()) IF OBJECT_ID('JIObjectPermission') IS NOT NULL delete from JIObjectPermission go INSERT INTO JIObjectPermission (uri,recipientobjectclass,permissionMask,recipientobjectid) select "repo:/","com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole", 1, r.id from JIRole r where rolename = "ROLE_ADMINISTRATOR" INSERT INTO JIObjectPermission (uri,recipientobjectclass,permissionMask,recipientobjectid) select "repo:/","com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole", 2, r.id from JIRole r where rolename = "ROLE_USER" /*==============================================================================*/ /* End of script. */ /*==============================================================================*/ Post Edited by khadir samir Post Edited by khadir samir at 02/13/09 10:40

hi i post here the database script for jasperServer, this script work well with Sybase ASE , and to test them with SQLServer. if you have this exception : [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure.] clear the conent of "js.quartz.base.properties" at : <tomcatHome>webapps/jasperserver/WEB-INF/ and insert this lignes : # This file contains only properties that don't normally change. # It gets used in the Spring bean for the Quartz scheduler. # Other properties are set by referring to settings in js.quartz.properties org.quartz.scheduler.instanceName=JasperServerScheduler org.quartz.threadPool.threadCount=2 org.quartz.threadPool.threadPriority=3 org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.MSSQLDelegate org.quartz.jobStore.misfireThreshold=180000 org.quartz.jobStore.selectWithLockSQL=SELECT * FROM {0}LOCKS UPDLOCK WHERE LOCK_NAME = ? org.quartz.jobStore.class=org.springframework.scheduling.quartz.LocalDataSourceJobStore org.quartz.jobStore.dontSetNonManagedTXConnectionAutoCommitFalse=true org.quartz.jobStore.dontSetAutoCommitFalse=true good luck !!! ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- script "create tables" : /* * * date : 10/02/2009 * author : @SKH */ IF OBJECT_ID ('dbo.JIBeanDatasource') IS NOT NULL DROP TABLE dbo.JIBeanDatasource GO IF OBJECT_ID ('dbo.JIContentResource') IS NOT NULL DROP TABLE dbo.JIContentResource GO IF OBJECT_ID ('dbo.JICustomDatasourceproperty') IS NOT NULL DROP TABLE dbo.JICustomDatasourceproperty GO IF OBJECT_ID ('dbo.JIInputControlQueryColumn') IS NOT NULL DROP TABLE dbo.JIInputControlQueryColumn GO IF OBJECT_ID ('dbo.JIJNDIJdbcDatasource') IS NOT NULL DROP TABLE dbo.JIJNDIJdbcDatasource GO IF OBJECT_ID ('dbo.JIJdbcDatasource') IS NOT NULL DROP TABLE dbo.JIJdbcDatasource GO IF OBJECT_ID ('dbo.JIListOfValuesItem') IS NOT NULL DROP TABLE dbo.JIListOfValuesItem GO IF OBJECT_ID ('dbo.JILogEvent') IS NOT NULL DROP TABLE dbo.JILogEvent GO IF OBJECT_ID ('dbo.JIMondrianXMLADefinition') IS NOT NULL DROP TABLE dbo.JIMondrianXMLADefinition GO IF OBJECT_ID ('dbo.JIObjectPermission') IS NOT NULL DROP TABLE dbo.JIObjectPermission GO IF OBJECT_ID ('dbo.JIReportJobCalendarTrigger') IS NOT NULL DROP TABLE dbo.JIReportJobCalendarTrigger GO IF OBJECT_ID ('dbo.JIReportJobMailRecipient') IS NOT NULL DROP TABLE dbo.JIReportJobMailRecipient GO IF OBJECT_ID ('dbo.JIReportJobOutputFormat') IS NOT NULL DROP TABLE dbo.JIReportJobOutputFormat GO IF OBJECT_ID ('dbo.JIReportJobParameter') IS NOT NULL DROP TABLE dbo.JIReportJobParameter GO IF OBJECT_ID ('dbo.JIOlapUnit') IS NOT NULL DROP TABLE dbo.JIOlapUnit GO IF OBJECT_ID ('dbo.JIProfileAttribute') IS NOT NULL DROP TABLE dbo.JIProfileAttribute GO IF OBJECT_ID ('dbo.JIReportJobSimpleTrigger') IS NOT NULL DROP TABLE dbo.JIReportJobSimpleTrigger GO IF OBJECT_ID ('dbo.JIReportUnitInputControl') IS NOT NULL DROP TABLE dbo.JIReportUnitInputControl GO IF OBJECT_ID ('dbo.JIReportUnitResource') IS NOT NULL DROP TABLE dbo.JIReportUnitResource GO IF OBJECT_ID ('dbo.JIRepositoryCache') IS NOT NULL DROP TABLE dbo.JIRepositoryCache GO IF OBJECT_ID ('dbo.JIUserRole') IS NOT NULL DROP TABLE dbo.JIUserRole GO IF OBJECT_ID ('dbo.JIXMLAConnection') IS NOT NULL DROP TABLE dbo.JIXMLAConnection GO IF OBJECT_ID ('dbo.JICustomDatasource') IS NOT NULL DROP TABLE dbo.JICustomDatasource GO IF OBJECT_ID ('dbo.JIInputControl') IS NOT NULL DROP TABLE dbo.JIInputControl GO IF OBJECT_ID ('dbo.JIListOfValues') IS NOT NULL DROP TABLE dbo.JIListOfValues GO IF OBJECT_ID ('dbo.JIMondrianConnection') IS NOT NULL DROP TABLE dbo.JIMondrianConnection GO IF OBJECT_ID ('dbo.JIOlapClientConnection') IS NOT NULL DROP TABLE dbo.JIOlapClientConnection GO IF OBJECT_ID ('dbo.JIReportJob') IS NOT NULL DROP TABLE dbo.JIReportJob GO IF OBJECT_ID ('dbo.JIReportJobMail') IS NOT NULL DROP TABLE dbo.JIReportJobMail GO IF OBJECT_ID ('dbo.JIReportJobRepoDest') IS NOT NULL DROP TABLE dbo.JIReportJobRepoDest GO IF OBJECT_ID ('dbo.JIReportJobTrigger') IS NOT NULL DROP TABLE dbo.JIReportJobTrigger GO IF OBJECT_ID ('dbo.JIReportUnit') IS NOT NULL DROP TABLE dbo.JIReportUnit GO IF OBJECT_ID ('dbo.JIRole') IS NOT NULL DROP TABLE dbo.JIRole GO IF OBJECT_ID ('dbo.JIUser') IS NOT NULL DROP TABLE dbo.JIUser GO IF OBJECT_ID ('dbo.JIDataType') IS NOT NULL DROP TABLE dbo.JIDataType GO IF OBJECT_ID ('dbo.JIFileResource') IS NOT NULL DROP TABLE dbo.JIFileResource GO IF OBJECT_ID ('dbo.JIQuery') IS NOT NULL DROP TABLE dbo.JIQuery GO IF OBJECT_ID ('dbo.JIResource') IS NOT NULL DROP TABLE dbo.JIResource GO IF OBJECT_ID ('dbo.JIResourceFolder') IS NOT NULL DROP TABLE dbo.JIResourceFolder GO CREATE TABLE JIBeanDatasource ( id INT NOT NULL, beanName VARCHAR(100) NOT NULL, beanMethod VARCHAR(100) NULL ) ALTER TABLE JIBeanDatasource ADD CONSTRAINT pk_JIBeanDatasource PRIMARY KEY (id) CREATE TABLE JIContentResource ( id INT NOT NULL, data IMAGE NULL, file_type VARCHAR(20) NULL ) ALTER TABLE JIContentResource ADD CONSTRAINT pk_JIContentResource PRIMARY KEY (id) CREATE TABLE JICustomDatasource ( id INT NOT NULL, serviceClass VARCHAR(250) NOT NULL ) ALTER TABLE JICustomDatasource ADD CONSTRAINT pk_JICustomDatasource PRIMARY KEY (id) CREATE TABLE JICustomDatasourceproperty ( ds_id INT NOT NULL, value TEXT NULL, name VARCHAR(100) NOT NULL ) ALTER TABLE JICustomDatasourceproperty ADD CONSTRAINT pk_JICustomDatasourceproperty PRIMARY KEY (ds_id, name) CREATE TABLE JIDataType ( id INT NOT NULL, type TINYINT NULL, maxLength INT NULL, decimals INT NULL, regularExpr VARCHAR(255) NULL, minValue IMAGE NULL, maxValue IMAGE NULL, strictMin BIT , strictMax BIT ) ALTER TABLE JIDataType ADD CONSTRAINT pk_JIDataType PRIMARY KEY (id) CREATE TABLE JIFileResource ( id INT NOT NULL, data IMAGE NULL, file_type VARCHAR(20) NULL, reference INT NULL ) ALTER TABLE JIFileResource ADD CONSTRAINT pk_JIFileResource PRIMARY KEY (id) CREATE TABLE JIInputControl ( id INT NOT NULL, type TINYINT NULL, mandatory BIT , readOnly BIT , visible BIT , data_type INT NULL, list_of_values INT NULL, list_query INT NULL, query_value_column VARCHAR(200) NULL, defaultValue IMAGE NULL ) ALTER TABLE JIInputControl ADD CONSTRAINT pk_JIInputControl PRIMARY KEY (id) CREATE TABLE JIInputControlQueryColumn ( input_control_id INT NOT NULL, query_column VARCHAR(200) NOT NULL, column_index INT NOT NULL ) ALTER TABLE JIInputControlQueryColumn ADD CONSTRAINT pk_JIInputControlQueryColumn PRIMARY KEY (input_control_id, column_index) CREATE TABLE JIJNDIJdbcDatasource ( id INT NOT NULL, jndiName VARCHAR(100) NOT NULL, timezone VARCHAR(100) NULL ) ALTER TABLE JIJNDIJdbcDatasource ADD CONSTRAINT pk_JIJNDIJdbcDatasource PRIMARY KEY (id) CREATE TABLE JIJdbcDatasource ( id INT NOT NULL, driver VARCHAR(100) NOT NULL, password VARCHAR(100) NULL, connectionUrl TEXT NULL, username VARCHAR(100) NULL, timezone VARCHAR(100) NULL ) ALTER TABLE JIJdbcDatasource ADD CONSTRAINT pk_JIJdbcDatasource PRIMARY KEY (id) CREATE TABLE JIListOfValues ( id INT NOT NULL ) ALTER TABLE JIListOfValues ADD CONSTRAINT pk_JIListOfValues PRIMARY KEY (id) CREATE TABLE JIListOfValuesItem ( id INT NOT NULL, label VARCHAR(255) NULL, value IMAGE NULL, idx INT NOT NULL ) ALTER TABLE JIListOfValuesItem ADD CONSTRAINT pk_JIListOfValuesItem PRIMARY KEY (id,idx) CREATE TABLE JILogEvent ( id INT IDENTITY NOT NULL, occurrence_date DATETIME NOT NULL, event_type TINYINT NOT NULL, username VARCHAR(100) NULL, component VARCHAR(100) NULL, message VARCHAR(250) NOT NULL, resource_uri VARCHAR(250) NULL, event_text IMAGE NULL, event_data IMAGE NULL, event_state TINYINT NULL ) ALTER TABLE JILogEvent ADD CONSTRAINT pk_JILogEvent PRIMARY KEY (id) CREATE TABLE JIMondrianConnection ( id INT NOT NULL, reportDataSource INT NULL, mondrianSchema INT NULL ) ALTER TABLE JIMondrianConnection ADD CONSTRAINT pk_JIMondrianConnection PRIMARY KEY (id) CREATE TABLE JIMondrianXMLADefinition ( id INT NOT NULL, catalog VARCHAR(100) NOT NULL, mondrianConnection INT NULL ) ALTER TABLE JIMondrianXMLADefinition ADD CONSTRAINT pk_JIMondrianXMLADefinition PRIMARY KEY (id) CREATE TABLE JIObjectPermission ( id INT IDENTITY NOT NULL, uri VARCHAR(255) NOT NULL, recipientobjectclass VARCHAR(100) NULL, recipientobjectid INT NULL, permissionMask INT NOT NULL ) ALTER TABLE JIObjectPermission ADD CONSTRAINT pk_JIObjectPermission PRIMARY KEY (id) CREATE TABLE JIOlapClientConnection ( id INT NOT NULL ) ALTER TABLE JIOlapClientConnection ADD CONSTRAINT pk_JIOlapClientConnection PRIMARY KEY (id) CREATE TABLE JIOlapUnit ( id INT NOT NULL, olapClientConnection INT NULL, mdx_query TEXT NOT NULL, view_options IMAGE NULL ) ALTER TABLE JIOlapUnit ADD CONSTRAINT pk_JIOlapUnit PRIMARY KEY (id) CREATE TABLE JIProfileAttribute ( id INT IDENTITY NOT NULL, attrName VARCHAR(255) NOT NULL, attrValue VARCHAR(255) NOT NULL, principalobjectclass VARCHAR(255) NOT NULL, principalobjectid INT NOT NULL ) ALTER TABLE JIProfileAttribute ADD CONSTRAINT pk_JIProfileAttribute PRIMARY KEY (id) CREATE TABLE JIQuery ( id INT NOT NULL, dataSource INT NULL, query_language VARCHAR(40) NOT NULL, sql_query TEXT NOT NULL ) ALTER TABLE JIQuery ADD CONSTRAINT pk_JIQuery PRIMARY KEY (id) CREATE TABLE JIReportJob ( id INT IDENTITY NOT NULL, version INT NOT NULL, username VARCHAR(100) NOT NULL, label VARCHAR(100) NOT NULL, description TEXT NULL, report_unit_uri VARCHAR(200) NOT NULL, job_trigger INT NOT NULL, base_output_name VARCHAR(100) NOT NULL, output_locale VARCHAR(20) NULL, content_destination INT NULL, mail_notification INT NULL ) ALTER TABLE JIReportJob ADD CONSTRAINT pk_JIReportJob PRIMARY KEY (id) CREATE TABLE JIReportJobCalendarTrigger ( id INT NOT NULL, minutes VARCHAR(200) NOT NULL, hours VARCHAR(80) NOT NULL, days_type TINYINT NOT NULL, week_days VARCHAR(20) NULL, month_days VARCHAR(100) NULL, months VARCHAR(40) NOT NULL ) ALTER TABLE JIReportJobCalendarTrigger ADD CONSTRAINT pk_JIReportJobCalendarTrigger PRIMARY KEY (id) CREATE TABLE JIReportJobMail ( id INT IDENTITY NOT NULL, version INT NOT NULL, subject VARCHAR(100) NOT NULL, message TEXT NOT NULL, send_type TINYINT NOT NULL, skip_empty BIT NOT NULL ) ALTER TABLE JIReportJobMail ADD CONSTRAINT pk_JIReportJobMail PRIMARY KEY (id) CREATE TABLE JIReportJobMailRecipient ( destination_id INT NOT NULL, recipient_type TINYINT NOT NULL, address VARCHAR(100) NOT NULL, recipient_idx INT NOT NULL ) ALTER TABLE JIReportJobMailRecipient ADD CONSTRAINT pk_JIReportJobMailRecipient PRIMARY KEY (destination_id, recipient_idx) CREATE TABLE JIReportJobOutputFormat ( report_job_id INT NOT NULL, output_format TINYINT NOT NULL ) ALTER TABLE JIReportJobOutputFormat ADD CONSTRAINT pk_JIReportJobOutputFormat PRIMARY KEY (report_job_id, output_format) CREATE TABLE JIReportJobParameter ( job_id INT NOT NULL, parameter_value IMAGE NULL, parameter_name VARCHAR(100) NOT NULL ) ALTER TABLE JIReportJobParameter ADD CONSTRAINT pk_JIReportJobParameter PRIMARY KEY (job_id, parameter_name) CREATE TABLE JIReportJobRepoDest ( id INT IDENTITY NOT NULL, version INT NOT NULL, folder_uri VARCHAR(200) NOT NULL, sequential_filenames BIT NOT NULL, overwrite_files BIT NOT NULL, output_description VARCHAR(100) NULL, timestamp_pattern VARCHAR(250) NULL ) ALTER TABLE JIReportJobRepoDest ADD CONSTRAINT pk_JIReportJobRepoDest PRIMARY KEY (id) CREATE TABLE JIReportJobSimpleTrigger ( id INT NOT NULL, occurrence_count INT NOT NULL, recurrence_interval INT NULL, recurrence_interval_unit TINYINT NULL ) ALTER TABLE JIReportJobSimpleTrigger ADD CONSTRAINT pk_JIReportJobSimpleTrigger PRIMARY KEY (id) CREATE TABLE JIReportJobTrigger ( id INT IDENTITY NOT NULL, version INT NOT NULL, timezone VARCHAR(40) NULL, start_type TINYINT NOT NULL, start_date DATETIME NULL, end_date DATETIME NULL ) ALTER TABLE JIReportJobTrigger ADD CONSTRAINT pk_JIReportJobTrigger PRIMARY KEY (id) CREATE TABLE JIReportUnit ( id INT NOT NULL, reportDataSource INT NULL, query INT NULL, mainReport INT NULL, controlrenderer VARCHAR(100) NULL, reportrenderer VARCHAR(100) NULL, promptcontrols BIT , controlslayout TINYINT NULL ) ALTER TABLE JIReportUnit ADD CONSTRAINT pk_JIReportUnit PRIMARY KEY (id) CREATE TABLE JIReportUnitInputControl ( report_unit_id INT NOT NULL, input_control_id INT NOT NULL, control_index INT NOT NULL ) ALTER TABLE JIReportUnitInputControl ADD CONSTRAINT pk_JIReportUnitInputControl PRIMARY KEY (report_unit_id, control_index) CREATE TABLE JIReportUnitResource ( report_unit_id INT NOT NULL, resource_id INT NOT NULL, resource_index INT NOT NULL ) ALTER TABLE JIReportUnitResource ADD CONSTRAINT pk_JIReportUnitResource PRIMARY KEY (report_unit_id, resource_index) CREATE TABLE JIRepositoryCache ( id INT IDENTITY NOT NULL, uri VARCHAR(200) NOT NULL, cache_name VARCHAR(20) NOT NULL, data IMAGE NULL, version INT NOT NULL, version_date DATETIME NOT NULL, item_reference INT NULL ) ALTER TABLE JIRepositoryCache ADD CONSTRAINT pk_JIRepositoryCache PRIMARY KEY (id) CREATE TABLE JIResource ( id INT IDENTITY NOT NULL, version INT NOT NULL, name VARCHAR(100) NOT NULL, parent_folder INT NOT NULL, childrenFolder INT NULL, label VARCHAR(100) NOT NULL, description VARCHAR(250) NULL, creation_date DATETIME NOT NULL ) ALTER TABLE JIResource ADD CONSTRAINT pk_JIResource PRIMARY KEY (id) CREATE TABLE JIResourceFolder ( id INT IDENTITY NOT NULL, version INT NOT NULL, uri VARCHAR(250) NOT NULL, hidden BIT , name VARCHAR(100) NOT NULL, label VARCHAR(100) NOT NULL, description VARCHAR(250) NULL, parent_folder INT NULL, creation_date DATETIME NOT NULL ) ALTER TABLE JIResourceFolder ADD CONSTRAINT pk_JIResourceFolder PRIMARY KEY (id) CREATE TABLE JIUserRole ( roleId INT NOT NULL, userId INT NOT NULL ) ALTER TABLE JIUserRole ADD CONSTRAINT pk_JIUserRole PRIMARY KEY (userId, roleId) CREATE TABLE JIXMLAConnection ( id INT NOT NULL, catalog VARCHAR(100) NOT NULL, username VARCHAR(100) NOT NULL, password VARCHAR(100) NOT NULL, datasource VARCHAR(100) NOT NULL, uri VARCHAR(100) NOT NULL ) ALTER TABLE JIXMLAConnection ADD CONSTRAINT pk_JIXMLAConnection PRIMARY KEY (id) CREATE INDEX FK674BF34A8BF376D ON JIBeanDatasource (id ) CREATE INDEX FKE466FC68A8BF376D ON JIContentResource (id ) CREATE INDEX FK2BBCEDF5A8BF376D ON JICustomDatasource (id ) CREATE INDEX FKB8A66AEA858A89D1 ON JICustomDatasourceproperty (ds_id ) CREATE INDEX FK533BCC63A8BF376D ON JIDataType (id ) CREATE INDEX FKF75B58895A0C539 ON JIFileResource (reference ) CREATE INDEX FKF75B5889A8BF376D ON JIFileResource (id ) CREATE INDEX FKCAC6A512120E06F7 ON JIInputControl (data_type ) CREATE INDEX FKCAC6A51262A86F04 ON JIInputControl (list_of_values ) CREATE INDEX FKCAC6A512A8BF376D ON JIInputControl (id ) CREATE INDEX FKCAC6A512B37DB6EB ON JIInputControl (list_query ) CREATE INDEX FKE436A5CCE7922149 ON JIInputControlQueryColumn (input_control_id ) CREATE INDEX FKC8BDFCBFA8BF376D ON JIJdbcDatasource (id ) CREATE INDEX FK7F9DA248A8BF376D ON JIJNDIJdbcDatasource (id ) CREATE INDEX FK4E86A776A8BF376D ON JIListOfValues (id ) CREATE INDEX FKD37CEBA993F0E1F6 ON JIListOfValuesItem (id ) CREATE INDEX FK4FF53B191D51BFAD ON JIMondrianConnection (id ) CREATE INDEX FK4FF53B19324CFECB ON JIMondrianConnection (reportDataSource ) CREATE INDEX FK4FF53B19C495A60B ON JIMondrianConnection (mondrianSchema ) CREATE INDEX FK313B2AB8A8BF376D ON JIMondrianXMLADefinition (id ) CREATE INDEX FK313B2AB8DC098B1 ON JIMondrianXMLADefinition (mondrianConnection ) CREATE INDEX FK3CA3B7D4A8BF376D ON JIOlapClientConnection (id ) CREATE INDEX FKF034DCCF8F542247 ON JIOlapUnit (olapClientConnection ) CREATE INDEX FKF034DCCFA8BF376D ON JIOlapUnit (id ) CREATE INDEX FKCBCB0EC92B329A97 ON JIQuery (dataSource ) CREATE INDEX FKCBCB0EC9A8BF376D ON JIQuery (id ) CREATE INDEX FK156F5F6A74D2696E ON JIReportJob (job_trigger ) CREATE INDEX FK156F5F6A9EEC902C ON JIReportJob (content_destination ) CREATE INDEX FK156F5F6AE4D73E35 ON JIReportJob (mail_notification ) CREATE INDEX FKC374C7D0D2B2EB53 ON JIReportJobCalendarTrigger (id ) CREATE INDEX FKBB6DB6D880001AAE ON JIReportJobMailRecipient (destination_id ) CREATE INDEX FKB42A5CE2C3389A8 ON JIReportJobOutputFormat (report_job_id ) CREATE INDEX FKEAC52B5F2EC643D ON JIReportJobParameter (job_id ) CREATE INDEX FKB9337C5CD2B2EB53 ON JIReportJobSimpleTrigger (id ) CREATE INDEX FK98818B77324CFECB ON JIReportUnit (reportDataSource ) CREATE INDEX FK98818B778C8DF21B ON JIReportUnit (mainReport ) CREATE INDEX FK98818B778FDA11CC ON JIReportUnit (query ) CREATE INDEX FK98818B77A8BF376D ON JIReportUnit (id ) CREATE INDEX FK5FBE934AA6A48880 ON JIReportUnitInputControl (report_unit_id ) CREATE INDEX FK5FBE934AE7922149 ON JIReportUnitInputControl (input_control_id ) CREATE INDEX FK8B1C4CA5865B10DA ON JIReportUnitResource (resource_id ) CREATE INDEX FK8B1C4CA5A6A48880 ON JIReportUnitResource (report_unit_id ) CREATE INDEX FKE7338B19E7C5A6 ON JIRepositoryCache (item_reference ) CREATE UNIQUE INDEX uri ON JIRepositoryCache (uri , cache_name ) CREATE INDEX FKD444826DA08E2155 ON JIResource (parent_folder ) CREATE INDEX FKD444826DA58002DF ON JIResource (childrenFolder ) CREATE UNIQUE INDEX name ON JIResource (name , parent_folder ) CREATE INDEX FK7F24453BA08E2155 ON JIResourceFolder (parent_folder ) CREATE UNIQUE INDEX uri ON JIResourceFolder (uri ) CREATE INDEX FKD8B5C1403C31045 ON JIUserRole (roleId ) CREATE INDEX FKD8B5C14091865AF ON JIUserRole (userId ) ALTER TABLE JIBeanDatasource ADD CONSTRAINT FK674BF34A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIContentResource ADD CONSTRAINT FKE466FC68A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JICustomDatasource ADD CONSTRAINT FK2BBCEDF5A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JICustomDatasourceproperty ADD CONSTRAINT FKB8A66AEA858A89D1 FOREIGN KEY (ds_id) REFERENCES JICustomDatasource (id) ALTER TABLE JIDataType ADD CONSTRAINT FK533BCC63A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIFileResource ADD CONSTRAINT FKF75B58895A0C539 FOREIGN KEY (reference) REFERENCES JIFileResource (id) ALTER TABLE JIFileResource ADD CONSTRAINT FKF75B5889A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIInputControl ADD CONSTRAINT FKCAC6A512120E06F7 FOREIGN KEY (data_type) REFERENCES JIDataType (id) ALTER TABLE JIInputControl ADD CONSTRAINT FKCAC6A512B37DB6EB FOREIGN KEY (list_query) REFERENCES JIQuery (id) ALTER TABLE JIInputControl ADD CONSTRAINT FKCAC6A51262A86F04 FOREIGN KEY (list_of_values) REFERENCES JIListOfValues (id) ALTER TABLE JIInputControl ADD CONSTRAINT FKCAC6A512A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIInputControlQueryColumn ADD CONSTRAINT FKE436A5CCE7922149 FOREIGN KEY (input_control_id) REFERENCES JIInputControl (id) ALTER TABLE JIJNDIJdbcDatasource ADD CONSTRAINT FK7F9DA248A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIJdbcDatasource ADD CONSTRAINT FKC8BDFCBFA8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIListOfValues ADD CONSTRAINT FK4E86A776A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIListOfValuesItem ADD CONSTRAINT FKD37CEBA993F0E1F6 FOREIGN KEY (id) REFERENCES JIListOfValues (id) ALTER TABLE JIMondrianConnection ADD CONSTRAINT FK4FF53B19C495A60B FOREIGN KEY (mondrianSchema) REFERENCES JIFileResource (id) ALTER TABLE JIMondrianConnection ADD CONSTRAINT FK4FF53B19324CFECB FOREIGN KEY (reportDataSource) REFERENCES JIResource (id) ALTER TABLE JIMondrianConnection ADD CONSTRAINT FK4FF53B191D51BFAD FOREIGN KEY (id) REFERENCES JIOlapClientConnection (id) ALTER TABLE JIMondrianXMLADefinition ADD CONSTRAINT FK313B2AB8DC098B1 FOREIGN KEY (mondrianConnection) REFERENCES JIMondrianConnection (id) ALTER TABLE JIMondrianXMLADefinition ADD CONSTRAINT FK313B2AB8A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIOlapClientConnection ADD CONSTRAINT FK3CA3B7D4A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIOlapUnit ADD CONSTRAINT FKF034DCCF8F542247 FOREIGN KEY (olapClientConnection) REFERENCES JIOlapClientConnection (id) ALTER TABLE JIOlapUnit ADD CONSTRAINT FKF034DCCFA8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIQuery ADD CONSTRAINT FKCBCB0EC92B329A97 FOREIGN KEY (dataSource) REFERENCES JIResource (id) ALTER TABLE JIQuery ADD CONSTRAINT FKCBCB0EC9A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIReportJob ADD CONSTRAINT FK156F5F6AE4D73E35 FOREIGN KEY (mail_notification) REFERENCES JIReportJobMail (id) ALTER TABLE JIReportJob ADD CONSTRAINT FK156F5F6A9EEC902C FOREIGN KEY (content_destination) REFERENCES JIReportJobRepoDest (id) ALTER TABLE JIReportJob ADD CONSTRAINT FK156F5F6A74D2696E FOREIGN KEY (job_trigger) REFERENCES JIReportJobTrigger (id) ALTER TABLE JIReportJobCalendarTrigger ADD CONSTRAINT FKC374C7D0D2B2EB53 FOREIGN KEY (id) REFERENCES JIReportJobTrigger (id) ALTER TABLE JIReportJobMailRecipient ADD CONSTRAINT FKBB6DB6D880001AAE FOREIGN KEY (destination_id) REFERENCES JIReportJobMail (id) ALTER TABLE JIReportJobOutputFormat ADD CONSTRAINT FKB42A5CE2C3389A8 FOREIGN KEY (report_job_id) REFERENCES JIReportJob (id) ALTER TABLE JIReportJobParameter ADD CONSTRAINT FKEAC52B5F2EC643D FOREIGN KEY (job_id) REFERENCES JIReportJob (id) ALTER TABLE JIReportJobSimpleTrigger ADD CONSTRAINT FKB9337C5CD2B2EB53 FOREIGN KEY (id) REFERENCES JIReportJobTrigger (id) ALTER TABLE JIReportUnit ADD CONSTRAINT FK98818B778FDA11CC FOREIGN KEY (query) REFERENCES JIQuery (id) ALTER TABLE JIReportUnit ADD CONSTRAINT FK98818B77324CFECB FOREIGN KEY (reportDataSource) REFERENCES JIResource (id) ALTER TABLE JIReportUnit ADD CONSTRAINT FK98818B778C8DF21B FOREIGN KEY (mainReport) REFERENCES JIFileResource (id) ALTER TABLE JIReportUnit ADD CONSTRAINT FK98818B77A8BF376D FOREIGN KEY (id) REFERENCES JIResource (id) ALTER TABLE JIReportUnitInputControl ADD CONSTRAINT FK5FBE934AE7922149 FOREIGN KEY (input_control_id) REFERENCES JIInputControl (id) ALTER TABLE JIReportUnitInputControl ADD CONSTRAINT FK5FBE934AA6A48880 FOREIGN KEY (report_unit_id) REFERENCES JIReportUnit (id) ALTER TABLE JIReportUnitResource ADD CONSTRAINT FK8B1C4CA5865B10DA FOREIGN KEY (resource_id) REFERENCES JIFileResource (id) ALTER TABLE JIReportUnitResource ADD CONSTRAINT FK8B1C4CA5A6A48880 FOREIGN KEY (report_unit_id) REFERENCES JIReportUnit (id) ALTER TABLE JIRepositoryCache ADD CONSTRAINT FKE7338B19E7C5A6 FOREIGN KEY (item_reference) REFERENCES JIRepositoryCache (id) ALTER TABLE JIResource ADD CONSTRAINT FKD444826DA08E2155 FOREIGN KEY (parent_folder) REFERENCES JIResourceFolder (id) ALTER TABLE JIResource ADD CONSTRAINT FKD444826DA58002DF FOREIGN KEY (childrenFolder) REFERENCES JIResourceFolder (id) ALTER TABLE JIResourceFolder ADD CONSTRAINT FK7F24453BA08E2155 FOREIGN KEY (parent_folder) REFERENCES JIResourceFolder (id) ALTER TABLE JIXMLAConnection ADD CONSTRAINT FK94C688A71D51BFAD FOREIGN KEY (id) REFERENCES JIOlapClientConnection (id) CREATE TABLE JIRole ( id INT IDENTITY NOT NULL, rolename VARCHAR(100) NOT NULL unique, externallyDefined BIT ) ALTER TABLE JIRole ADD CONSTRAINT pk_JIRole PRIMARY KEY (id) CREATE TABLE JIUser ( id INT IDENTITY NOT NULL, username VARCHAR(100) NOT NULL unique, fullname VARCHAR(100) NOT NULL, emailAddress VARCHAR(100) NULL, password VARCHAR(100) NULL, externallyDefined BIT , enabled BIT , previousPasswordChangeTime DATETIME NULL ) ALTER TABLE JIUser ADD CONSTRAINT pk_JIUser PRIMARY KEY (id) CREATE UNIQUE INDEX rolename ON JIRole (rolename ) CREATE UNIQUE INDEX username ON JIUser (username ) ALTER TABLE JIUserRole ADD CONSTRAINT FKD8B5C14091865AF FOREIGN KEY (userId) REFERENCES JIUser (id) ALTER TABLE JIUserRole ADD CONSTRAINT FKD8B5C1403C31045 FOREIGN KEY (roleId) REFERENCES JIRole (id) /*==============================================================================*/ /* End of script. */ /*==============================================================================*/ script Quartz Tables : /*==============================================================================================*/ /* Quartz database tables creation script for Sybase ASE 12.5 */ /* Written by Pertti Laiho (email: pertti.laiho@deio.net), 9th May 2003 */ /* */ /* Compatible with Quartz version 1.1.2 */ /* */ /* Sybase ASE works ok with the MSSQL delegate class. That means in your Quartz properties */ /* file, you'll need to set: */ /* org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.MSSQLDelegate */ /*==============================================================================================*/ use jasperserver go /*==============================================================================*/ /* Clear all tables: */ /*==============================================================================*/ IF OBJECT_ID('QRTZ_JOB_LISTENERS') IS NOT NULL delete from QRTZ_JOB_LISTENERS go IF OBJECT_ID('QRTZ_TRIGGER_LISTENERS') IS NOT NULL delete from QRTZ_TRIGGER_LISTENERS go IF OBJECT_ID('QRTZ_FIRED_TRIGGERS') IS NOT NULL delete from QRTZ_FIRED_TRIGGERS go IF OBJECT_ID('QRTZ_PAUSED_TRIGGER_GRPS') IS NOT NULL delete from QRTZ_PAUSED_TRIGGER_GRPS go IF OBJECT_ID('QRTZ_SCHEDULER_STATE') IS NOT NULL delete from QRTZ_SCHEDULER_STATE go IF OBJECT_ID('QRTZ_LOCKS') IS NOT NULL delete from QRTZ_LOCKS go IF OBJECT_ID('QRTZ_SIMPLE_TRIGGERS') IS NOT NULL delete from QRTZ_SIMPLE_TRIGGERS go IF OBJECT_ID('QRTZ_CRON_TRIGGERS') IS NOT NULL delete from QRTZ_CRON_TRIGGERS go IF OBJECT_ID('QRTZ_BLOB_TRIGGERS') IS NOT NULL delete from QRTZ_BLOB_TRIGGERS go IF OBJECT_ID('QRTZ_TRIGGERS') IS NOT NULL delete from QRTZ_TRIGGERS go IF OBJECT_ID('QRTZ_JOB_DETAILS') IS NOT NULL delete from QRTZ_JOB_DETAILS go IF OBJECT_ID('QRTZ_CALENDARS') IS NOT NULL delete from QRTZ_CALENDARS go /*==============================================================================*/ /* Drop constraints: */ /*==============================================================================*/ alter table QRTZ_JOB_LISTENERS drop constraint FK_job_listeners_job_details go alter table QRTZ_TRIGGERS drop constraint FK_triggers_job_details go alter table QRTZ_CRON_TRIGGERS drop constraint FK_cron_triggers_triggers go alter table QRTZ_SIMPLE_TRIGGERS drop constraint FK_simple_triggers_triggers go alter table QRTZ_TRIGGER_LISTENERS drop constraint FK_trigger_listeners_triggers go alter table QRTZ_BLOB_TRIGGERS drop constraint FK_blob_triggers_triggers go /*==============================================================================*/ /* Drop tables: */ /*==============================================================================*/ drop table QRTZ_JOB_LISTENERS go drop table QRTZ_TRIGGER_LISTENERS go drop table QRTZ_FIRED_TRIGGERS go drop table QRTZ_PAUSED_TRIGGER_GRPS go drop table QRTZ_SCHEDULER_STATE go drop table QRTZ_LOCKS go drop table QRTZ_SIMPLE_TRIGGERS go drop table QRTZ_CRON_TRIGGERS go drop table QRTZ_BLOB_TRIGGERS go drop table QRTZ_TRIGGERS go drop table QRTZ_JOB_DETAILS go drop table QRTZ_CALENDARS go /*==============================================================================*/ /* Create tables: */ /*==============================================================================*/ create table QRTZ_CALENDARS ( CALENDAR_NAME varchar(80) not null, CALENDAR image not null ) go create table QRTZ_CRON_TRIGGERS ( TRIGGER_NAME varchar(80) not null, TRIGGER_GROUP varchar(80) not null, CRON_EXPRESSION varchar(120) not null, TIME_ZONE_ID varchar(80) null ) go create table QRTZ_PAUSED_TRIGGER_GRPS ( TRIGGER_GROUP varchar(80) not null ) go create table QRTZ_FIRED_TRIGGERS( ENTRY_ID varchar(95) not null, TRIGGER_NAME varchar(80) not null, TRIGGER_GROUP varchar(80) not null, IS_VOLATILE bit not null, INSTANCE_NAME varchar(80) not null, FIRED_TIME numeric(13,0) not null, STATE varchar(16) not null, JOB_NAME varchar(80) null, JOB_GROUP varchar(80) null, IS_STATEFUL bit not null, REQUESTS_RECOVERY bit not null ) go create table QRTZ_SCHEDULER_STATE ( INSTANCE_NAME varchar(80) not null, LAST_CHECKIN_TIME numeric(13,0) not null, CHECKIN_INTERVAL numeric(13,0) not null, RECOVERER VARCHAR(80) NULL ) go create table QRTZ_LOCKS ( LOCK_NAME varchar(40) not null ) go insert into QRTZ_LOCKS values('TRIGGER_ACCESS') go insert into QRTZ_LOCKS values('JOB_ACCESS') go insert into QRTZ_LOCKS values('CALENDAR_ACCESS') go insert into QRTZ_LOCKS values('STATE_ACCESS') go INSERT INTO QRTZ_LOCKS values('MISFIRE_ACCESS') go create table QRTZ_JOB_DETAILS ( JOB_NAME varchar(80) not null, JOB_GROUP varchar(80) not null, DESCRIPTION varchar(120) null, JOB_CLASS_NAME varchar(128) not null, IS_DURABLE bit not null, IS_VOLATILE bit not null, IS_STATEFUL bit not null, REQUESTS_RECOVERY bit not null, JOB_DATA image null ) go create table QRTZ_JOB_LISTENERS ( JOB_NAME varchar(80) not null, JOB_GROUP varchar(80) not null, JOB_LISTENER varchar(80) not null ) go create table QRTZ_SIMPLE_TRIGGERS ( TRIGGER_NAME varchar(80) not null, TRIGGER_GROUP varchar(80) not null, REPEAT_COUNT numeric(13,0) not null, REPEAT_INTERVAL numeric(13,0) not null, TIMES_TRIGGERED numeric(13,0) not null ) go create table QRTZ_BLOB_TRIGGERS ( TRIGGER_NAME varchar(80) not null, TRIGGER_GROUP varchar(80) not null, BLOB_DATA image null ) go create table QRTZ_TRIGGER_LISTENERS ( TRIGGER_NAME varchar(80) not null, TRIGGER_GROUP varchar(80) not null, TRIGGER_LISTENER varchar(80) not null ) go create table QRTZ_TRIGGERS ( TRIGGER_NAME varchar(80) not null, TRIGGER_GROUP varchar(80) not null, JOB_NAME varchar(80) not null, JOB_GROUP varchar(80) not null, IS_VOLATILE bit not null, DESCRIPTION varchar(120) null, NEXT_FIRE_TIME numeric(13,0) null, PREV_FIRE_TIME numeric(13,0) null, TRIGGER_STATE varchar(16) not null, TRIGGER_TYPE varchar(8) not null, START_TIME numeric(13,0) not null, END_TIME numeric(13,0) null, CALENDAR_NAME varchar(80) null, MISFIRE_INSTR smallint null, JOB_DATA image null ) go /*==============================================================================*/ /* Create primary key constraints: */ /*==============================================================================*/ alter table QRTZ_CALENDARS add constraint PK_qrtz_calendars primary key clustered (CALENDAR_NAME) go alter table QRTZ_CRON_TRIGGERS add constraint PK_qrtz_cron_triggers primary key clustered (TRIGGER_NAME, TRIGGER_GROUP) go alter table QRTZ_FIRED_TRIGGERS add constraint PK_qrtz_fired_triggers primary key clustered (ENTRY_ID) go alter table QRTZ_PAUSED_TRIGGER_GRPS add constraint PK_qrtz_paused_trigger_grps primary key clustered (TRIGGER_GROUP) go alter table QRTZ_SCHEDULER_STATE add constraint PK_qrtz_scheduler_state primary key clustered (INSTANCE_NAME) go alter table QRTZ_LOCKS add constraint PK_qrtz_locks primary key clustered (LOCK_NAME) go alter table QRTZ_JOB_DETAILS add constraint PK_qrtz_job_details primary key clustered (JOB_NAME, JOB_GROUP) go alter table QRTZ_JOB_LISTENERS add constraint PK_qrtz_job_listeners primary key clustered (JOB_NAME, JOB_GROUP, JOB_LISTENER) go alter table QRTZ_SIMPLE_TRIGGERS add constraint PK_qrtz_simple_triggers primary key clustered (TRIGGER_NAME, TRIGGER_GROUP) go alter table QRTZ_TRIGGER_LISTENERS add constraint PK_qrtz_trigger_listeners primary key clustered (TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_LISTENER) go alter table QRTZ_TRIGGERS add constraint PK_qrtz_triggers primary key clustered (TRIGGER_NAME, TRIGGER_GROUP) go alter table QRTZ_BLOB_TRIGGERS add constraint PK_qrtz_blob_triggers primary key clustered (TRIGGER_NAME, TRIGGER_GROUP) go /*==============================================================================*/ /* Create foreign key constraints: */ /*==============================================================================*/ alter table QRTZ_CRON_TRIGGERS add constraint FK_cron_triggers_triggers foreign key (TRIGGER_NAME,TRIGGER_GROUP) references QRTZ_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP) go alter table QRTZ_JOB_LISTENERS add constraint FK_job_listeners_job_details foreign key (JOB_NAME,JOB_GROUP) references QRTZ_JOB_DETAILS (JOB_NAME,JOB_GROUP) go alter table QRTZ_SIMPLE_TRIGGERS add constraint FK_simple_triggers_triggers foreign key (TRIGGER_NAME,TRIGGER_GROUP) references QRTZ_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP) go alter table QRTZ_TRIGGER_LISTENERS add constraint FK_trigger_listeners_triggers foreign key (TRIGGER_NAME,TRIGGER_GROUP) references QRTZ_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP) go alter table QRTZ_TRIGGERS add constraint FK_triggers_job_details foreign key (JOB_NAME,JOB_GROUP) references QRTZ_JOB_DETAILS (JOB_NAME,JOB_GROUP) go alter table QRTZ_BLOB_TRIGGERS add constraint FK_blob_triggers_triggers foreign key (TRIGGER_NAME,TRIGGER_GROUP) references QRTZ_TRIGGERS (TRIGGER_NAME,TRIGGER_GROUP) go /*==============================================================================*/ /* End of script. */ /*==============================================================================*/ script insert Role : /* * * date : 06/02/2009 * author : @skh */ IF OBJECT_ID('JIRole') IS NOT NULL delete from JIRole go INSERT INTO JIRole (rolename,externallyDefined) VALUES ("ROLE_USER",0) INSERT INTO JIRole (rolename,externallyDefined) VALUES ("ROLE_ADMINISTRATOR",0) INSERT INTO JIRole (rolename,externallyDefined) VALUES ("ROLE_ANONYMOUS",0) INSERT INTO JIRole (rolename,externallyDefined) VALUES ("ROLE_PORTLET",0) IF OBJECT_ID('JIUser') IS NOT NULL delete from JIUser go INSERT INTO JIUser (username, fullname, emailAddress, password, externallyDefined, enabled ) VALUES ("anonymoususer","Anonymous User",NULL,"",0,1) INSERT INTO JIUserRole ( userId,roleId) select u.id, r.id from JIUser u, JIRole r where u.username = "anonymoususer" and r.rolename = "ROLE_ANONYMOUS" -- add jasperadmin user INSERT INTO JIUser (username,fullname,emailAddress,password,externallyDefined,enabled) VALUES ("jasperadmin","Jasper Administrator",NULL,"jasperadmin",0,1) INSERT INTO JIUserRole (userId,roleId) select u.id, r.id from JIUser u, JIRole r where u.username = "jasperadmin" and r.rolename = "ROLE_ADMINISTRATOR" INSERT INTO JIUserRole (userId,roleId) select u.id, r.id from JIUser u, JIRole r where u.username = "jasperadmin" and r.rolename = "ROLE_USER" IF OBJECT_ID('JIResourceFolder') IS NOT NULL delete from JIResourceFolder go INSERT INTO JIResourceFolder (version,uri,hidden,name,label,description,parent_folder,creation_date) VALUES (0,"/",0,"/","root","Root of the folder hierarchy", NULL, getdate()) IF OBJECT_ID('JIObjectPermission') IS NOT NULL delete from JIObjectPermission go INSERT INTO JIObjectPermission (uri,recipientobjectclass,permissionMask,recipientobjectid) select "repo:/","com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole", 1, r.id from JIRole r where rolename = "ROLE_ADMINISTRATOR" INSERT INTO JIObjectPermission (uri,recipientobjectclass,permissionMask,recipientobjectid) select "repo:/","com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole", 2, r.id from JIRole r where rolename = "ROLE_USER" /*==============================================================================*/ /* End of script. */ /*==============================================================================*/ Post Edited by khadir samir at 02/13/09 10:33 Post Edited by khadir samir at 02/13/09 10:41

hi i have an exception when i started js in tomcat 6.0.10 with Sybase, i have olso translate all script for Mysql to Sybase and execute them succefuly(creta all tables with index and contraint) there is a stack trace of exception : SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepositoryService' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'schedulingReportDeleteListener' while setting bean property 'repositoryListeners' with key [2]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulingReportDeleteListener' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportSchedulingService' while setting bean property 'schedulingService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulingReportDeleteListener' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportSchedulingService' while setting bean property 'schedulingService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493) at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144) at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalDataSourceJobStore.java:133) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152) at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(SchedulerFactoryBean.java:674) at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:574) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.aop.framework.ProxyFactoryBean.freshTargetSource(ProxyFactoryBean.java:551) at org.springframework.aop.framework.ProxyFactoryBean.getSingletonInstance(ProxyFactoryBean.java:297) at org.springframework.aop.framework.ProxyFactoryBean.getObject(ProxyFactoryBean.java:253) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectFromFactoryBean(AbstractBeanFactory.java:1211) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1177) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:265) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4336) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:761) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:741) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825) at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1023) at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1015) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) * Nested Exception (Underlying Cause) --------------- org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ] at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.obtainLock(StdRowLockSemaphore.java:155) at org.quartz.impl.jdbcjobstore.JobStoreCMT.cleanVolatileTriggerAndJobs(JobStoreCMT.java:212) at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:491) at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144) at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalDataSourceJobStore.java:133) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152) at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(SchedulerFactoryBean.java:674) at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:574) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.aop.framework.ProxyFactoryBean.freshTargetSource(ProxyFactoryBean.java:551) at org.springframework.aop.framework.ProxyFactoryBean.getSingletonInstance(ProxyFactoryBean.java:297) at org.springframework.aop.framework.ProxyFactoryBean.getObject(ProxyFactoryBean.java:253) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectFromFactoryBean(AbstractBeanFactory.java:1211) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1177) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:265) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4336) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:761) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:741) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825) at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1023) at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1015) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) i think that is a pb with a Quartz !!!! Post Edited by khadir samir at 02/09/09 15:54 Post Edited by khadir samir at 02/09/09 15:56

hi i have an exception when i started js in tomcat 6.0.10 with Sybase, i have olso translate all script for Mysql to Sybase and execute them succefuly(creta all tables with index and contraint) there is a stack trace of exception : SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepositoryService' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'schedulingReportDeleteListener' while setting bean property 'repositoryListeners' with key [2]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulingReportDeleteListener' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportSchedulingService' while setting bean property 'schedulingService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulingReportDeleteListener' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportSchedulingService' while setting bean property 'schedulingService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ]] at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493) at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144) at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalDataSourceJobStore.java:133) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152) at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(SchedulerFactoryBean.java:674) at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:574) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.aop.framework.ProxyFactoryBean.freshTargetSource(ProxyFactoryBean.java:551) at org.springframework.aop.framework.ProxyFactoryBean.getSingletonInstance(ProxyFactoryBean.java:297) at org.springframework.aop.framework.ProxyFactoryBean.getObject(ProxyFactoryBean.java:253) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectFromFactoryBean(AbstractBeanFactory.java:1211) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1177) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:265) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4336) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:761) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:741) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825) at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1023) at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1015) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) * Nested Exception (Underlying Cause) --------------- org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. [see nested exception: com.sybase.jdbc2.jdbc.SybSQLException: FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. ] at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.obtainLock(StdRowLockSemaphore.java:155) at org.quartz.impl.jdbcjobstore.JobStoreCMT.cleanVolatileTriggerAndJobs(JobStoreCMT.java:212) at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:491) at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144) at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalDataSourceJobStore.java:133) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152) at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(SchedulerFactoryBean.java:674) at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:574) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.aop.framework.ProxyFactoryBean.freshTargetSource(ProxyFactoryBean.java:551) at org.springframework.aop.framework.ProxyFactoryBean.getSingletonInstance(ProxyFactoryBean.java:297) at org.springframework.aop.framework.ProxyFactoryBean.getObject(ProxyFactoryBean.java:253) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectFromFactoryBean(AbstractBeanFactory.java:1211) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1177) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:265) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4336) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:761) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:741) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825) at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1023) at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1015) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:448) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:552) 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.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) i think that is a pb with the source code with hibernate , he add an UPDATE command in SELECT !!! and sybase don't accpet this;

hi i have an exception when i install the war version in tomcat , i have take stap by step instruction installation in PDF Doc installation guide: - i have change the password of mysql root compte and olso MySQL context.xml for Tomcat with the same the exception is : (Access denied for user 'root'@'localhost' (using password: YES)) here is the stack trace : 11:45:14,125 ERROR JDBCExceptionReporter,Thread-1:78 - Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) 11:45:14,140 WARN SettingsFactory,Thread-1:109 - Could not obtain connection metadata org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:804) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:744) at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:270) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346) at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3830) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4337) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:719) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:566) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2572) at com.mysql.jdbc.Connection.<init>(Connection.java:1485) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221) ... 45 more 11:45:16,468 ERROR ContextLoader,Thread-1:205 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepositoryService' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'schedulingReportDeleteListener' while setting bean property 'repositoryListeners' with key [2]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulingReportDeleteListener' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportSchedulingService' while setting bean property 'schedulingService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.JasperServerScheduler': org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) [see nested exception: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'schedulingReportDeleteListener' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportSchedulingService' while setting bean property 'schedulingService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.JasperServerScheduler': org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) [see nested exception: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.JasperServerScheduler': org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) [see nested exception: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportSchedulingFacade' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.JasperServerScheduler': org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) [see nested exception: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'reportQuartzScheduler' while setting bean property 'target'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.JasperServerScheduler': org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) [see nested exception: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportQuartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Cannot resolve reference to bean 'quartzScheduler' while setting bean property 'scheduler'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.JasperServerScheduler': org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) [see nested exception: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))]] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'springNonTxDataSource.JasperServerScheduler': org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES)) [see nested exception: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root'@'localhost' (using password: YES))]]

hi go at the path installation of JS and you can see a file name'releasenote.txt' open it and in the begining of file you see the version N°. good by

hi after search i find that in ResourceDescriptor (RD) class there are a field: "List children" with getters & setters, if you have a parrent ResourceDescriptor like : <resourceDescriptor name="MyReportUnit" wsType="reportUnit" uriString="/reports/Jrxml/MyReportUnit" isNew="true"> in java : ResourceDescriptor rdReportUnit = new ResourceDescriptor(); rdReportUnit.setWsType(ResourceDescriptor.TYPE_REPORTUNIT); rdReportUnit.setUriString("/reports/Jrxml/MyReportUnit"); rdReportUnit.setName("MyReportUnit"); rdReportUnit.setLabel("MyReportUnit_teste"); rdReportUnit.setDescription("MyReportUnit for test"); rdReportUnit.setResourceProperty(new ResourceProperty(ResourceDescriptor.PROP_PARENT_FOLDER,"/reports/Jrxml")); rdReportUnit.setIsNew(true); and this RD have children like jrxml or query or datasource, you must create an other ResourceDescriptor : <resourceDescriptor name="JX" wsType="jrxml" uriString="/ReportingSystem/MyReports/JX_files" isNew="true"> in java : ResourceDescriptor rdJrxml = new ResourceDescriptor(); rdJrxml.setWsType(ResourceDescriptor.TYPE_JRXML); rdJrxml.setIsNew(false); rdJrxml.setIsReference(true); rdJrxml.setResourceProperty(new ResourceProperty(ResourceDescriptor.PROP_FILERESOURCE_REFERENCE_URI,"/ContentFiles/jrxml/rapport_exemple")); rdJrxml.setResourceProperty(new ResourceProperty(ResourceDescriptor.PROP_RU_IS_MAIN_REPORT,"true")); after set this RD children to RD parrent like List children = new ArrayList (); children.add(rdJrxml); rdReportUnit.setChildren(children); server.getWSClient().addOrModifyResource(rdReportUnit, null); thanks !!!!!!!!

hi all threre are one to help me to transform this xml soap to a java code : <resourceDescriptor name="QR" wsType="query" uriString="/ReportingSystem/MyReports/JX_files" isNew="true"> <label>QRlabel</label> <resourceProperty name="PROP_QUERY"> <value>select * from users</value> </resourceProperty> <resourceProperty name="PROP_QUERY_LANGUAGE"> <value>sql</value> </resourceProperty> <resourceProperty name="PROP_PARENT_FOLDER"> <value>/ReportingSystem/MyReports/JX_files</value> </resourceProperty> <resourceDescriptor name="" wsType="datasource" uriString="" isNew="false"> <label>null</label> <resourceProperty name="PROP_REFERENCE_URI"> <value>/ReportingSystem/MyReports/JX_files</value> </resourceProperty> <resourceProperty name="PROP_IS_REFERENCE"> <value>false</value> </resourceProperty> </resourceDescriptor> </resourceDescriptor> i try to do it but i stop at this one where i want to delegate resourceDescriptor to an other resourceDescriptor there are no methode to do it !!!!!!!!!!!!!!!!!!!!! my code java is : public ResourceDescriptor put ()throws Exception { ResourceDescriptor rd = new ResourceDescriptor(); rd.setWsType(ResourceDescriptor.TYPE_QUERY); rd.setResourceType(ResourceDescriptor.TYPE_QUERY); rd.setName("QR"); rd.setLabel("QRlabel"); rd.setResourceProperty(new ResourceProperty(ResourceDescriptor.PROP_QUERY,"select * from users")); rd.setResourceProperty(new ResourceProperty(ResourceDescriptor.PROP_QUERY_LANGUAGE,"sql")); rd.setParentFolder("/ReportingSystem/MyReports/JX_files"); rd.setUriString(rd.getParentFolder() + "/" + rd.getName()); rd.setIsNew(true); /* then we declare a new resourceDescriptor() for datasource who exist in JasperServer and reference it to query ResourceDescriptor datasource = new ResourceDescriptor(); datasource.setDataSourceType(ResourceDescriptor.TYPE_DATASOURCE); datasource.setIsNew(false); datasource.setResourceProperty(new ResourceProperty(ResourceDescriptor.PROP_REFERENCE_URI,"/ReportingSystem/MyReports/JX_files")); the pb is here --> how to set this datasource ResourceDescriptor to rd ResourceDescriptor */ ResourceDescriptor result = server.getWSClient().addOrModifyResource(rd, null); return result; } please help me !!!!!!!

thanks for reply ok, but i have a dynamic query in my java code and when i execute the report he don't this query (note:i have delete the query in jrxml report), where is the problem my code is : public JasperPrint runReport(String reportUri, String query, Map _parameters) throws Exception { ResourceDescriptor rd = new ResourceDescriptor(); rd.setWsType( ResourceDescriptor.TYPE_TYPE_JRXML); rd.setUriString("/ContentFiles/jrxml/rapport_exemple"); rd.setDriverClass("com.sybase.jdbc2.jdbc.SybDriver"); rd.setConnectionUrl("jdbc:sybase:Tds:192.168.0.5:2500/MyDataBase"); rd.setUsername("alizedbo"); rd.setPassword("xxxxxx"); ResourceProperty rp = new ResourceProperty(ResourceDescriptor.PROP_QUERY); rp.setValue( " SELECT "khsam" name, phone_office, billing_address_city,billing_address_street," +" billing_address_country" +" FROM accounts " +" ORDER BY billing_address_country, billing_address_city"); rd.setResourceProperty(rp); ResourceProperty rp1 = new ResourceProperty(ResourceDescriptor.PROP_QUERY_LANGUAGE); rp1.setName(ResourceDescriptor.PROP_QUERY_LANGUAGE); rp1.setValue("sql"); rd.setResourceProperty(rp1); return server.getWSClient().runReport(rd, _parameters); }

hi i developp a client webWervices in java , my question is : can i execute a jrxml(rapport_exemple) but not a reportUnit that i specifi a data source and dynamic sql_query ? i tru to do it but i have an exception like " /ContentFiles/jrxml/rapport_exemple is not a valid report" public JasperPrint runReport(String reportUri, String query, Map _parameters) throws Exception { reportUri = " /ContentFiles/jrxml/rapport_exemple" ResourceDescriptor rd = new ResourceDescriptor(); rd.setWsType( ResourceDescriptor.TYPE_TYPE_JRXML); rd.setUriString(reportUri); rd.setDriverClass("com.sybase.jdbc2.jdbc.SybDriver"); rd.setConnectionUrl("jdbc:sybase:Tds:192.168.0.5:2500/MyDataBase"); rd.setUsername("alizedbo"); rd.setPassword("xxxxxx"); ResourceProperty rp = new ResourceProperty(ResourceDescriptor.PROP_QUERY); rp.setValue( " SELECT "samir" name, phone_office, billing_address_city,billing_address_street," +" billing_address_country" +" FROM accounts " +" ORDER BY billing_address_country, billing_address_city"); rd.setResourceProperty(rp); ResourceProperty rp1 = new ResourceProperty(ResourceDescriptor.PROP_QUERY_LANGUAGE); rp1.setName(ResourceDescriptor.PROP_QUERY_LANGUAGE); rp1.setValue("sql"); rd.setResourceProperty(rp1); return server.getWSClient().runReport(rd, _parameters); } there is a stacktrace: thanks Code:java.lang.Exception: 2 - /ContentFiles/jrxml/rapport_exemple is not a valid report at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:382) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:299) at com.elis.alize.dashboard.support.jasperserver.WSClient.runReport(WSClient.java:99) at com.elis.alize.dashboard.support.jasperserver.BaseAbstractJasperServerReport.jgenerate(BaseAbstractJasperServerReport.java:90) at java.lang.reflect.Method.invoke(Native Method) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy195.jgenerate(Unknown Source) at com.elis.alize.struts.dashboard.support.DashboardAction.onGenerate(DashboardAction.java:181) at com.elis.alize.struts.dashboard.support.DashboardAction.onExecute(DashboardAction.java:113) at com.elis.alize.struts.support.BaseAlizeAction.execute(BaseAlizeAction.java:286) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:198) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:138) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2459) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:132) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:126) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:479)

hi i developp a client webWervices , but my question is : can i execute a jrxml but not a report ? because when i do it , i have an exception like " /ContentFiles/jrxml/rapport_exemple is not a valid report" there is a stacktrace: java.lang.Exception: 2 - /ContentFiles/jrxml/rapport_exemple is not a valid report at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:382) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:299) at com.elis.alize.dashboard.support.jasperserver.WSClient.runReport(WSClient.java:99) at com.elis.alize.dashboard.support.jasperserver.BaseAbstractJasperServerReport.jgenerate(BaseAbstractJasperServerReport.java:90) at java.lang.reflect.Method.invoke(Native Method) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:292) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:155) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174) at $Proxy195.jgenerate(Unknown Source) at com.elis.alize.struts.dashboard.support.DashboardAction.onGenerate(DashboardAction.java:181) at com.elis.alize.struts.dashboard.support.DashboardAction.onExecute(DashboardAction.java:113) at com.elis.alize.struts.support.BaseAlizeAction.execute(BaseAlizeAction.java:286) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:716) at javax.servlet.http.HttpServlet.service(HttpServlet.java:809) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:198) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:138) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2459) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:132) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:126) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:479) thanks