I'm stuck trying to get JasperServer to work on Linux using Oracle for the data source. Here's what I've done so far:
Installed JS2.01 on the server and unpacked the WAR file, then renamed the WAR file so it doesn't get unpacked again.
Made sure that ojdbc14.jar was in the lib directory.
Modified META-INF/context.xml so that the resources point at Oracle instead of MySQL. The resource definitions were changed to Tomcat 5.0 format (refer to http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&f...).
Modified hibernate.properties to use Oracle9Dialect instead of MySQLInnoDBDialect
Made sure that context.xml is copied to jasperserver.xml.
Created database schema, created tables, and added some base user data/roles/etc.
Jasperserver starts without error (finally!!) and I can get the login page up, but now I can't login. Fails with Oracle "Table or view does not exist" error, as if it's pointing in the wrong place. Unfortunately the error logging is pathetically ameteurish and doesn't specify the name of the offending table or view.
Any ideas on what the problem might be?
.
Post edited by: jmurray, at: 2007/10/09 05:27
Jasperserver starts without error (finally!!) and I can get the login page up, but now I can't login. Fails with Oracle "Table or view does not exist" error, as if it's pointing in the wrong place. Unfortunately the error logging is pathetically ameteurish and doesn't specify the name of the offending table or view.
Any ideas on what the problem might be?
.
Post edited by: jmurray, at: 2007/10/09 05:27
11 Answers:
Posted on October 9, 2007 at 4:02am
The templates in the attached Oracle for JasperServer 2.0.1 patch should get you out of trouble if you are having trouble finding all the information in one place, or if you are getting errors containing "URL=NULL or URL=''", "table or view not found" errors, or other Oracle errors.
[file name=OraclePatchforJS201-c047792c207b836239bd2625b949dac0.zip size=10191]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Ora...
.
Post edited by: jmurray, at: 2007/10/09 05:26
[file name=OraclePatchforJS201-c047792c207b836239bd2625b949dac0.zip size=10191]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/Ora...
.
Post edited by: jmurray, at: 2007/10/09 05:26
Posted on October 9, 2007 at 11:44pm
The following INSERT statements need to be issued to allow the repository manager to function correctly:
| Code: |
Insert into JIOBJECTPERMISSION (ID, URI, RECIPIENTOBJECTCLASS, RECIPIENTOBJECTID, PERMISSIONMASK)<br /> Values (1, 'repo:/', 'com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole', 2, 1);<br /> Insert into JIOBJECTPERMISSION (ID, URI, RECIPIENTOBJECTCLASS, RECIPIENTOBJECTID, PERMISSIONMASK)<br /> Values (2, 'repo:/', 'com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole', 1, 2);<br /> <br /> <br /> Insert into JIRESOURCEFOLDER (ID, VERSION, URI, HIDDEN, NAME, LABEL, DESCRIPTION, PARENT_FOLDER, CREATION_DATE)<br /> Values (1, 0, '/', 0, '/', 'root', 'Root of the folder hierarchy', NULL, SYSDATE);<br /> <br /> <br /> COMMIT;</td></tr></tbody></table><br /> <br /> <br /> .<br>Post edited by: jmurray, at: 2007/10/09 23:46 |
Posted on June 17, 2008 at 1:10am
jmurray wrote:
Hell0,
I have installed jasperserver 2.1 on tomcat 5.5 using WAR file.
I am using following component.
1. j2sdk1.4.2_05
2. Tomcat 5.5
3. MySQL 5.0
4. JasperServer 2.1
I have changed context.xml(C:\jakarta-tomcat-5.5.0\webapps\jasperserver\META-INF)
Also changed jasperserver.xml(same as context.xml)
Also made required changes in hibernate.properties(as per installation guide)
When I am starting tomact using startup.bat at that time getting following error.(jasperserver.log)
Following is the error description.
| I'm stuck trying to get JasperServer to work on Linux using Oracle for the data source. Here's what I've done so far: Jasperserver starts without error (finally!!) and I can get the login page up, but now I can't login. Fails with Oracle "Table or view does not exist" error, as if it's pointing in the wrong place. Unfortunately the error logging is pathetically ameteurish and doesn't specify the name of the offending table or view. Any ideas on what the problem might be? .<br><br>Post edited by: jmurray, at: 2007/10/09 05:27 |
Hell0,
I have installed jasperserver 2.1 on tomcat 5.5 using WAR file.
I am using following component.
1. j2sdk1.4.2_05
2. Tomcat 5.5
3. MySQL 5.0
4. JasperServer 2.1
I have changed context.xml(C:\jakarta-tomcat-5.5.0\webapps\jasperserver\META-INF)
Also changed jasperserver.xml(same as context.xml)
Also made required changes in hibernate.properties(as per installation guide)
When I am starting tomact using startup.bat at that time getting following error.(jasperserver.log)
Following is the error description.
| Code: |
<br /> 20:49:26,191 ERROR ContextLoader,main:205 - Context initialization failed<br /> org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum<br /> Caused by: <br /> java.lang.NoClassDefFoundError: java/lang/Enum<br /> at java.lang.Class.getDeclaredConstructors0(Native Method)<br /> at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618)<br /> at java.lang.Class.getConstructor0(Class.java:1930)<br /> at java.lang.Class.getDeclaredConstructor(Class.java:1301)<br /> at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60)<br /> at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45)<br /> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701)<br /> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687)<br /> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388)<br /> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250)<br /> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)<br /> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)<br /> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161)<br /> at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273)<br /> at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)<br /> at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)<br /> at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)<br /> at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)<br /> at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)<br /> at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618)<br /> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095)<br /> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755)<br /> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)<br /> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)<br /> at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586)<br /> at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)<br /> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)<br /> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063)<br /> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)<br /> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)<br /> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)<br /> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)<br /> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003)<br /> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420)<br /> at org.apache.catalina.core.StandardService.start(StandardService.java:450)<br /> at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967)<br /> at org.apache.catalina.startup.Catalina.start(Catalina.java:545)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br /> at java.lang.reflect.Method.invoke(Method.java:324)<br /> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)<br /> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)<br /> 20:49:26,201 ERROR [/jasperserver],main:662 - Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener<br /> org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum<br /> Caused by: <br /> java.lang.NoClassDefFoundError: java/lang/Enum<br /> at java.lang.Class.getDeclaredConstructors0(Native Method)<br /> at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618)<br /> at java.lang.Class.getConstructor0(Class.java:1930)<br /> at java.lang.Class.getDeclaredConstructor(Class.java:1301)<br /> at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60)<br /> at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45)<br /> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701)<br /> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687)<br /> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388)<br /> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250)<br /> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)<br /> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)<br /> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161)<br /> at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273)<br /> at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)<br /> at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)<br /> at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)<br /> at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)<br /> at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)<br /> at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618)<br /> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095)<br /> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755)<br /> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)<br /> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)<br /> at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586)<br /> at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)<br /> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)<br /> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063)<br /> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)<br /> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)<br /> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)<br /> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)<br /> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003)<br /> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420)<br /> at org.apache.catalina.core.StandardService.start(StandardService.java:450)<br /> at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967)<br /> at org.apache.catalina.startup.Catalina.start(Catalina.java:545)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br /> at java.lang.reflect.Method.invoke(Method.java:324)<br /> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)<br /> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)<br /> 20:49:26,231 ERROR [/jasperserver],main:662 - Exception sending context initialized event to listener instance of class com.jaspersoft.jasperserver.war.util.SpringBeanServletContextPlublisher<br /> org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum<br /> Caused by: <br /> java.lang.NoClassDefFoundError: java/lang/Enum<br /> at java.lang.Class.getDeclaredConstructors0(Native Method)<br /> at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618)<br /> at java.lang.Class.getConstructor0(Class.java:1930)<br /> at java.lang.Class.getDeclaredConstructor(Class.java:1301)<br /> at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60)<br /> at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45)<br /> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701)<br /> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687)<br /> at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388)<br /> at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250)<br /> at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)<br /> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)<br /> at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161)<br /> at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273)<br /> at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)<br /> at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)<br /> at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)<br /> at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)<br /> at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)<br /> at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3618)<br /> at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095)<br /> at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755)<br /> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)<br /> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)<br /> at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586)<br /> at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)<br /> at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)<br /> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063)<br /> at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)<br /> at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)<br /> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)<br /> at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)<br /> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003)<br /> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420)<br /> at org.apache.catalina.core.StandardService.start(StandardService.java:450)<br /> at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967)<br /> at org.apache.catalina.startup.Catalina.start(Catalina.java:545)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br /> at java.lang.reflect.Method.invoke(Method.java:324)<br /> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)<br /> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)<br /> </td></tr></tbody></table><br /> <br /> Can you plz help me with this?<br /> <br /> I will really appreciate yr response.<br /> <br /> <b>Plz reply me ASAP.</b><br /> <br /> Thanks in advance. |
Posted on June 18, 2008 at 12:56pm
jmurray wrote:
Hello,
Thanks a lot for your reply. I really appreciate it.
the problem which I described with error(java.lang.NoClassDefFoundError: java/lang/Enum) in my previous post is it because I am using JDK 1.4?
I am using Following components for installation.
1. j2sdk1.4.2_05
2. Tomcat 5.5
3. MySQL 5.0
4. JasperServer 2.1
Which version of jasperserver is compitable with j2sdk1.4.2_05?
As you already installed JS 2.1 with oracle than can you please tell me from where can I download WAR file of JasperServer for Websphere & Oracle installation?
I am going to use WebSphere 6.0.
Can you plz help me for this?
I will really appreciate your response.
Plz reply me ASAP.
Thanks in advance.
| Class is missing or cannot be found in your classpath. Check that your classpath is complete for all the libraries you wish to use. |
Hello,
Thanks a lot for your reply. I really appreciate it.
the problem which I described with error(java.lang.NoClassDefFoundError: java/lang/Enum) in my previous post is it because I am using JDK 1.4?
I am using Following components for installation.
1. j2sdk1.4.2_05
2. Tomcat 5.5
3. MySQL 5.0
4. JasperServer 2.1
Which version of jasperserver is compitable with j2sdk1.4.2_05?
As you already installed JS 2.1 with oracle than can you please tell me from where can I download WAR file of JasperServer for Websphere & Oracle installation?
I am going to use WebSphere 6.0.
Can you plz help me for this?
I will really appreciate your response.
Plz reply me ASAP.
Thanks in advance.
Posted on June 18, 2008 at 2:44pm
jmurray wrote:
Hello,
Which version of JasperServer is supported by j2sdk1.4.2_05/JDK 1.4?
In other words Does JasperSever work under j2sdk1.4.2_05/JDK 1.4?
As I have to use j2sdk1.4.2_05/JDK 1.4, so anyone can tell me that which version of JasperServer should I download & can work on j2sdk1.4.2_05/JDK 1.4?
I need help ASAP. Its urgent.
I will appreciate response.
Thanks.
| I'm stuck trying to get JasperServer to work on Linux using Oracle for the data source. Here's what I've done so far: Jasperserver starts without error (finally!!) and I can get the login page up, but now I can't login. Fails with Oracle "Table or view does not exist" error, as if it's pointing in the wrong place. Unfortunately the error logging is pathetically ameteurish and doesn't specify the name of the offending table or view. Any ideas on what the problem might be? .<br><br>Post edited by: jmurray, at: 2007/10/09 05:27 |
Hello,
Which version of JasperServer is supported by j2sdk1.4.2_05/JDK 1.4?
In other words Does JasperSever work under j2sdk1.4.2_05/JDK 1.4?
As I have to use j2sdk1.4.2_05/JDK 1.4, so anyone can tell me that which version of JasperServer should I download & can work on j2sdk1.4.2_05/JDK 1.4?
I need help ASAP. Its urgent.
I will appreciate response.
Thanks.
Posted on July 3, 2008 at 3:51am
It is definitely not from hibernate beans. I don't even know what they are :)
If you read the comments at the top of the ddl you'll see that it is adapted from the MySQL ddl script that is packaged with JasperServer. The original ddl had a few minor issues that caused major headaches, so they were fixed along the way.
As you can see from the post following the one with the Oracle patch in it there are still some data dependencies that need to be taken care of for everything to work.
Good luck.
If you read the comments at the top of the ddl you'll see that it is adapted from the MySQL ddl script that is packaged with JasperServer. The original ddl had a few minor issues that caused major headaches, so they were fixed along the way.
As you can see from the post following the one with the Oracle patch in it there are still some data dependencies that need to be taken care of for everything to work.
Good luck.
