Problem in starting jasperserver

[Mohan]

Hi,

 

I have a problem in starting the jasperserver. When I run tomcat, I am getting the following erorr:

 

Oct 18, 2006 6:17:44 PM org.apache.catalina.startup.ContextConfig applicationConfig

INFO: Missing application web.xml, using defaults only StandardEngine[Catalina].StandardHost[localhost].Standa

rdContext[/]

Oct 18, 2006 6:17:44 PM org.apache.catalina.core.StandardHostDeployer install

INFO: Processing Context configuration file URL file:D:sigmaTomcat 5.0confCatalinalocalhostjasperserver.

xml

18:17:54,140 WARN JDBCExceptionReporter,main:71 - SQL Error: 0, SQLState: null

18:17:54,156 ERROR JDBCExceptionReporter,main:72 - Cannot create JDBC driver of class '' for connect URL 'null

'

18:17:54,171 WARN SettingsFactory,main:103 - Could not obtain connection metadata

org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)

at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceC

onnectionProvider.java:81)

at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)

at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBea

n.java:885)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBe

an.java:797)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(Abst

ractAutowireCapableBeanFactory.java:860)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(Abstrac

tAutowireCapableBeanFactory.java:829)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAut

owireCapableBeanFactory.java:409)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:238)

 

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:148)

 

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(Defau

ltListableBeanFactory.java:247)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.j

ava:331)

at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRe

freshableWebApplicationContext.java:155)

at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:240)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:178)

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:4343)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:823)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:807)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:595)

at org.apache.catalina.core.StandardHostDeployer.addChild(StandardHostDeployer.java:903)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

 

Can anyone please help me?

 

 

Thanks in advance,

Mohan.

[lucianc]

What Tomcat version do you use?

 

Regards,

Lucian

[rhancke]

Hi Mohan.

 

You need to follow some configurations:

- Use Tomcat 5.5.x

- Copy the mysql connector jar to <tomcat install>commonlib

- Configure resource-ref in web.xml

- Configure resource in context.xml

 

[]'s

RHancke

[sfratini]

hello look at this, maybe could help you

 

http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=10&id=16718#16718

 

[Mohan]

Currently I am using Tomcat5.0. Do I need to have higher version to make JasperIntelligence work?

Post edited by: mudradi.mohan, at: 2006/10/19 06:44

[Mohan]

I am using Tomcat 5.0. Do I need to have higher version?

 

Regards,

Mohan.

 

lucianc wrote:

What Tomcat version do you use? Regards, Lucian

[lucianc]

You'll need to adapt the web app context.xml file to use the Tomcat 5.0 syntax (JasperServer ships with a Tomcat 5.5 context.xml).

 

You have to change the data source definitions to something like

Code:

<Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"/> 

<ResourceParams name="jdbc/jasperserver"> 
  <parameter> 
    <name>maxActive</name> 
    <value>100</value> 
  </parameter> 
  <parameter> 
    <name>maxIdle</name> 
    <value>30</value> 
  </parameter> 
  <parameter> 
    <name>maxWait</name> 
    <value>10000</value> 
  </parameter> 
  <parameter> 
    <name>username</name> 
    <value>jasperadmin</value> 
  </parameter> 
  <parameter> 
    <name>password</name> 
    <value>jasperadmin</value> 
  </parameter> 
  <parameter> 
    <name>driverClassName</name> 
    <value>com.mysql.jdbc.Driver</value> 
  </parameter> 
  <parameter> 
    <name>url</name> 
    <value>jdbc:mysql://IP address of the machine:3306/jasperserver?autoReconnect=true</value> 
  </parameter> 
</ResourceParams> 

 

HTH,

Lucian

[Mohan]

Hi RHancket,

 

Thanks for the suggestion. It works. I downloaded Tomcat 5.5 and it worked. But I am not able to find 'flow.html'. Can you please let me know how do I configure JasperIntelligence to work with Jasper Reports? I have jasperreports-1.2.7 and jasperintelligence-ireport-plugin-1.1.0. Can you please tell me how do I configure this so that I can start work on reports.

 

