Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Websphere - persistent session DB - Oracle

 
Tony Per
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Tony Per
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic