adrenlinerush

It was very neccessarry... while we do have a mysql server in production it will be going away... the rails applications running on it have already been tested on sybase and rake flawlessly moves them over... first we have a limited amount of resources and the overhead of running another sql server is taking resources that are not needed... as I said in another thread when asked the same question, I am very picky about what Install and how on my gentoo servers... secondly we are using jasper server for reporting on our custom accounting/inventory/production tracking/shipping system... first iteration we'll probably just embed the application pretty much as is into our app, however on the second iteration we'll probably change the servlet completely to use blazeds/amf so we can create our own frontend that is actually part of our application(our application is written with sybase java and flex)... when we do that I know our dba will want to change the schema to fit our db schema and probably share tables with our application configuration tables, so making it talk to sybase was the first step and allowed me to see how your application is put together... i haven't used maven before so it gave me a chance to dig through that a little bit too... of course in accordance with open source... anything I do based on someone elses work I release under gpl giving reference and credit to the person's work that was used... kind of off topic my new favorite place to publish my open source stuff is on git hub so if and when we get that far it'll be published on there...

Yep, found that and converted the script... got on here to post that I got it resolved and finally get a reply after I get it running... go figure... Anyway here is the final ASA quartz script that works and the default security script for asa... hopefully somoneone benefits from this thread....

ok i can get to the login in screen now but it doesn't login... no soup for you... com.jaspersoft.jasperserver.api.JSException: Tenant not found with Tenant ID "organizations"

ok... dba screwed up the quartz script... will update status once its fixed

does anybody know where the quartz objects get there binding from? when i run mvn clean install from build_db it loads the quartz tables into the db ... so why can't it find it? shouldn't it use those bindings to create the war build?

found the problem... gentoo doesn't build tomcat-dbcp.jar in thier ebuild due to the fact that this is just commoms-dbcp.jar refactored hence the lib is there just a different classpath... os i downloaded vanilla source recompiled but did not install just copied the jar I needed into the tomcat lib dir which on a gentoo system is /usr/share/tomcat-6/lib really you could just download the bin and copy the file... its a jar so java doesn't care where it came from just needs to be in the classpath... New issue: can't find the quartz stuff... my dba made all the fields lowercase not sure if the db is case sensitive thats the first thing to try... Log now looks like this.... well starts anyway... Jun 26, 2009 7:08:09 PM org.apache.catalina.core.ApplicationContext log INFO: Set web app root system property: 'jasperserver.root' = [/var/lib/tomcat-6/webapps/jasperserver/] Jun 26, 2009 7:08:09 PM org.apache.catalina.core.ApplicationContext log INFO: Initializing Log4J from [/var/lib/tomcat-6/webapps/jasperserver/WEB-INF/log4j.properties] Jun 26, 2009 7:08:09 PM org.apache.catalina.core.ApplicationContext log INFO: Loading Spring root WebApplicationContext Jun 26, 2009 7:08:17 PM org.apache.catalina.core.StandardContext listenerStart 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: SQL Anywhere Error -141: Table 'QRTZ_LOCKS' not found [see nested exception: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -141: Table 'QRTZ_LOCKS' not found]]

So I'm still getting this error: [Root exception is java.lang.ClassNotFoundException: org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory] Looks to be due to naming-factory-dbcp.jar Which is supposed to be part of tomcat... i haven't modified the gentoo tomcat ebuild other than changing the port that it runs on so what the hell... is the problem related to tomcat? or is jasper looking in the wrong place due to gentoo putting libs in different locations than tomcat source builds?

I had my DBA convert the ASE Sybase script to ASA... thought I would post that....

probably wouldn't have anything to do with 32 or 64 bit at this point because it would attempt to run and say wrong arch not say that bash can't find the file which is usually the error i get when its not executable... another thing you could try is an absolute path... in the dir where the file is use "pwd" to get the path to the dir ie: print working directory and then cut and past that and the file name ... ie at the promt get something like "sudo /home/user/jasper.bin" and see if it finds it with the absolute path

try promt # chmod 755 jasperserver-3.5.0-linux-installer.bin or sudo chmod 755 ...

