Create a Database User and grant the privileges:


SQL> create user testuser identified by testuser default tablespace users quota unlimited on users;

User created.

SQL> grant connect , resource to testuser;

Grant succeeded.

SQL> alter user testuser temporary tablespace temp;

User altered.

Create the Table for JDBC Persistence :


SQL> create table wl_servlet_sessions ( wl_id VARCHAR2(100) NOT NULL,
wl_context_path VARCHAR2(100) NOT NULL, wl_is_new CHAR(1),
wl_create_time NUMBER(20), wl_is_valid CHAR(1), wl_session_values
LONG RAW, wl_access_time NUMBER(20), wl_max_inactive_interval
INTEGER, PRIMARY KEY (wl_id, wl_context_path) );
2 3 4 5
Table created.

Make a JDBC Datasource for the persistence using the Admin Console to refer to the schema just created.
In my case I name the data source as JDBC_TESTUSER



Set up session persistence in the Descriptor file ../WEB-INF/weblogic.xml :
In my case I am using an application : shoppingcart.war
So I edited the edit the shoppingcart/WEB-INF/weblogic.xml


<session-descriptor>
<persistent-store-type>jdbc</persistent-store-type>
<persistent-store-pool>JDBC_TESTUSER</persistent-store-pool>
</session-descriptor>
Here I am using OHS to proxy requests to the Weblogic Server

Re-create the application war file shoppingcart.war by using any archive utility.
Overwrite the existing file. For example:


cd shoppingcart
jar cf ../shoppingcart.war *
Now we can redeploy this application.