You must stop the router before you install this Kernel Swiftlet. Then copy the content of the "deploy" subdirectory of this Kernel Swiftlet distribution into the directory "kernel/sys$store".
Copy the JDBC driver jar files into "kernel/sys$store". Note that you cannot use zip files. If your JDBC driver is provided as a zip file, then you have to convert it to a jar file.
The configuration of the JDBC Store Swiftlet is defined within the element
<swiftlet name="sys$store" .../>
of the router's configuration file. One can use the SwiftMQ Exlorer or CLI for configuration as well. They both save into that file.
Element "jdbc", Parent Element: "swiftlet"
JDBC Settings.
Definition
| Attribute | Type | Mandatory | Description |
|---|---|---|---|
| driver-classname | java.lang.String | Yes | Name of the JDBC Drive Class |
| url | java.lang.String | Yes | JDBC URL |
| username | java.lang.String | No | JDBC Username |
| password | java.lang.String | No | JDBC Password |
Values
| Attribute | Values |
|---|---|
| driver-classname | |
| url | |
| username | |
| password |
Element "connection-pool", Parent Element: "swiftlet"
JDBC Connection Pool.
Definition
| Attribute | Type | Mandatory | Description |
|---|---|---|---|
| connection-factory | java.lang.String | No | Pooled Connection Factory |
| min-connections | java.lang.Integer | No | Minimum Connections |
| max-connections | java.lang.Integer | No | Maximum Connections |
| idle-timeout | java.lang.Long | No | Idle Timeout |
| keepalive-interval | java.lang.Long | No | Keep Alive Interval |
Values
| Attribute | Values |
|---|---|
| connection-factory | Default: com.swiftmq.impl.store.jdbc.pool.PooledConnectionFactory |
| min-connections | Min: 0 Default: 5 |
| max-connections | Default: -1 |
| idle-timeout | Default: 6000000 |
| keepalive-interval | Default: 600000 |
Element "statements", Parent Element: "swiftlet"
SQL Statements.
Definition
| Attribute | Type | Mandatory | Description |
|---|---|---|---|
| schema-prefix | java.lang.String | No | Schema Prefix for Tables |
| keepalive | java.lang.String | No | Keep Alive Statement |
| messages-select-all | java.lang.String | No | Messages/Select All |
| messages-select-single | java.lang.String | No | Messages/Select Single |
| messages-select-max-id | java.lang.String | No | Messages/Select max(id) |
| messages-delete-all | java.lang.String | No | Messages/Delete All |
| messages-delete-single | java.lang.String | No | Messages/Delete Single |
| messages-delete-sequence | java.lang.String | No | Messages/Delete Sequence |
| messages-update-single | java.lang.String | No | Messages/Update Single |
| messages-update-sequence | java.lang.String | No | Messages/Update Sequence |
| messages-insert | java.lang.String | No | Messages/Insert |
| messages-insert-oracle-1 | java.lang.String | No | Messages/Insert/Oracle/1 |
| messages-insert-oracle-2 | java.lang.String | No | Messages/Insert/Oracle/2 |
| messages-insert-oracle-3 | java.lang.String | No | Messages/Insert/Oracle/3 |
| durables-select-all | java.lang.String | No | Durables/Select All |
| durables-select-single | java.lang.String | No | Durables/Select Single |
| durables-insert | java.lang.String | No | Durables/Insert |
| durables-delete | java.lang.String | No | Durables/Delete |
| xalog-select-all | java.lang.String | No | XA Log/Select All |
| xalog-select-single | java.lang.String | No | XA Log/Select Single |
| xalog-select-max-id | java.lang.String | No | XA Log/Select max(id) |
| xalog-insert | java.lang.String | No | XA Log/Insert |
| xalog-insert-oracle-1 | java.lang.String | No | XA Log/Insert/Oracle/1 |
| xalog-insert-oracle-2 | java.lang.String | No | XA Log/Insert/Oracle/2 |
| xalog-insert-oracle-3 | java.lang.String | No | XA Log/Insert/Oracle/3 |
| xalog-delete | java.lang.String | No | XA Log/Delete |
Values
| Attribute | Values |
|---|---|
| schema-prefix | |
| keepalive | Default: select 1 from ${schema-prefix}xalog |
| messages-select-all | Default: select id,priority,deliverycount,expirationtime from ${schema-prefix}messages where queuename = ? order by id |
| messages-select-single | Default: select priority,deliverycount,expirationtime,content from ${schema-prefix}messages where queuename = ? and id = ? |
| messages-select-max-id | Default: select max(id) from ${schema-prefix}messages where queuename = ? |
| messages-delete-all | Default: delete from ${schema-prefix}messages where queuename = ? |
| messages-delete-single | Default: delete from ${schema-prefix}messages where queuename = ? and id = ? |
| messages-delete-sequence | Default: delete from ${schema-prefix}messages where queuename = ? and id between ? and ? |
| messages-update-single | Default: update ${schema-prefix}messages set deliverycount = deliverycount + 1 where queuename = ? and id = ? |
| messages-update-sequence | Default: update ${schema-prefix}messages set deliverycount = deliverycount + 1 where queuename = ? and id between ? and ? |
| messages-insert | Default: insert into ${schema-prefix}messages (queuename,id,priority,deliverycount,expirationtime,content) values (?,?,?,?,?,?) |
| messages-insert-oracle-1 | Default: insert into ${schema-prefix}messages (queuename,id,priority,deliverycount,expirationtime,content) values (?,?,?,?,?,empty_blob()) |
| messages-insert-oracle-2 | Default: select content from ${schema-prefix}messages where queuename = ? and id = ? |
| messages-insert-oracle-3 | Default: update ${schema-prefix}messages set content = ? where queuename = ? and id = ? |
| durables-select-all | Default: select clientid,durablename,topicname,selector,nolocal from ${schema-prefix}durables |
| durables-select-single | Default: select topicname,selector,nolocal from ${schema-prefix}durables where clientid = ? and durablename = ? |
| durables-insert | Default: insert into ${schema-prefix}durables (clientid,durablename,topicname,selector,nolocal) values (?,?,?,?,?) |
| durables-delete | Default: delete from ${schema-prefix}durables where clientid = ? and durablename = ? |
| xalog-select-all | Default: select id,content from ${schema-prefix}xalog |
| xalog-select-single | Default: select content from ${schema-prefix}xalog where id = ? |
| xalog-select-max-id | Default: select max(id) from ${schema-prefix}xalog |
| xalog-insert | Default: insert into ${schema-prefix}xalog (id,content) values (?,?) |
| xalog-insert-oracle-1 | Default: insert into ${schema-prefix}xalog (id,content) values (?,empty_blob()) |
| xalog-insert-oracle-2 | Default: select content from ${schema-prefix}xalog where id = ? |
| xalog-insert-oracle-3 | Default: update ${schema-prefix}xalog set content = ? where id = ? |
| xalog-delete | Default: delete from ${schema-prefix}xalog where id = ? |
Element "swap", Parent Element: "swiftlet"
Swap Settings.
Definition
| Attribute | Type | Mandatory | Description |
|---|---|---|---|
| path | java.lang.String | No | Path of Swap Files |
| roll-over-size | java.lang.Long | No | Roll Over Size |
Values
| Attribute | Values |
|---|---|
| path | Default: ./ |
| roll-over-size | Min: 1048576 Default: 10485760 |