File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 63858

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] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: tomcat and oracle 8i.
It's not a secret anymore!