Oracle Patch 1.2.0

[kartikgajjar]

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

[Grazy Mos]

Thanks for sharing, This might be very helpfull for in the nearby future

[swood]

Thanks! Karma +1

 

Can you add the updates as a patch?

 

 

Sherman

JasperSoft