This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "Websphere - persistent session DB - Oracle" Watch "Websphere - persistent session DB - Oracle" New topic

Websphere - persistent session DB - Oracle

Tony Per

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,
Navaid Ahmed

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

Tony Per

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.

It is sorta covered in the JavaRanch Style Guide.
subject: Websphere - persistent session DB - Oracle
Similar Threads
Query Dillema
For Oracle 8i, PreparedStatement Query fails for Key.
Difference between UDB and DB2
invalid column type exception on Oracle db
EJB3.0, mySQL, Queries & Entity Beans?