File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Simoltaneous insertion giving problem. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Simoltaneous insertion giving problem." Watch "Simoltaneous insertion giving problem." New topic

Simoltaneous insertion giving problem.

Manish M Malhotra M

Joined: Jul 06, 2004
Posts: 6
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

Joined: May 26, 2003
Posts: 33106

Try inserting some logging statements to see where the code is hanging.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Manish M Malhotra M

Joined: Jul 06, 2004
Posts: 6
Actually I have tried this, but I'll do it again thoroughly and then let you know. Previously I tried randomly.

Thanks & Regards,
Manish Malhotra.
I agree. Here's the link:
subject: Simoltaneous insertion giving problem.
It's not a secret anymore!