Initializing the Database System as a Non-Admin Database User
Logi JReport Server needs to connect to a server database and fetch and write data from the database tables at runtime. Database initialization is to create the required tables in the database. Usually, Logi JReport Server automatically creates database tables the first time it is started. The database information that Logi JReport Server uses is defined in the dbconfig.xml file. However, if the user ID defined in this file does not have the permission to create tables in the database, Logi JReport Server will fail to complete the operation. In this case, you will need another user, such as the database administrator (who holds the relevant permissions), to create a set of empty tables in the user's schema using the provided SQL files in
In the case when a database administrator (DBA) does not want to assign an admin database user to Logi JReport Server for connecting to the server database, Logi JReport has to use a non-admin database user to initialize the database system. The database initialization will then have to be divided into three phases:
- The DBA creates new database tables using script files stored in
- Customer starts Logi JReport Server by using non-admin database user. In this phase, the data in the old version's database tables if they exist will be migrated to the new tables created in the first step. If the data migration happens, you will be able to see a record of it in the debug file.
- The DBA deletes the old version' tables in the database using script files stored in
If it is a newly installed Logi JReport Server connecting to a database that does not already contain the required tables, only the first step is required.
The following table lists the script files used for different purposes:
Script files used for creating new database tables
|db2_c.txt||Creates new tables for DB2 database.|
|derby_c.txt||Creates new tables for Derby database.|
|hsqldb_c.txt||Creates new tables for HSQLDB database.|
|informix_c.txt||Creates new tables for Informix database.|
|mysql_c.txt||Creates new tables for MySQL database (for single-byte charset, e.g. latin1).|
|sybase_dc.txt||Deletes current version tables for Sybase database.|