If you are storing session data in a database other than Sybase Adaptive Server Enterprise or Adaptive Server Anywhere, you must manually create the table that stores the session data. Create a table named ps_HttpSession with the following schema:
Column |
Data format |
|---|---|
ps_key (primary key). |
Variable length binary, 255 bytes maximum length, cannot be null. |
ps_size |
Integer, cannot be null. |
ps_bin1 |
Variable length binary, 255 bytes maximum length, can be null. |
ps_bin2 |
Variable length binary, 255 bytes maximum length, can be null. |
ps_bin3 |
Variable length binary, 255 bytes maximum length, can be null. |
ps_bin4 |
Variable length binary, 255 bytes maximum length, can be null. |
ps_data |
Binary large object. This type must be functionally equivalent to a Sybase image type. The JDBC driver used by the specified connection cache must allow access to the ps_data column using the JDBC setBytes and getBytes methods. |
The following table definitions can be used for creating an Oracle 8.1.7 database:
PS_KEY RAW (255) NOT NULL, PS_SIZE NUMBER NOT NULL, PS_BIN1 RAW (255), PS_BIN2 RAW (255), PS_BIN3 RAW (255), PS_BIN4 RAW (255), PS_DATA LONG RAW
