kartikgajjar Posted November 29, 2006 Share Posted November 29, 2006 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 SP2JI 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 files3) 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:12Post edited by: kartikgajjar, at: 2006/11/30 06:13 Link to comment Share on other sites More sharing options...
Grazy Mos Posted November 29, 2006 Share Posted November 29, 2006 Thanks for sharing, This might be very helpfull for in the nearby future Link to comment Share on other sites More sharing options...
swood Posted November 29, 2006 Share Posted November 29, 2006 Thanks! Karma +1 Can you add the updates as a patch? ShermanJasperSoft Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now