• 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

WebSphere community edition 1.0.1.2 Database Pools connection problem

 
Ranch Hand
Posts: 109
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi ,
I am using WebSphere community edition 1.0.1.2 Database Pools connection for my databaseTransaction ,everything works fine with my retrieve query but when i do a create or update the data is viewed in my application but its not committed got the database. After doing so when i try to alter the particular record in the database manually i get a ORA error - 'resource busy and acquire with NOWAIT specified'.But this problem exist only in the server machine but the same connection pooling works fine in my machine. the Commit is given form the apllication level and its also closed properly. what could be the problem can anyone help me .
And there is also another interesting problem which i found ,that is when i update data using the appliation deployed in my server machine the data is appearing in the Screen. Now i open the same application from some other system ,the data which i have updated in another session is existing in this session also but this data is not available in Database. I guess both are using the Same connection.But is it possible?

please help. thanks in advance
Prem
 
There's a way to do it better - find it. -Edison. A better tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic