
6
An H2-based configuration would look like:
swa.db.url = jdbc:h2:codedx;DB_CLOSE_DELAY=5;LOCK_TIMEOUT=5000
swa.db.driver = org.h2.Driver
swa.db.datasource = org.h2.jdbcx.JdbcDataSource
swa.db.database = codedx
swa.db.user =
swa.db.password =
In this case, the username and password are not used, and the database will be created in (or
read from) a codedx.db file at whatever the Java server considers to be the working directory.
Note the DB_CLOSE_DELAY and LOCK_TIMEOUT settings in the swa.db.url field. For
performance reasons, we recommend using these settings if you choose to use an H2-based
database configuration.
3.2.5 Database Permissions
You must ensure that the "user" that Code Dx uses to access your database is given the
following permissions:
For records:
SELECT
INSERT
UPDATE
DELETE
For tables:
CREATE
ALTER
REFERENCES
INDEX
DROP
In MySQL Workbench, under Users and Privileges > Schema Privileges (tab), you should see this:
Kommentare zu diesen Handbüchern