configuring jasperserver 3.5 and Oracle 11g

[sup03]

I am using jasperserver 3.5 community edition and trying to configure it with oracle 11g. I have made changes in hibernate.properties, jasperserverDS-jdbc.xml, context.xml. i have place ojdbc14.jar in apache-tomcat\common\lib. i have created all the objects in oracle database as per the scripts in http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=54994&page=1. I am able to login to jasperserver and publish reports . When i try to run the reports it throws an error as

org.springframework.orm.hibernate3.HibernateJdbcException: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.GenericJDBCException: could not insert: [com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.CachedItem]

I have attached the complete error trace. If anyone has faced similar issue please let me know if any other changes has to be done. Thanks

[baggypants]

Bit of a long shot, It looks like Oracle, Hibernate and CLOBS have a bit of a history. have you tried the Oracle JDBC driver for 11g?

 

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_112010.html

looks like it requires JRE 1.5 (I run Jasperserver on 1.5 so I don't see an issue with that)

 

[swood]

I don't know what the issue is. We have quite a few folks running successfuly with an Oracle repository for JasperServer 3,5.

 

Sherman

Jaspersoft