• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Session Persistence not working in WAS 3.5.6

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
We use Websphere Standard Edition 3.5.6 on Windows 2000 with SQL Server 2000 as database. As a driver we are using Microsoft JDBC Driver for SQL Server 2000.
I have set Session Manager to store session information to SQL database according to documentation (enabled persistent session and selected the correct data source).
According to the documentation, the session data will be stored to db after the end of service method. I have noticed that the session id gets inserted to the db and the field 'small' seems to contain something (although updating session data doesn't change 'small' field in db).
When I restart the WebSphere service, the session id is correctly received while the session information is lost. I have even tried this with one of IBM's examples: HitCount servlet and it still doesn't work.
Any help much appreciated.
nenad
 
Nenad Vidovic
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
So I tried using Sybase instead and it works fine. Now I did remember reading somewhere that only WebSphere 4 is supported. This could be a problem. However, the row does get inserted into db the first time. It is only that updates are not done on the row (more specifically the last_updated is changed to new date but the 'small' value is not updated).
We didn't have any problems using the driver so far...
Does anyone know of a message board where SQL Server driver is discussed? Or does anyone have any more clues?
Thanks as allways,
nenad
 
reply
    Bookmark Topic Watch Topic
  • New Topic