War file Deployment of jasperreports-server-cp-5.5.0-bin.zip with oracle and glassfishV3.1 failed without any information. Can you please verify the steps I followed?

[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..
 

[omarntfs]

same problem any help please

[omarntfs]

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.

[omarntfs]

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.