Meaningless Drivel is fun!
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
It's not a secret anymore!