Memo : Weblogic JDBC Persistent Store

Script to use for table creation of a JDBC persistent store :

CREATE TABLE TABLE_NAME (
id     int  not null primary key,
type   int  not null,
handle int  not null,
record blob not null
);

The table name is computed with the prefix name defined at persistent store configuration with the appended string WLSTORE. So for exemple if prefix name is MYAPPLI, the table name will be MYAPPLIWLSTORE.

The command line to create the table could be :

java utils.Schema  url JDBC_driver  [options] DDL_file

options could be :

• -u for database connection username
• -p for the user password
• -s for the database SID

You will find hereunder is an example of the installation command line :

java utils.Schema jdbc:weblogic:oracle:DEMO weblogic.jdbc.oci.Driver -u user1 -p password1 -verbose   createTab.ddl