wood burning stoves
The moose likes JSP and the fly likes tomcat and oracle 8i. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "tomcat and oracle 8i." Watch "tomcat and oracle 8i." New topic

tomcat and oracle 8i.

somesh rawat

Joined: Dec 10, 2006
Posts: 3
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

Joined: Aug 24, 2005
Posts: 518

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

Joined: Jan 10, 2002
Posts: 63222

Originally posted by somesh rawat:
my q is ...

"q" is not a word. Please use real words when posting to the forums.

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
I agree. Here's the link: http://aspose.com/file-tools
subject: tomcat and oracle 8i.
It's not a secret anymore!