export failed using js-export

[vpremkumar]

Hi all,

 

I get the following exception when I run

./js-export.sh --everything --output-dir /home/jasper/jasper_backup

DB used in oracle 10g

js.jdbc.properties

# below is property that determines the Hibernate dialect

#metadata.hibernate.dialect=org.hibernate.dialect.OracleUnicodeDialect ..both thse options gives the error
metadata.hibernate.dialect=org.hibernate.dialect.Oracle9Dialect

metadata.jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
metadata.jdbc.url=jdbc:oracle:thin:@aa.aa.a.aa:bbb:ppdrptqa
metadata.jdbc.username=username
metadata.jdbc.password=password
 

an some one please give some insight ?

 

Thanks,

Code:

13:56:27,193  WARN JDBCExceptionReporter:77 - SQL Error: 0, SQLState: null13:56:27,200 ERROR JDBCExceptionReporter:78 - Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1ORA-12705: Cannot access NLS data files or invalid environment specified)13:56:27,203  WARN SettingsFactory:109 - Could not obtain connection metadataorg.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1ORA-12705: Cannot access NLS data files or invalid environment specified)   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:855)   at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)   at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)   at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006)   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289)   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:804)   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:744)   at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131)   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.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.aop.framework.ProxyFactoryBean.initializeAdvisorChain(ProxyFactoryBean.java:438)   at org.springframework.aop.framework.ProxyFactoryBean.getObject(ProxyFactoryBean.java:251)   at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectFromFactoryBean(AbstractBeanFactory.java:1211)   at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1177)   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:261)   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:273)   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)   at com.jaspersoft.jasperserver.export.BaseExportImportCommand.createSpringContext(BaseExportImportCommand.java:116)   at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:76)   at com.jaspersoft.jasperserver.export.ExportCommand.main(ExportCommand.java:43)Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1ORA-12705: Cannot access NLS data files or invalid environment specified   at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)   at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)   at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:785)   at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362)   at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)   at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)   at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)   at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)   at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)   at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)   at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)   ...53 more13:56:27,763 ERROR BaseExportImportCommand:45 - org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportOptionsFacade' defined in class path resource [config/applicationContext-report-options.xml]: Cannot resolve reference to bean 'repositoryService' while setting bean property 'repository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repositoryService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepoServiceTransactionInterceptor' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.core.DebuggingClassWriter$1org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'reportOptionsFacade' defined in class path resource [config/applicationContext-report-options.xml]: Cannot resolve reference to bean 'repositoryService' while setting bean property 'repository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repositoryService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepoServiceTransactionInterceptor' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.core.DebuggingClassWriter$1Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repositoryService': FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepoServiceTransactionInterceptor' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.core.DebuggingClassWriter$1Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hibernateRepoServiceTransactionInterceptor' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.core.DebuggingClassWriter$1Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [config/applicationContext-for-export.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.core.DebuggingClassWriter$1Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [config/applicationContext-for-export.xml]: Invocation of init method failed; nested exception is java.lang.NoClassDefFoundError: net.sf.cglib.core.DebuggingClassWriter$1Caused by: java.lang.NoClassDefFoundError: net.sf.cglib.core.DebuggingClassWriter$1   at java.lang.Class.initializeClass(libgcj.so.7rh)   at net.sf.cglib.core.DebuggingClassWriter.toByteArray(DebuggingClassWriter.java:73)   at net.sf.cglib.core.DefaultGeneratorStrategy.generate(DefaultGeneratorStrategy.java:26)   at net.sf.cglib.core.AbstractClassGenerator.create(AbstractClassGenerator.java:216)   at net.sf.cglib.core.KeyFactory$Generator.create(KeyFactory.java:145)   at net.sf.cglib.core.KeyFactory.create(KeyFactory.java:117)   at net.sf.cglib.core.KeyFactory.create(KeyFactory.java:108)   at net.sf.cglib.core.KeyFactory.create(KeyFactory.java:104)   at net.sf.cglib.proxy.Enhancer.<clinit>(Enhancer.java:69)   at java.lang.Class.initializeClass(libgcj.so.7rh)   at org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.getProxyFactory(CGLIBLazyInitializer.java:107)   at org.hibernate.proxy.pojo.cglib.CGLIBProxyFactory.postInstantiate(CGLIBProxyFactory.java:43)   at org.hibernate.tuple.entity.PojoEntityTuplizer.buildProxyFactory(PojoEntityTuplizer.java:162)   at org.hibernate.tuple.entity.AbstractEntityTuplizer.<init>(AbstractEntityTuplizer.java:135)   at org.hibernate.tuple.entity.PojoEntityTuplizer.<init>(PojoEntityTuplizer.java:55)   at org.hibernate.tuple.entity.EntityEntityModeToTuplizerMapping.<init>(EntityEntityModeToTuplizerMapping.java:56)   at org.hibernate.tuple.entity.EntityMetamodel.<init>(EntityMetamodel.java:269)   at org.hibernate.persister.entity.AbstractEntityPersister.<init>(AbstractEntityPersister.java:425)   at org.hibernate.persister.entity.JoinedSubclassEntityPersister.<init>(JoinedSubclassEntityPersister.java:91)   at org.hibernate.persister.PersisterFactory.createClassPersister(PersisterFactory.java:58)   at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:226)   at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1291)   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:804)   at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:744)   at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131)   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.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.aop.framework.ProxyFactoryBean.initializeAdvisorChain(ProxyFactoryBean.java:438)   at org.springframework.aop.framework.ProxyFactoryBean.getObject(ProxyFactoryBean.java:251)   at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectFromFactoryBean(AbstractBeanFactory.java:1211)   at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1177)   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:261)   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:273)   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)   at com.jaspersoft.jasperserver.export.BaseExportImportCommand.createSpringContext(BaseExportImportCommand.java:116)   at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:76)   at com.jaspersoft.jasperserver.export.ExportCommand.main(ExportCommand.java:43)Caused by: java.lang.ClassNotFoundException: org.objectweb.asm.util.TraceClassVisitor not found in gnu.gcj.runtime.SystemClassLoader{urls=[file:./,file:config/,file:lib/acegi-security-1.0.1.jar,file:lib/activation-1.1.jar,file:lib/antlr-2.7.6.jar,file:lib/antlr-runtime-3.0.jar,file:lib/aopalliance-1.0.jar,file:lib/asm-1.5.3.jar,file:lib/asm-attrs-1.5.3.jar,file:lib/aspectjrt-1.5.2a.jar,file:lib/avalon-framework-cvs-20020806.jar,file:lib/axis-1.3.jar,file:lib/axis-jaxrpc-1.3.jar,file:lib/axis-saaj-1.3.jar,file:lib/batik-1.5-fop-0.20-5.jar,file:lib/bcprovs-1.3.1.jar,file:lib/bsh-1.3.0.jar,file:lib/castor-1.0.jar,file:lib/cglib-2.1_3.jar,file:lib/commons-beanutils-1.7.0.jar,file:lib/commons-cli-1.0.jar,file:lib/commons-codec-1.3.jar,file:lib/commons-collections-3.2.jar,file:lib/commons-dbcp-1.2.1.jar,file:lib/commons-digester-1.7.jar,file:lib/commons-discovery-0.2.jar,file:lib/commons-fileupload-1.1.1.jar,file:lib/commons-httpclient-3.0.jar,file:lib/commons-io-1.1.jar,file:lib/commons-lang-2.1.jar,file:lib/commons-logging-1.0.4.jar,file:lib/commons-math-1.0.jar,file:lib/commons-pool-1.2.jar,file:lib/commons-vfs-1.0.jar,file:lib/db2jcc.jar,file:lib/dom4j-1.6.1.jar,file:lib/edb-jdbc14.jar,file:lib/ehcache-1.2.3.jar,file:lib/eigenbase-properties-0.5.0.jar,file:lib/eigenbase-resgen-0.5.0.jar,file:lib/eigenbase-xom-0.5.0.jar,file:lib/fop-0.20.5.jar,file:lib/groovy-all-minimal-1.0.jar,file:lib/hibernate-3.2.1.ga.jar,file:lib/hsqldb-1.7.1.jar,file:lib/iijdbc.jar,file:lib/itext-1.3.1.jar,file:lib/jai_codec-1.1_mr.jar,file:lib/jai_core-1.1_mr.jar,file:lib/jakarta-regexp-1.4.jar,file:lib/jasperreports-3.0.0.jar,file:lib/jasperserver-api-common-3.0.0.jar,file:lib/jasperserver-api-common-impl-3.0.0.jar,file:lib/jasperserver-api-engine-3.0.0.jar,file:lib/jasperserver-api-engine-impl-3.0.0.jar,file:lib/jasperserver-api-metadata-3.0.0.jar,file:lib/jasperserver-api-metadata-impl-3.0.0.jar,file:lib/jasperserver-common-ws-3.0.0.jar,file:lib/jasperserver-export-tool-3.0.0.jar,file:lib/jasperserver-repository-hibernate-3.0.0.jar,file:lib/jasperserver-war-jar-3.0.0.jar,file:lib/javacup-0.10k.jar,file:lib/jcommon-1.0.0.jar,file:lib/jdom-1.0.jar,file:lib/jdtcore-3.1.0.jar,file:lib/jfreechart-1.0.3.jar,file:lib/ji-analysis-3.0.0.jar,file:lib/ji-analysis-export-3.0.0.jar,file:lib/ji-common-3.0.0.jar,file:lib/ji-datarator-3.0.0.jar,file:lib/ji-gyroscope-3.0.0.jar,file:lib/ji-gyroscope-export-3.0.0.jar,file:lib/ji-jpivot-3.0.0.jar,file:lib/ji-license-3.0.0.jar,file:lib/ji-report-options-api-3.0.0.jar,file:lib/ji-report-options-export-3.0.0.jar,file:lib/ji-report-options-web-3.0.0.jar,file:lib/ji-repository-3.0.0.jar,file:lib/ji-semantic-layer-3.0.0.jar,file:lib/ji-tbutils-wcf-3.0.0.jar,file:lib/ji-wcf-3.0.0.jar,file:lib/jpivot-3.0.0.jar,file:lib/js-1.6R5.jar,file:lib/jsf-api-1.1.jar,file:lib/json-org-1.0.jar,file:lib/jstl-1.1.2.jar,file:lib/jta-1.0.1B.jar,file:lib/junit-3.8.1.jar,file:lib/jxl-2.6.jar,file:lib/log4j-1.2.12.jar,file:lib/mail-1.4.jar,file:lib/mondrian-2.3.2.8944-DB2.jar,file:lib/mysql-connector-java-3.1.14.jar,file:lib/ognl-2.6.9.jar,file:lib/ojdbc14.jar,file:lib/oro-2.0.8.jar,file:lib/png-encoder-1.5.jar,file:lib/postgresql-8.2-504.jdbc3.jar,file:lib/protection-2.1.1.jar,file:lib/quartz-1.5.1.jar,file:lib/servlet-api-2.3.jar,file:lib/sitemesh-2.2.1.jar,file:lib/spring-2.0.2.jar,file:lib/spring-beans-2.0.2.jar,file:lib/spring-binding-1.0.1.jar,file:lib/spring-context-2.0.2.jar,file:lib/spring-core-2.0.2.jar,file:lib/spring-dao-2.0.2.jar,file:lib/spring-hibernate3-2.0.2.jar,file:lib/spring-jdbc-2.0.2.jar,file:lib/spring-web-2.0.2.jar,file:lib/spring-webflow-1.0.1.jar,file:lib/sqljdbc.jar,file:lib/standard-1.1.2.jar,file:lib/tbutils-wcf-3.0.0.jar,file:lib/wcf-3.0.0.jar,file:lib/wsdl4j-1.5.1.jar,file:lib/xalan-2.4.1.jar,file:lib/xbean-2.2.0.jar,file:lib/xercesImpl-2.6.2.jar,file:lib/xmlbeans-jsr173-api-2.0-dev.jar,file:lib/xpp3_min-1.1.3.4.O.jar,file:lib/xstream-1.2.2.jar], parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}   at java.net.URLClassLoader.findClass(libgcj.so.7rh)   at java.lang.ClassLoader.loadClass(libgcj.so.7rh)   at java.lang.ClassLoader.loadClass(libgcj.so.7rh)   at java.lang.Class.forName(libgcj.so.7rh)   at java.lang.Class.initializeClass(libgcj.so.7rh)Post Edited by Vandana Premkumar at 01/12/09 19:00

Post Edited by Vandana Premkumar at 01/12/09 19:04

[vpremkumar]

I used metadata.hibernate.dialect=com.jaspersoft.ji.hibernate.dialect.OracleUnicodeDialect, still the error occurs. Can some one please look at it?
 

[vpremkumar]

can some one please respond to this?

[wentwog]

Hello.

Try to use

metadata.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

 

It has worked for me. I've launched a search for "Oracle.*Dialect" throught jar's within my downloaded copy of "Generic ZIP distribution v 4.0", and among others have founded the mentioned dialect class.

 

I suppose that "com.jaspersoft.ji.hibernate.dialect.OracleUnicodeDialect" is only distributed with the professional version of JS.