Problem while setting up JasperReports server with Oracle DB

Posted on March 25, 2013 at 2:18pm

I am setting up JasperReports server manually with Oracle DB and Apache Tomcat 7 application server.

As mentioned in JasperReports-Server-CP-Install-Guide.pdf (chapter # 5.6 - Install the WAR file manually), when I tried to run ant target "js-ant import-minimal-ce", it throws ClassNotFoundException. Here is the stacktrace.

[java] org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in file [/Users/org.springframework.beans.factory.BeanCreationException: 
  Error creating bean with name 'sessionFactory' defined in file [/Users/chetan/softwares/jasperreports-server-cp-5.0.0-bin/buildomatic/conf_source/ieCe/applicationContext.xml]: 
  Invocation of init methchetan/softwares/jasperreports-server-cp-5.0.0-bin/buildomatic/conf_source/ieCe/applicationContext.xml]: 
  Invocation of init method failed; nested exception is org.hibernate.HibernateException: Dialect class not found: com.jaspersoft.ji.hibernate.dialect.Orod failed; nested exception is org.hibernate.HibernateException: Dialect class not found: com.jaspersoft.ji.hibernate.dialect.OracleJICustomDialect
     [java]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1455)
     [java]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
     [java]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
     [java]  at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
     [java]  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaulacleJICustomDialect
     [java] tSingletonBeanRegistry.java:225)
     [java]  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
     [java]  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
     [java]  at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:567)
     [java]  at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
     [java]  at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
     [java]  at com.jaspersoft.jasperserver.export.BaseExportImportCommand.createSpringContext(BaseExportImportCommand.java:129)
     [java]  at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:82)
     [java]  at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43)
     [java] Caused by: org.hibernate.HibernateException: Dialect class not found: com.jaspersoft.ji.hibernate.dialect.OracleJICustomDialect
     [java]  at org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:160)
     [java]  at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:100)
     [java]  at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:117)
     [java]  at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119)
     [java]  at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115)
     [java]  at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339)
     [java]  at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:860)
     [java]  at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:779)
     [java]  at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
     [java]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1514)
     [java]  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1452)
     [java]  ... 12 more
     [java] Caused by: java.lang.ClassNotFoundException: com.jaspersoft.ji.hibernate.dialect.OracleJICustomDialect
     [java]  at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
     [java]  at java.security.AccessController.doPrivileged(Native Method)
     [java]  at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
     [java]  at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
     [java]  at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
     [java]  at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
     [java]  at java.lang.Class.forName0(Native Method)
     [java]  at java.lang.Class.forName(Class.java:171)
     [java]  at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:192)
     [java]  at org.hibernate.dialect.resolver.DialectFactory.constructDialect(DialectFactory.java:157)
     [java]  ... 22 more
Am I missing any step or do I need to specify any jar file in the classpath or something else?
Thanks.
JasperReports® Server
chetansoni's picture
chetansoni
7
Joined: Mar 25 2013 - 2:12pm
Last seen: 10 years 1 day ago

Hi,

I'm having a similar issue, any news?

 

We are using the 5.2CE edition.

We are trying to connect to AWS RDS 11g as the jasperserver database.

AndreC - 9 years 1 month ago
add comment

0 Answers:

No answers yet
Feedback