Previous Topic  Next Topic

Specifying Schemas

Logi JReport Server supports DBMS schemas in order to work well with databases that support schemas. Those DBMSs include Oracle, DB2, SQL Server, Sybase, PostgreSQL, InterSystems Caché and EnterpriseDB. 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 Topic  Next Topic