ext.joseph.gette

1- download the latest bin file 2- download Tomcat 3- download the jasperreport schema from the attachment you can transfer postgres or mysql schema to oracle if you understand where is the difference. 4- create a user for example called jasper and run the attached sql schema inside 5 - install tomcat 6- extract the jasperserver-3.1-bin.zip then extract the jasperserver.war inside the apache-tomcatwebappsjasperserver 7- download jdbc driver for oracle 7-put the ojdbc14.jar in apache-tomcatcommonlib 8- modify apache-tomcatwebappsjasperserverWEB-INFhibernate.properties modify the line starts with metadata.hibernate.dialect= to be metadata.hibernate.dialect=org.hibernate.dialect.OracleDialect 9- modify apache-tomcatwebappsjasperserverMETA-INFjasperserverDS-jdbc.xml modify the section <jdbc-driver-params> to be <jdbc-driver-params> <url>jdbc:oracle:thin:@localhost:1521:XE</url> <driver-name>oracle.jdbc.driver.OracleDriver</driver-name> <properties> <property> <name>user</name> <value>jasper</value> </property> </properties> <password-encrypted>jasper</password-encrypted> </jdbc-driver-params> 10 - modfiy apache-tomcatwebappsjasperserverMETA-INFcontext.xml modify the section starts with <Resource name="jdbc/jasperserver" to be <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="jasper" password="jasper" driverClassName="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@localhost:1521:XE"/> This instruction will help you install Oracle repository. But there's another problem connected with memory leak. I didn't resolve it yet

You can rename js-catalog-oracle-pro.zip to js-catalog-oracle-ce.zip

You can turn off validation in validation.xml file. Just add in block "check-dbtype-ce" one more argument with dbtype=oracle. But there'll be another error

There's way how to turn off validation for Oracle DB in Buildomatic. I'm trying to use oracle as repository but can't resolve one error. When i'll find solution i can tell you - how to use oracle repository. But be ready to changing scripts and configs inside of buildomatic

Good day everyone! How can i use existing remote host Oracle database with JasperReports Server CE? I tried to install it manually with buildomatic but there's error: check-dbtype-ce: BUILD FAILED C:Jaspersoftjasperreports-server-cp-5.5.0buildomaticbinvalidation.xml:532: JasperServer CE doesn't support oracle DB type!