kartikgajjar

Fully agree, zipping will even save bandwidth when the mails are being accessed via smartphone / pda now a days. Highly required. :)

Friends, I've invested enough time to make JI working under Oracle, hope this post will help people out there having trouble getting JI working with Oracle. System Detail: OS: Windows XP SP2 JI Installation File: jasperintelligence-1.1.0-windows-oss-installer.exe With all possible options, I could not make JI work with Oracle 8.1.7.X. It worked with Oracle 9i (9.2.0.1.0), below are the steps to get it up and running. 1) Get the Oracle Patch from http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=10&id=17568#17568 2) Follow the steps in two attached files 3) Insert statement may not work for Oracle 9i, will give constraint error, add ID field in insert statements (JIRole, JIUser and JIObjectPermission). 4) Since we are manually inserting the data, oracle sequence “HIBERNATE_SEQUENCE†may have value already used in one of the DML statements. Get the value of HIBERNATE_SEQUENCE increased so the next value is nowhere (Taking this value to 10 will do) 5) Do changes as per readme file. 6) For jasperserver/META-INF/context.xml file a. ensure you use OCI and not THIN drivers b. append following to resource validationQuery="select 1 from dual" 7) For jasperserver/WEB-INF/applicationContext.xml add following if you are receiving error (Related to clob/blob) after starting JI: <prop key="hibernate.jdbc.batch_size">0</prop>[/ul] (I’m not sure about the performance impact, but this worked for me) Alternatively you may also use the file attached here with. Hope this saves your time, enjoy [file name=oracle_patch_1-722a1c173254c31526799d2bcacdfbc2.zip size=6653]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/oracle_patch_1-722a1c173254c31526799d2bcacdfbc2.zip[/file] Post edited by: kartikgajjar, at: 2006/11/30 06:12 Post edited by: kartikgajjar, at: 2006/11/30 06:13

Hi, Refer http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=17568&catid=10&limit=6&limitstart=6 Able to connect to oracle after suggested changes, (moving repository Oracle).

Hi, I'm able to connect, login after oracle connection. Created folder & data source. While saving report unit received following error. org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@126a408 targetAction = com.jaspersoft.jasperserver.war.action.ReportUnitAction@1db3e20, attributes = map[[empty]]] in state 'saveReport' of flow 'reportUnitFlow'; nested exception is org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed Has above to do anything with oracle version, mine is 8.1.7.3

Can some one help me with this ?

Hi there, Now; i've reinstalled JasperIntelligence. Sample not imported. Even this time bundled tomcat & mssql used. 1) Copied classes12.zip to C:jasperintelligence-1.1.0apache-tomcatwebappsjasperserverWEB-INFlib and renamed to classes12.jar 2)Here are connection test log form my machine C:KartikPROJECTSJAVA>set CLASSPATH=c:oracleora81jdbclibclasses12.zip; C:KartikPROJECTSJAVA>java JdbcCheckup Please enter information to test connection to the database user: username password: password TNSNAME Name: GJPREP database : UDRGNR ip: 10.0.128.27 port: 1521 Connecting to the database... Connecting... jdbc:oracle:oci8:@GJPREP OCI: connected. UDRGNR@gjprep Ver:8.1.7.3.0Started : 16-Oct-2006 08:14:09 Your JDBC:OCI installation is correct. jdbc:oracle:thin:@10.0.128.27:1521:UDRGNR connected. UDRGNR@gjprep Ver:8.1.7.3.0Started : 16-Oct-2006 08:14:09 Your JDBC:THIN installation is correct. 3) Datasource created under JI Driver: oracle.jdbc.driver.OracleDriver URL: jdbc:oracle:thin:@10.0.128.27:1521:UDRGNR Oracle Version 8.1.7.3 4) Error at JI Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted Caused by: java.util.NoSuchElementException: Could not create a validated object Thanks for you time, :)

Error occurred on first attempt itself. Here are some more line from error. Please guide me to locate error. Key note from error: Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted Caused by: java.util.NoSuchElementException: Could not create a validated object java.util.NoSuchElementException: Could not create a validated object While executing above used OCI8. at java.lang.Thread.run(Thread.java:595) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:103) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:50) ... 81 more Caused by: java.util.NoSuchElementException: Could not create a validated object at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:851) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) ... 82 more Thx,

Same error reported previously http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=1265&catid=10 Initial lines of jasperserver.log 17:47:07,605 WARN LoggerListener,http-8080-Processor25:55 - Authentication event AuthenticationSuccessEvent: root; details: org.acegisecurity.ui.WebAuthenticationDetails@fffe3f86: RemoteIpAddress: 127.0.0.1; SessionId: F124BDAD01AA19A83E28BE344BF57497 17:47:07,605 WARN LoggerListener,http-8080-Processor25:55 - Authentication event InteractiveAuthenticationSuccessEvent: root; details: org.acegisecurity.ui.WebAuthenticationDetails@fffe3f86: RemoteIpAddress: 127.0.0.1; SessionId: F124BDAD01AA19A83E28BE344BF57497 17:47:21,687 ERROR JdbcDataSourceService,http-8080-Processor25:52 - Error creating connection. org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:103) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:50) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:48)

Tried JDBC Thin & OCI8, still getting the same error. Though, able to connect using Thin & OCI8 from my machine. Thx,

Yes, oracle drivers are on classpath. This was previous error, after that above error has appeared. I've executed same with iReport, which is running.

I've created a JDBC connection and have a simple select report. After creating report unit, when I run the report it gives following error. org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@3b34ca targetAction = com.jaspersoft.jasperserver.war.action.ViewReportAction@106bcf8, attributes = map[[empty]]] in state 'verifyData' of flow 'viewReportFlow'; nested exception is com.jaspersoft.jasperserver.api.JSException: Error creating connection. From the message it is clear that there was an error while creating connection. It is a local oracle database and I'm able to connect it. How do i solve this error OR get more information related to this error. Thx,