I have found numerous documents on setting up a persistent session database using DB2. I had our DB group create a sessions table that follows the same spect that DB2 but using Oracle. on the admin console we keep on getting errors that are in the nature of errors trying to insert a long into a non long column. I know, the solution would be making the column a LONG in Oracle, but it is my understanding that LONG was depracated in Oracle and now they use a BLOB instead Has anyone encountered this and found a different solution? it specially happens on the MEDIUM colum.
Well man u have started the persistance process but i haven't reached there so far, so please can u tell me how to start persistance of session using WAS 5.0
Joined: Nov 11, 2003
Well I have set up the persistent session DB using Oracle Using the DB2 specifications in the IBM white paper entitled "http session best practices". in the DB specs for DB2 there is a data type for column named "MEDIUM" that is declared as a LONG in DB2. I have been told by our DBA staff that LONG is no longer supported in Oracle and that now it has been replaced by the BLOB. so in any case I am still looking for someone who has succesfuly implemented the persisten session DB using WAS 4.05 and Oracle 8.17 if anyone has any leads it is strongly appreciated.
subject: Websphere - persistent session DB - Oracle