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


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Newbie Conn Pool question" Watch "Newbie Conn Pool question" New topic
Author

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 hibernate.properties where they are accessing a MS SQL Server DB without using conn pooling?
Thanks.
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
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?

Thanks!
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Newbie Conn Pool question