Went to run this thing finally... getting errors... Running Tomcat 6 basically standard ebuild on gentoo-sources kernel 2.6.28-r5... only thing I changed from the standard ebuild is the port from 8080 to 8001 Hope somebody has some ideas.... here is the tomcat log... Jun 23, 2009 6:02:25 PM org.apache.catalina.core.ApplicationContext log INFO: Set web app root system property: 'jasperserver.root' = [/var/lib/tomcat-6/webapps/jasperserver/] Jun 23, 2009 6:02:25 PM org.apache.catalina.core.ApplicationContext log INFO: Initializing Log4J from [/var/lib/tomcat-6/webapps/jasperserver/WEB-INF/log4j.properties] Jun 23, 2009 6:02:25 PM org.apache.catalina.core.ApplicationContext log INFO: Loading Spring root WebApplicationContext Jun 23, 2009 6:02:27 PM org.apache.catalina.core.StandardContext listenerStart 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 'sessionFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext-datasource.xml]: Invocation of init method failed; nested exception is javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.ClassNotFoundException: org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext-datasource.xml]: Invocation of init method failed; nested exception is javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.ClassNotFoundException: org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory] Caused by: javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.ClassNotFoundException: org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory] at org.apache.naming.factory.ResourceFactory.getObjectInstance(Unknown Source) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.SelectorContext.lookup(Unknown Source) at javax.naming.InitialContext.lookup(InitialContext.java:392) at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:124) at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:86) at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:122) at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:147) at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:91) at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:101) at org.springframework.jndi.JndiObjectFactoryBean.lookupWithFallback(JndiObjectFactoryBean.java:164) at org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:151) 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.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(Unknown Source) at org.apache.catalina.core.StandardContext.start(Unknown Source) at org.apache.catalina.core.ContainerBase.addChildInternal(Unknown Source) at org.apache.catalina.core.ContainerBase.addChild(Unknown Source) at org.apache.catalina.core.StandardHost.addChild(Unknown Source) at org.apache.catalina.startup.HostConfig.deployDirectory(Unknown Source) at org.apache.catalina.startup.HostConfig.deployDirectories(Unknown Source) at org.apache.catalina.startup.HostConfig.deployApps(Unknown Source) at org.apache.catalina.startup.HostConfig.start(Unknown Source) at org.apache.catalina.startup.HostConfig.lifecycleEvent(Unknown Source) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Unknown Source) at org.apache.catalina.core.ContainerBase.start(Unknown Source) at org.apache.catalina.core.StandardHost.start(Unknown Source) at org.apache.catalina.core.ContainerBase.start(Unknown Source) at org.apache.catalina.core.StandardEngine.start(Unknown Source) at org.apache.catalina.core.StandardService.start(Unknown Source) at org.apache.catalina.core.StandardServer.start(Unknown Source) at org.apache.catalina.startup.Catalina.start(Unknown Source) 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(Unknown Source) at org.apache.catalina.startup.Bootstrap.main(Unknown Source) Caused by: java.lang.ClassNotFoundException: org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at java.lang.ClassLoader.loadClass(ClassLoader.java:252) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:169) ... 66 more Jun 23, 2009 6:02:27 PM org.apache.catalina.core.StandardContext listenerStart SEVERE: Exception sending context initialized event to listener instance of class com.jaspersoft.jasperserver.war.util.SpringBeanServletContextPlublisher org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext-datasource.xml]: Invocation of init method failed; nested exception is javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.ClassNotFoundException: org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory] Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext-datasource.xml]: Invocation of init method failed; nested exception is javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.ClassNotFoundException: org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory] Caused by: javax.naming.NamingException: Could not create resource factory instance [Root exception is java.lang.ClassNotFoundException: org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory] at org.apache.naming.factory.ResourceFactory.getObjectInstance(Unknown Source) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:304) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.NamingContext.lookup(Unknown Source) at org.apache.naming.SelectorContext.lookup(Unknown Source) at javax.naming.InitialContext.lookup(InitialContext.java:392) at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:124) at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:86) at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:122) at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:147) at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:91) at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:101) at org.springframework.jndi.JndiObjectFactoryBean.lookupWithFallback(JndiObjectFactoryBean.java:164) at org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:151) 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.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(Unknown Source) at org.apache.catalina.core.StandardContext.start(Unknown Source) at org.apache.catalina.core.ContainerBase.addChildInternal(Unknown Source) at org.apache.catalina.core.ContainerBase.addChild(Unknown Source) at org.apache.catalina.core.StandardHost.addChild(Unknown Source) at org.apache.catalina.startup.HostConfig.deployDirectory(Unknown Source) at org.apache.catalina.startup.HostConfig.deployDirectories(Unknown Source) at org.apache.catalina.startup.HostConfig.deployApps(Unknown Source) at org.apache.catalina.startup.HostConfig.start(Unknown Source) at org.apache.catalina.startup.HostConfig.lifecycleEvent(Unknown Source) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Unknown Source) at org.apache.catalina.core.ContainerBase.start(Unknown Source) at org.apache.catalina.core.StandardHost.start(Unknown Source) at org.apache.catalina.core.ContainerBase.start(Unknown Source) at org.apache.catalina.core.StandardEngine.start(Unknown Source) at org.apache.catalina.core.StandardService.start(Unknown Source) at org.apache.catalina.core.StandardServer.start(Unknown Source) at org.apache.catalina.startup.Catalina.start(Unknown Source) 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(Unknown Source) at org.apache.catalina.startup.Bootstrap.main(Unknown Source) Caused by: java.lang.ClassNotFoundException: org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at java.lang.ClassLoader.loadClass(ClassLoader.java:252) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:169) ... 66 more Jun 23, 2009 6:02:27 PM org.apache.catalina.core.ApplicationContext log INFO: Closing Spring root WebApplicationContext Jun 23, 2009 6:02:27 PM org.apache.catalina.core.ApplicationContext log INFO: Shutting down Log4J

Does anybody know if the standard sql delegate will work with ASA for quartz?

ASA has a funky way to define the in the connection string... metadata.jdbc.url=jdbc:sybase:Tds:lando:2638?ServiceName=jasperserver

Wow ... over 24 hrs and no repsonses and only 9 views... i'm not impressed with this forum... I have made progress though... I found the references an the three hibernate mapping files made the changes noted below this fixed the db build for the main repository tables that had keywords as references... will attept to convert the quartz file and fix the named db issue still would like some help if anybody has any ideas... Code:~/jasperserver-3.5.0-src/jasperserver/jasperserver-repository-hibernate/src/main/resources/com/jaspersoft/jasperserver/api/metadata/common/service/impl/hibernate/persistent/RepoFileResource.hbm.xml added _ to column reference<?xml version="1.0" encoding="ISO-8859-1"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping> <joined-subclass name="com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource" extends="com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource" table="JIFileResource"> <key column="id"/> <property name="data" type="com.jaspersoft.hibernate.ByteWrappingBlobType" length="20971520" column="data"/> <property name="fileType" length="20" type="string" column="file_type"/> <many-to-one column="reference_" name="reference" class="com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource"/> </joined-subclass></hibernate-mapping>~/jasperserver-3.5.0-src/jasperserver/jasperserver-repository-hibernate/src/main/resources/com/jaspersoft/jasperserver/api/engine/scheduling/hibernate/PersistentReportJobMailNotification.hbm.xmladded _ to column message<?xml version="1.0" encoding="ISO-8859-1"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping> <class table="JIReportJobMail" name="com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobMailNotification"> <id name="id" type="long" > <generator class="native"/> </id> <version column="version" unsaved-value="negative" name="version"/> <property name="subject" column="subject" type="string" length="100" not-null="true"/> <property name="messageText" column="message_" type="string" length="2000" not-null="false"/> <property name="resultSendType" column="send_type" type="byte" not-null="true"/> <property name="skipEmptyReports" column="skip_empty" type="boolean" not-null="true"/> <list name="recipients" table="JIReportJobMailRecipient"> <key column="destination_id"/> <list-index column="recipient_idx"/> <composite-element class="com.jaspersoft.jasperserver.api.engine.scheduling.hibernate.PersistentReportJobMailRecipient"> <property name="type" column="recipient_type" type="byte" not-null="true"/> <property name="address" column="address" type="string" length="100" not-null="true"/> </composite-element> </list> </class></hibernate-mapping>~/jasperserver-3.5.0-src/jasperserver/jasperserver-repository-hibernate/src/main/resources/com/jaspersoft/jasperserver/api/common/domain/impladded _ to column message<?xml version="1.0" encoding="ISO-8859-1"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping> <class table="JILogEvent" name="com.jaspersoft.jasperserver.api.common.domain.impl.RepoLogEvent"> <id name="id" type="long" unsaved-value="0"> <generator class="native"/> </id> <property name="occurrenceDate" column="occurrence_date" type="timestamp" not-null="true"/> <property name="type" column="event_type" type="byte" not-null="true"/> <property name="component" column="component" type="string" length="100"/> <property name="messageCode" column="message_" type="string" length="250" not-null="true"/> <property name="resourceURI" column="resource_uri" type="string" length="250"/> <property name="text" column="event_text" type="text" length="400000"/> <property name="dataBlob" column="event_data" type="com.jaspersoft.hibernate.ByteWrappingBlobType" length="1048576"/> <property name="state" column="event_state" type="byte"/> <many-to-one name="user" column="userId" class="com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoUser"/> </class></hibernate-mapping>

