• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Websphere - persistent session DB - Oracle

 
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
 
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
 
Consider Paul's rocket mass heater.
    Bookmark Topic Watch Topic
  • New Topic