Actually i installed jasper server 5.1 cp but sample file is not there in buildomatic for oracle configuration..
7 Answers:
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-tomcat\webapps\jasperserver\
7- download jdbc driver for oracle
7-put the ojdbc14.jar in apache-tomcat\common\lib
8- modify apache-tomcat\webapps\jasperserver\WEB-INF\hibernate.properties
modify the line starts with metadata.hibernate.dialect=
to be metadata.hibernate.dialect=org.hibernate.dialect.OracleDialect
9- modify apache-tomcat\webapps\jasperserver\META-INF\jasperserverDS-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-tomcat\webapps\jasperserver\META-INF\context.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
Hi - when you installed this way, I assume you did not already have an Oracle schema created and that you did not have to run any DDL scripts to create it ?
Did it create the schema/user, tables and objects when it found it did not exist or ?
If not, did you generate a DLL script from an existing postgres instance ?
Could you please explain me in detail the step 4
4- create a user for example called jasper
and run the attached sql schema inside
I couldn't find the attached sql scheme.
Greatly appreciate your help..
thank you, i successfully configured the version jasperreports-server-cp-5.6.0-bin with oracle 11g xe
I solved it by changing js.jdbc.properties manually, by modifying these properties:
# Property that determines the Hibernate dialect
metadata.hibernate.dialect=org.hibernate.dialect.OracleDialect
# jasperserver repo db settings
metadata.jdbc.driverClassName=oracle.jdbc.OracleDriver
metadata.jdbc.url=jdbc:oracle:thin:@localhost:1521:xe
metadata.jdbc.username=jasperserver
metadata.jdbc.password=password
metadata.jdbc.password.escapeXML=password
metadata.jndi=jdbc/jasperserver
metadata.database.generate=true
I post the answer in case someone has the same problem.
" You can use it to report off of " , I am not getting meaning of this , can you please described it and does oracle support comertial version of jasper server ?
There are two types of databases involved with JasperReports server - The database that holds the repository (report definitions, users, etc.) and the data sources that hold the data you are trying to analyze. The community edition does not support Oracle as the repository database. You can, however, connect to an Oracle database to do reporting and analysis if the data you are trying to analyze is in an Oracle database.
The commercial version of the server does support using Oracle as the repository database.
Thanks Mgeise ,
can we use jasper server for UI purpose means with jQuery Something .. ?