• 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

Shareable or not shareable connections ?

 
Bartender
Posts: 1357
39
IBM DB2 Netbeans IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
HI folks,

I'm facing a srtange behavior concerning connection retrieved form datasources. In a servlet, i do a lookup via jndi of a datasource, and i get a connection with getConnectionMethod. In the deployment descriptor of my app (I use Rational V 7.0) , i define a reference to the datasource, and in the extension properties, I set
connection as Unshareable, and i define as preferred isolation level as Uncommitted read.

After applying the last PTF level, I noticed that, if I programmatically try and change the isolation level to another one, this change actually happens, but i got a warning in the log that, after a bit of search, seems to be related to a PTF that changes "connection sharing behavior". It seems a bit strange to me, 'cause I don't use shareable connections, so I'm in doubt about what exactly "shareable" and "shared" connection means.Are all connections retrieved from a pool considered now as "shared" ?

Can anyone help me to understand ?

 
Alas, poor Yorick, he knew this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic