...
| Expand |
|---|
|
| Code Block |
|---|
CREATE TABLE storagerecords (
context varchar2(255) NOT NULL,
id varchar2(255) NOT NULL,
expires number(19,0),
value clob NOT NULL,
version number(19,0) NOT NULL,
PRIMARY KEY (context, id)
); |
|
| Expand |
|---|
|
| Code Block |
|---|
CREATE TABLE StorageRecords (
context varchar(255) COLLATE Latin1_General_100_CS_AS NOT NULL,
id varchar(255) COLLATE Latin1_General_100_CS_AS NOT NULL,
expires bigint DEFAULT NULL,
value varchar(255) NOT NULL,
version bigint NOT NULL,
PRIMARY KEY (context,id)
);
| Note |
|---|
The value column must be arbitrarily wide to allow the JDBC storage service to back IdP Sessions |
JDBC Driver
You need to locate, download and verify the JDBC driver for your database and place it in edit-webapp/WEB-INF/lib.After populating edit-webapp/WEB-INF/lib you should execute bin/build.sh or bin/build.bat as appropriate for your environment.
...