Thank you once again,

Mohan.

 

rhancke wrote:

Hi Mohan. You need to follow some configurations: - Use Tomcat 5.5.x - Copy the mysql connector jar to <tomcat install>commonlib - Configure resource-ref in web.xml - Configure resource in context.xml []'s RHancke

[Mohan]

Hello LucianC,

 

Now I am getting the login screen of JasperIntelligence. Thank you so much for your guidance. I modified the "ResourceParams...> code as you specified. It is working now.

 

Thank you once again,

Mohan.

 

lucianc wrote:

You'll need to adapt the web app context.xml file to use the Tomcat 5.0 syntax (JasperServer ships with a Tomcat 5.5 context.xml). You have to change the data source definitions to something like Code: <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/jasperserver"> <parameter> <name>maxActive</name> <value>100</value> </parameter> <parameter> <name>maxIdle</name> <value>30</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>username</name> <value>jasperadmin</value> </parameter> <parameter> <name>password</name> <value>jasperadmin</value> </parameter> <parameter> <name>driverClassName</name> <value>com.mysql.jdbc.Driver</value> </parameter> <parameter> <name>url</name> <value>jdbc:mysql://IP address of the machine:3306/jasperserver?autoReconnect=true</value> </parameter> </ResourceParams>   HTH, Lucian

[HBK32]

lucianc wrote:

What Tomcat version do you use? Regards, Lucian

 

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.0webappsjasperserverMETA-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:

20:49:26,191 ERROR ContextLoader,main:205 - Context initialization failed
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
Caused by: 
java.lang.NoClassDefFoundError: java/lang/Enum
	at java.lang.Class.getDeclaredConstructors0(Native Method)
	at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618)
	at java.lang.Class.getConstructor0(Class.java:1930)
	at java.lang.Class.getDeclaredConstructor(Class.java:1301)
	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60)
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388)
	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:3618)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586)
	at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420)
	at org.apache.catalina.core.StandardService.start(StandardService.java:450)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:545)
	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:324)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
20:49:26,201 ERROR [/jasperserver],main:662 - 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 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum
Caused by: 
java.lang.NoClassDefFoundError: java/lang/Enum
	at java.lang.Class.getDeclaredConstructors0(Native Method)
	at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618)
	at java.lang.Class.getConstructor0(Class.java:1930)
	at java.lang.Class.getDeclaredConstructor(Class.java:1301)
	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60)
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388)
	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:3618)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586)
	at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420)
	at org.apache.catalina.core.StandardService.start(StandardService.java:450)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:545)
	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:324)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
20:49:26,231 ERROR [/jasperserver],main:662 - 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 'olapConnectionService' defined in ServletContext resource [/WEB-INF/applicationContext-olap-connection.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: java/lang/Enum
Caused by: 
java.lang.NoClassDefFoundError: java/lang/Enum
	at java.lang.Class.getDeclaredConstructors0(Native Method)
	at java.lang.Class.privateGetDeclaredConstructors(Class.java:1618)
	at java.lang.Class.getConstructor0(Class.java:1930)
	at java.lang.Class.getDeclaredConstructor(Class.java:1301)
	at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:60)
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:45)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:701)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:687)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:388)
	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:3618)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4095)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:755)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:586)
	at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1063)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1011)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1003)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:420)
	at org.apache.catalina.core.StandardService.start(StandardService.java:450)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:1967)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:545)
	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:324)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)

 

Can you plz help me with this?

 

I will really appreciate yr response.

 

Plz reply me ASAP.

 

Thanks in advance.

[HBK]

lucianc wrote:

What Tomcat version do you use? Regards, Lucian

 

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.

[HBK]

rhancke wrote:

Hi Mohan. You need to follow some configurations: - Use Tomcat 5.5.x - Copy the mysql connector jar to <tomcat install>commonlib - Configure resource-ref in web.xml - Configure resource in context.xml []'s RHancke

 

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.