saurabh.chawla
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by saurabh.chawla
-
-
I am trying to run jasperreports-server-cp-5.5.0-bin.zip with oracle and glassfishV3.1
Step followed:
MANNUAL DB SETUP:
[1] cd <js-install>/buildomatic/install_resources/sql/oracle
[2] sqlplus /nolog (start sqlplus client)
[3] SQL> connect system/password (use your sysUsername and password)
[4]
[5] SQL> create user jasperserver identified by password;
[6] SQL> grant connect, resource to jasperserver;
[7] SQL> connect jasperserver/password
[8] SQL> @js-pro-create.ddl
[9] SQL> @quartz.ddl
[10] SQL> exit
INSTALLATION:
[1] unzip jasperreports-server-cp-5.5.0-bin.zip
[2] Copy "oracle_master.properties" file from "<js-install>/buildomatic/sample_conf/" to "<js-install>/buildomatic/"
[3] Now edited "default_master.properties" .
o change "appServerType = tomcat7" to "appServerType = glassfish3"
o change "appServerDir = C:\Program Files\Apache Software Foundation\Tomcat 7.0" to "appServerDir = /usr/local/glassfish3"
o now change following as applicable:
dbType=oracle
dbHost=<add host here>
dbUsername=<JASPER DB USERNAME CREATED DURING THE SETUP OF DATABASE>
dbPassword=<JASPER DB PASSWORD CREATED DURING THE SETUP OF DATABASE>
add sysUsername=<SYSTEM USER NAME>
add sysPassword=<SYSTEM PASSWORD>
o uncomment and change "js.dbName=jasperserver" to "js.dbName=<JASPER DB NAME CREATED DURING THE SETUP OF DATABASE>"
o uncommented the
glassfishPort=4848
glassfishUser=admin
AS_ADMIN_PASSWORD=adminadmin
[4] cd <js-install>/buildomatic/
[5] ./js-ant clean-config
[6] ./js-ant gen-config
[7] ./asadmin --host 127.0.0.1 --port 4848 enable-secure-admin
username as admin
password adminadmin
[8] restart glassfish
[9] edited <js-install>/build_conf/default/app.srv.properties
o change "glassfishDomain=domain1" to "glassfishDomain=<MY DOMAIN>" # do not include qoutes
o change and uncomment the following as applicable
glassfishPort=4848
glassfishUser=<GLASSFISH ADMIN USERNAME>
AS_ADMIN_PASSWORD=<GLASSSFISH ADMIN PASSWORD>
[10] edited <js-install>/build_conf/default/js.jdbc.properties
o changed
metadata.hibernate.dialect=com.jaspersoft.ji.hibernate.dialect.OracleJICustomDialect
to
metadata.hibernate.dialect=org.hibernate.dialect.OracleDialect#sthash.5dM78yZm.dpuf
[11] edited <js-install>/buildomatic/validation.xml
added " <equals arg1="${dbType}" arg2="oracle" />"
to line number :528
[12] stopped glassfish
[13] ran
o ./js-ant import-minimal-ce
o ./js-ant deploy-webapp-ce
It shows success for both the final commands but glassfish doesnt show jasperserver in application in admin console.
and jasperserver.war deployed is fail as there is a file with deployment failed under glassfish but it does not have any details. I din't have any other logs.
Is there anything wrong in these steps? Please help..
Does Jasperreports 4.7 community edition support Oracle somehow?
in Products
Posted