Hi,

I am trying to use Hibernate in my application with a MS SqlServer database. I found the jsql driver that rocks.
My question is : can I use the standard edition with Hibernate ? The main restriction of this version is that it just have one connection. Is there some cases where Hibernate need 2 connections at the same time ?

Thanks

Seb

Connection pools are used thus there is usually a way to configure the min and max size of the pool. In your case you need a min or 1 and a max of 1. Will it work - yes but your stuck if you get a hibernate request that turns out to be concurrent with an existing active access to the data source.

Check the docs for the appraoch you have chosen for setting up the datrasource for configuring the pool size.

I know how to limit the number of connections with the pool size and I do that. The limit of the pool size do not really care me because there isn't a lot of concurrent users in my app.
My main question is : is there a use case where Hibernate will need more than one connection to retrieve objects for one user ?
Please can you explain me what you mean when you say "your stuck if you get a hibernate request that turns out to be concurrent with an existing active access to the data source". What is the use case you are thinking about ?

Seb

Hibernate will use the currently associated connection as controlled by your current session object. It will not hold two connections open with the one session. If you have no chance of concurrent access then you will be fine (even though I am not sure why having a small pool matters much). My second comment was concerned with the behaviour of the application/connection pool manager when the connections have run out. The manager may block, may throw an acception or use wait with timeout.