cpsheff

Thanks - will try this out as soon as I can!

Thanks, I have tried editing the hibernate.properties but keep getting the error: [java] Caused by: java.lang.ClassNotFoundException: com.jaspersoft.ji.hibernate.dialect.OracleU nicodeDialect I guess we are missing something for Oracle databases in CP version?

Thanks for that, I realised that I would have to use Buildomatic to get this sorted. I spotted another question you had replied to re. Oracle & switched from the Windows installer to the jasperreports-server-cp-4.0.0-bin.zip to use this instead. I have extracted this, copied the oracle_master.properties file to the buildomatic folder & renamed to default_master.properties & entered all the relevant details. I have then made several attempts to either upgrade or create a new db without success. If I try to use js-install-ce.bat I get the error in the attached js-install-ce_2011-03-29_14-13_13826.log file (I get a similar error when I try using js-upgrade-samedb-ce.bat). If I try to use the js-upgrade-newdb-ce.bat I seem to get further but it still fails - see attached js-upgrade-ce_2011-03-29_14-51_14208.log file. I have run through the configuration of import & export utilities but keep getting errors related to the summary error: Caused by: java.lang.ClassNotFoundException: com.jaspersoft.ji.hibernate.dialect.OracleUnicodeDialect I have tried editing the db.properties in conf_source\db\oracle to ensure all settings are correct & re-generating the build_conf but still no joy. I have been through the whole of the JasperReports-Server-CP-Install-Guide doc & can't see any other things to try - any pointers would be very gratefully received!

I am new to JasperServer but I recently experimented with 3.7CE and got it working fine with an Oracle 10g repository, simply by running js-create.ddl, quartz.ddl, adding some minimal config & then making the following edits: WEB-INF\Hibernate.properties: metadata.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect WEB-INF\js.jdbc.properties # Property that determines the Hibernate dialect metadata.hibernate.dialect=org.hibernate.dialect.Oracle10gDialect # jasperserver repo db settings metadata.jdbc.driverClassName=oracle.jdbc.OracleDriver metadata.jdbc.url=jdbc:oracle:thin:@server:1521:sid metadata.jdbc.username=jasper metadata.jdbc.password=password META-INF\context.xml: <Resource name="jdbc/jasperserver" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="jasper" password="jasper" driverClassName="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@server:1521:sid"/> META-INF\jasperserverDS-jdbc.xml: <name>JasperServerDataBase</name> <jdbc-driver-params> <url>jdbc:oracle:thin:@server:1521:sid</url> <driver-name>oracle.jdbc.driver.OracleDriver</driver-name> <properties> <property> <name>user</name> <value>jasper</value> </property> </properties> <password-encrypted>password</password-encrypted> </jdbc-driver-params> <jdbc-connection-pool-params> <test-table-name>SQL SELECT 1</test-table-name> </jdbc-connection-pool-params> <jdbc-data-source-params> <jndi-name>JasperServerDataBase</jndi-name> However although I have done the same for JasperServer 4 CP I don't appear to be able to load the stylesheets (see attached screenshot). Reading the documents I think I may need to import the minimal Oracle config from the Buildomatic files - is this correct? Reading the Buildomatic notes it does not appear to support Oracle (though there are Oracle files) so I am unsure how to import these - does anyone have any experience of getting JasperServer running with an Oracle 10g repository who can advise me of correct course of actions?

I was interested in your post as I had 3.7 CE working against an Oracle 10g repository but although I believe I have followed the same steps as yourself I cannot get the login screen to appear correctly using 4 CP (it looks like stylesheets not loading - see attached screenshot). The steps I have followed are: run js-create.ddl run quartz.ddl run upgrade-oracle-3.7.0-4.0.0-pro.sql edit hibernate.properties as described in your post Edit jasperserverDS-jdbc.xml as described in your post Edit js.jdbc.properties as described in your post Is there anything I am missing here?