File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Newbie Conn Pool question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Newbie Conn Pool question" Watch "Newbie Conn Pool question" New topic

Newbie Conn Pool question

Andy Hahn
Ranch Hand

Joined: Aug 31, 2004
Posts: 225
I am playing around with hibernate in an attempt to learn it. I would like to create a DAO layer for my portlets and use hibernate versus straight sql. I am using MS SQL Server and Tomcat as an app server. I would like to not use connection pooling through Tomcat. Most examples I have read online use Conn Pooling. Does anyone have a code snippet from where they are accessing a MS SQL Server DB without using conn pooling?
Lasse Koskela

Joined: Jan 23, 2002
Posts: 11962
So do you want "no connection pooling at all" or "no connection pooling through Tomcat"?

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
Andy Hahn
Ranch Hand

Joined: Aug 31, 2004
Posts: 225
I guess I am not sure. I think what would work best is to set up a datasource in Tomcat for my application. (I am trying to avoid as much application server setup as possible since I am building a portlet for a very large project). Does a Tomcat datasource automatically create a datasource? What do you recommend?

I agree. Here's the link:
subject: Newbie Conn Pool question