aspose file tools*
The moose likes Websphere and the fly likes Websphere - persistent session DB - Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Websphere - persistent session DB - Oracle" Watch "Websphere - persistent session DB - Oracle" New topic
Author

Websphere - persistent session DB - Oracle

Tony Per
Greenhorn

Joined: Nov 11, 2003
Posts: 3
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.

Thank you,
--Tony
Navaid Ahmed
Greenhorn

Joined: Aug 16, 2002
Posts: 5
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


Navaid
Tony Per
Greenhorn

Joined: Nov 11, 2003
Posts: 3
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.

thanks,
--Tony
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Websphere - persistent session DB - Oracle