aspose file tools*
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "tomcat and oracle 8i." Watch "tomcat and oracle 8i." New topic
Author

tomcat and oracle 8i.

somesh rawat
Greenhorn

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
Marshal

Joined: Jan 10, 2002
Posts: 60041
    
  65

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]
 
Consider Paul's rocket mass heater.
 
subject: tomcat and oracle 8i.
 
Similar Threads
Struts
Connection Pooling help needed
Connection Pooling help needed
Tell me one (Handy) DataBase for Java ?
oracle 8i features