Hi,
We are using single-row, medium setting websphere session persistence and getting following error while persisting session information:
[2/21/03 10:04:58:195 EST] 138a5938 SessionContex X SESN0042E: BackedHashtable:ejbCreate - database error. If a SQLException has occurred then refer to the appropriate database documentation for your environment. Also, assure that you have properly configured a datasource for Session Manager.for session
Session Object Internals:
id : YPMWAV50O4WDSOBNTC41YFA
hashCode : 194943235
create time : Fri Feb 21 10:03:54 EST 2003
last access : Fri Feb 21 10:03:54 EST 2003
max inactive interval : 1800
user name : anonymous
valid session : true
new session : true
session active : true
overflowed : false
session application parameters : com.ibm.servlet.personalization.sessiontracking
.SessionApplicationParameters@5ce81936
session tracking pmi app data : com.ibm.servlet.personalization.sessiontracking.
SessionTrackingPMIApplicationData@46b59936
enable pmi : true
non-serializable app specific session data : {}
serializable app specific session data : {user=com.test.display.SessionUser@7c0
f5903, HISTORY_KEY=[/]}
app data changes : {}
app data removals : null
user write hit : true
max inact write hit : false
listener count hit : false
update : insert into sessions (id, propid, appname, listenercnt, lastaccess, cre
ationtime, maxinactivetime, username, small, medium, large) values (?, ?, ?, ?,?, ?, ?, ?, ?, NULL, NULL)
listener count : 0
buflen : 3510
cached : false
cacheId : 0001
cacheIdUpdated : true
I verified size of session information which is approx 3.5Kb which is very small. In fact we tried to use "multi-row" sesion also just to verify if session size is the issue, but still we were getting the same error consistently. Also, the same code works fine in one other development server.
Thanks in advance!
SK