I'm trying to get sybase ASA to work as the repository DB... there are a few Issues that i've found... The main db has field names that are reserved words: reference and message So when I run the script it generates these errors... [hibernatetool] 11 errors occurred while performing <hbm2ddl>. [hibernatetool] Error #1: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -131: Syntax error near 'reference' on line 1 [hibernatetool] Error #1: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -131: Syntax error near 'message' on line 1 [hibernatetool] Error #1: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -131: Syntax error near 'message' on line 1 [hibernatetool] Error #1: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -141: Table 'JIFileResource' not found [hibernatetool] Error #1: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -131: Syntax error near 'reference' on line 1 [hibernatetool] Error #1: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -141: Table 'JILogEvent' not found [hibernatetool] Error #1: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -141: Table 'JIFileResource' not found [hibernatetool] Error #1: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -141: Table 'JIReportJobMail' not found [hibernatetool] Error #1: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -141: Table 'JIReportJobMail' not found [hibernatetool] Error #1: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -141: Table 'JIFileResource' not found [hibernatetool] Error #1: com.sybase.jdbc3.jdbc.SybSQLException: SQL Anywhere Error -141: Table 'JIFileResource' not found I need to know where I can change this at... is there a central schema xml somewhere or are the fields hardcoded throughout the application? The quartz scripts that are included are for ASE not ASA... i can probably convert that using Power Designer or some other utililty... Then the other issue is it uses the first database connecting... I have one sybase engine running as a service on gentoo linux, and two databases on the engine as named db's... attached is my maven confiurations it keeps trying to talk to corpsys db and not jasper server... here is the runscript controlling the db's so you can see my config Any ideas and help would be much apreciated Code:#!/sbin/runscriptstart() { source /etc/profile ebegin "Starting Sybase SQL Anywhere" start-stop-daemon --start --chuid sybase --exec /opt/sqlanywhere11/bin64/dbsrv11 \ --pidfile /var/run/asa.pid --make-pidfile --background \ -- -n Yoda -qw /var/data/asa/corp/cshq0a.db -n corpsys /var/data/asa/bi/jasperserver.db -n jasperserver eend $? "Failed to start SQL Anywhere."}stop() { source /etc/profile ebegin "Stopping Sybase SQL Anywhere" start-stop-daemon --stop --user sybase --exec /opt/sqlanywhere11/bin64/dbstop \ --pidfile /var/run/asa.pid -- -c "ENG=Yoda;UID=DBA;PWD=sql" eend $? "Failed to stop SQL Anywhere."}restart() { stop sleep 3 # Wait 3 seconds before starting again start}