Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

tomcat and oracle 8i.

 
somesh rawat
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am using tomcat and oracle 8i. my q is is it necessary to open the database oracle to execute the query from a jsp page.
 
Scott Johnson
Ranch Hand
Posts: 518
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

is is it necessary to open the database oracle to execute the query


It is necessary to have an open database connection to run a query. You can open one yourself in your servlet, but it's better to obtain one from a connection pool.

Tomcat has a connection pool library that can manage the connections for you and allow the connections to be shared across the entire application. See the Tomcat documentation for more information.
[ December 18, 2006: Message edited by: Scott Johnson ]
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64967
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by somesh rawat:
my q is ...


"q" is not a word. Please use real words when posting to the forums.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic