Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
    Bookmark Topic Watch Topic
  • New Topic

simultaneous hit to insert in database

 
Manish M Malhotra M
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • 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
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34095
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Report post to moderator
Manish,
Please don't cross-post the same thread in multiple forums.
 
    Bookmark Topic Watch Topic
  • New Topic