Problem while setting up JasperReports server with Oracle DB

[chetansoni]

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.

[AndreC]

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.