Jump to content
We've recently updated our Privacy Statement, available here ×

Advice on installing JasperServer 4 with Oracle 10g as the repository


cpsheff

Recommended Posts

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?



 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...