Previous Page Next Page

Creating Tables in a Specified Tablespace

JReport Server supports creating tables in a user-specified tablespace in a database that supports tablespaces, such as DB2 and Oracle. A key-value pair tablespace is provided to specify a tablespace into which JReport Server will create database tables. This key-value pair is then passed to JReport Server through the JDBC configuration. JReport Server retrieves the tablespace information from the JDBC (data source) configuration, and then creates tables in the specified tablespace.

Tablespace can be configured either in the dbconfig.xml file by using the <tablespace></tablespace> tags, or in dsInfo by adding the attribute tablespace=table_space_name.

In dbconfig.xml

Add the <tablespace></tablespace> tags in the dbconfig.xml file as follows:

...
<workspace name="defaultRealm">
    <database name="realmtables">
        <driver classpath="...">jdbc_driver_name</driver>
        <url>jdbc_url</url>
        <user>jdbc_user</user>
        <password>jdbc_password</password>
        <tablespace>table_space_name</tablespace>
    </database>
</workspace>
...

In dsInfo

Since dsInfo supports JNDI and JDBC protocols, you can add the attribute tablespace=table_space_name in the JNDI or JDBC statement.

• jdbc://[<jdbc-user>:<jdbc-password>@]<jdbc-url>[#<attribute-name=attribute-value>,]

  For example:

  jdbc://user:password@jdbc:odbc:jreport-realmtables#driver=sun.jdbc.odbc.JdbcOdbcDriver,tablespace=myTablespace

• jndi://[<jdbc-user>:<jdbc-password>@]<datasource-name>[#<attri-name=attri-value>,]

  For example:

  jndi://jdbc/jreport-realmtables#tablespace=myTablespace

Previous Page Next Page