Previous Page Next Page

Specifying Schemas

JReport Server supports DBMS schemas in order to work well with databases that support schemas. Those DBMSs include Oracle, DB2, SQL Server, Sybase and PostgreSQL. You can specify schema information in the dbconfig.xml file located in <install_root>\bin by adding the <schema></schema> tags 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>
        <schema>schema_name</schema>
    </database>
</workspace>
...

When the server database is specified using a JDBC or JNDI data source, you can also specify schema information by adding the attribute schema=schema_name in the JDBC or JNDI data source.

• 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,schema=db2admin

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

  For example:

  jndi://jdbc/jreport-realmtables#schema=db2admin

If you are using Sybase, the schema name must use capital letters, for example, ABCDE.

Previous Page Next Page