APAR status
Closed as program error.
Error description
Session Manager uses "appname" as one of the column name for
creating session table when using database persistence.
while updating the session table Session Manager uses "appName"
to set the column name in the prepared statement, this can cause
problems for database like sybase which are case sensitive and
the following exception may result.
[1/26/04 19:54:12:236 CST] 3fe96009 SessionContex E SESN0015E:
DatabaseSessionContext:processInvalidList - problem invalidating
session. The database invalidation of timed out sessions has
encountered
an error. 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.
[1/26/04 19:54:12:254 CST] 3fe96009 SessionContex E Exception
is:
com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name
'appName'.
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java(Compiled Code))
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java(Compiled Code))
at
com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java(
Compiled
Code))
Local fix
no work around
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users storing *
* session data in a Sybase database. *
****************************************************************
* PROBLEM DESCRIPTION: Session data is unable to invalidate in *
* Sybase database. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
There was a coding problem that the column name should be
appname not appName. Session Manager throws SQL Exception :
Invalid colunn name appName
Problem conclusion
Problem is identified and code is now fixed.
Temporary fix
Fix uploaded to
PQ99999.
Comments
APAR information |
APAR number |
PQ85108 |
Reported component name |
WAS BASE 5.0 |
Reported component ID |
5630A3600 |
Reported release |
00A |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2004-02-24 |
Closed date |
2004-05-10 |
Last modified date |
2004-05-10 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
Publications Referenced
Applicable component levels |
R003 PSY |
UP |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
R103 PSY |
UP |
R10A PSY |
UP |
R10H PSY |
UP |
R10I PSY |
UP |
R10P PSY |
UP |
R10S PSY |
UP |
R10W PSY |
UP |
|