wood burning stoves 2.0*
The moose likes Websphere and the fly likes WAS+DB2+SESSION DATABASE Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "WAS+DB2+SESSION DATABASE" Watch "WAS+DB2+SESSION DATABASE" New topic
Author

WAS+DB2+SESSION DATABASE

thomas davis
Ranch Hand

Joined: Feb 01, 2003
Posts: 207
ENVIRONMENT
DATABASE: DB2
APPLICATION SERVER: WAS 6
SESSION MANAGEMENT :SESSION DATABASE.

Have followed the instructions given in the IBM WAS Official site for configuring the SESSION MANAGER with session database details

created session db in db2 with table space and buffer pool and page size
we used following script for executing it in db2
"db2 CONNECT TO <SESSION-DB>
db2 CREATE BUFFERPOOL sessionBP SIZE 1000 PAGESIZE 8K
db2 -tv ""CREATE TABLESPACE sessionTS PAGESIZE 8K MANAGED BY SYSTEM USING (' <Valid path for Tablespace>') BUFFERPOOL sessionBP;""
db2 CONNECT RESET
"
We have created datasource for session db in WAS
CONNECTION TESTED IT WAS SUCCESSFUL
IN SESSION MANAGER
WE NEED FOLLOWING CHANGES
ENTERED SESSION DB DATASOURCE NAME
PROVIDED TABLE SPACE NAME
ROW SIZE 8K AS IT IS GIVEN FOR DB2
MULTIROW CHECKBOX CHECKED

We are getting following error

2/28/08 8:50:39:836 GMT] 00000058 SessionContex E SESN0057E: BackedHashtableMR: a problem storing application data changes to the database. If a SQLException has occurred then
refer to the appropriate database documentation for your environment. Also, ensure that you have properly configured a datasource for Session Manager.

[2/28/08 8:50:39:862 GMT] 00000058 SessionContex E Session Object is:
Session Object Internals:
id : mRq8_y0YTX8zaZDmsIiXuYK
hashCode : 1502656331
create time : Thu Feb 28 08:31:32 GMT 2008
last access : Thu Feb 28 08:50:29 GMT 2008
max inactive interval : 1800
user name : anonymous
valid session : true
new session : false

overflowed : false

app name : default_hostservices/in/gdbilling

non-serializable app specific session data : null
serializable app specific session data : [repMainForm, approvalPopupForm, RBUser, rbParameterForm, costTypeDisplayForm, org.apache.struts.action.LOCALE, myEntriesForm, logonForm,
viewRepForm, costSetupForm, approvalForm]

app data changes : {repMainForm=services.in.gdbilling.ui.report.forms.RepMainForm@3634f75d, viewRepForm=services.in.gdbilling.ui.report.forms.ViewReportForm@18f1f75c}
app data removals : null
user write hit : false
max inact write hit : false
listener count hit : false
update : update sessions set lastaccess = ?
listener count : 0

cached : true
cacheId : 0001
cacheIdUpdated : false
syncFromServlet : true



[2/28/08 8:50:39:886 GMT] 00000058 SessionContex E Exception is: java.io.NotSerializableException: services.in.gdbilling.config.ReportDetails

Can anybody look into this error and give me solution?
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
The problem is here: services.in.gdbilling.config.ReportDetails

That object (and all objects that it references!) MUST be declared as java.io.Serializable in order to be stored in the Session database.

Kyle


Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at http://www.kyle-brown.com/ for other WebSphere information.
thomas davis
Ranch Hand

Joined: Feb 01, 2003
Posts: 207
1) is it due to serialization ?

2) 00000058 SessionContex E SESN0057E: BackedHashtableMR: a problem storing application data changes to the database. If a SQLException has occurred then
refer to the appropriate database documentation for your environment. Also, ensure that you have properly configured a datasource for Session Manager.
What does this signify?

3) What does this state ? 00000058 SessionContex E Session Object is:
Session Object Internals:
id : mRq8_y0YTX8zaZDmsIiXuYK
hashCode : 1502656331
create time : Thu Feb 28 08:31:32 GMT 2008
last access : Thu Feb 28 08:50:29 GMT 2008
max inactive interval : 1800
user name : anonymous
valid session : true
new session : false

overflowed : false

4) What is this all about?

non-serializable app specific session data : null
serializable app specific session data : [repMainForm, approvalPopupForm, RBUser, rbParameterForm, costTypeDisplayForm, org.apache.struts.action.LOCALE, myEntriesForm, logonForm,
viewRepForm, costSetupForm, approvalForm]

app data changes : {repMainForm=services.in.gdbilling.ui.report.forms.RepMainForm@3634f75d, viewRepForm=services.in.gdbilling.ui.report.forms.ViewReportForm@18f1f75c}
app data removals : null
user write hit : false
max inact write hit : false
listener count hit : false
update : update sessions set lastaccess = ?
listener count : 0
cached : true
cacheId : 0001
cacheIdUpdated : false
syncFromServlet : true
 
Don't get me started about those stupid light bulbs.
 
subject: WAS+DB2+SESSION DATABASE