Sybase ASA as Repository DB

adrenlinerush · June 16, 2009

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}

adrenlinerush · June 17, 2009

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>

adrenlinerush · June 23, 2009

ASA has a funky way to define the in the connection string...

metadata.jdbc.url=jdbc:sybase:Tds:lando:2638?ServiceName=jasperserver

adrenlinerush · June 23, 2009

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

adrenlinerush · June 23, 2009

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.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