Win a copy of Kotlin in Action this week in the Kotlin forum!
    Bookmark Topic Watch Topic
  • New Topic

simultaneous hit to insert in database  RSS feed

Manish M Malhotra M
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.

Manish Malhotra

Its difficult to break a hard nut but its not impossible
Jeanne Boyarsky
author & internet detective
Posts: 37234
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please don't cross-post the same thread in multiple forums.
Consider Paul's rocket mass heater.
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!