Creating tables in a specified table space

JReport Server supports creating tables in a user-specified table space in a database that supports table spaces, such as DB2 and Oracle. A key-value pair tablespace is provided to specify a table space 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 table space information from the JDBC (data source) configuration, and then creates tables in the specified table space.

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 the 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