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

simultaneous hit to insert in database

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
Hi All,

Im using WAS5.1. My application is inserting in 2-3 tables (of ORACLE 9i)
. But Im Im hitting the URL continously then a fraction of mili seconds time then the screen is hanged.
Im using DATA Source of WAS and its inbuilt connection pooling.

(DAO) Database classes are called by the Stateless session beans.
And One DAO Factory to get the DAO objects. Actually only one object would be created for each DAO . Factory maintain synchronized hashMap of these objects.
Each method (delete, add etc) having there local class level variables for Connection, Statement etc. so that even the object is single every time these would be created newly.
So, this should be thread safe. (I hope so). Because same funda we use in the Servlets also.

So, please help me as soon as possible. I need it badly.

Thanks in advance.

regards,
Manish Malhotra
SE, PCS
--------------------

Its difficult to break a hard nut but its not impossible
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
Manish,
Please don't cross-post the same thread in multiple forums.
 
Don't get me started about those stupid light bulbs.
    Bookmark Topic Watch Topic
  • New Topic