Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

WAS+DB2+SESSION DATABASE

 
thomas davis
Ranch Hand
Posts: 207
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
thomas davis
Ranch Hand
Posts: 207
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic