Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regarding JDBC Connection (URGENT)

 
Ankit Thakkar
Ranch Hand
Posts: 33
Android Java Mac PPC
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Friends,

Myself Ankit.
I am using java & oracle 10g.
Rightnow I am creating connection. Use it to insert data into tables.

But I want to make my program such that i can commit the insertion only at one time.

Suppose I have three webforms in child pages i am inserting some data into tables, but i m not committing in these two pages. But i m committing at master pages that is parent page to commit.

Now My question is that can i maitain only one connection throught the session. Like in oracle when we login, and do any operation it will visible through my session & not visible for the others until commit will be executed from my session. I want to perform this functionality through java.

Can anybody have any idea regarding this???
Please reply me as soon as possible......
 
Martin Simons
Ranch Hand
Posts: 196
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can, by saving the connection as a session object. In that case, however,
you had better have a session listener to close these connections (and do a
rollback to make be certain that by a timedout session nothing remains locked)
or you will soon use up all your connections with dangling cursors. This may
happen anyway, if you have a long timeout and a alot of users. That is one
of the reasons why this should never be done.
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You should not attempt to link sessions to connections as you are proposing; instead you need to collect the data on the different pages, store it in session variables, and use one transaction initiated by the final page to put it in the database.

Connections are very very expensive things to have open and not in use; in a web application, an open connection should either be being actively used, or in a connection pool waiting to be used, and nowhere else.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic