The distribution of the JDBC Authentication Swiftlet contains the following directories:
sql/mssqlserver
sql/oracle
Directory "sql/mssqlserver" contains SwiftMQ's SQL table schema for Microsoft SQL Server 2000.
Directory "sql/oracle" contains SwiftMQ's SQL table schema for Oracle9i.
Both schemes are identical. They differ only in the SQL syntax. The following tables are created during the installation:
Default users such as "anonymous", "admin" are created during the installation.
To avoid BIT columns we use VARCHAR(1) types for the queue and topic grants. To grant a right, the value of the resp. column has to be "Y", to revoke it, specify "N".
The SQL statements used from the JDBC Authentication Swiftlet are defined within the entity "statements":
The default values (statements) match with the default SQL schema, stored under the "sql/<database>" directory. However, you can overwrite any SQL statement and can use another SQL schema therefore.
Each default statement contains a "${schema-prefix}" in front of the table name. This variable will be substituted with the value of the "schema-prefix" attribute. For example, in case the SwiftMQ tables are stored under a schema "swiftmq" in the database, the table name needs to be prefixed sometimes with the schema name. In this case, the attribute "schema-prefix" must contain the name of the schema with a trailing dot '.', e.g. "swiftmq.". This results in "swiftmq.users" for the "users" table name in the SQL statements.