Hi all,

I am working on a desktop application and I have used Spring and Hibernate for the good stuff they do for developers.

My application is taking few mili-seconds to create a db connection each time something is to be done with the data base. Please tell me how can I save these mili-seconds. I could have used DBCP or C3P0 but thought that these technologies may be an overkill for my modest, single user desktop application. Also they will add to the footprint.

Is there any way, may be in Spring, Hibernate or JDBC so that I just instatiate a single connection (at application start) and use it for all the DB releated operations?

Any help will be much appreciated.

Thanks,
Nitin

I know you think it would be overkill to add DBCP or C3PO, but you could just set the pool size to 1.