Jump to content
Changes to the Jaspersoft community edition download ×

Oracle Patch 1.2.0


Recommended Posts



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 (, 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

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...