Hi,

I wanted to know whether I can use Hibernate's connection pooling mechanism (coupled with C3PO) as a standalone.

I would like to write simple SQL statements on top of this.
Basically I do not have the flexibilty to use the many features of O/R mapping provided by hibernate.

But I have found Hibernate's connection pooling with C3PO to be just what I need. So can I write simple SQL statements on top of this. If so how????

I would like to use Hibernate only for connection pooling mechanism.

Thanks in Advance for any advice given.

Amit

If you just want a connection pool why don't you use just a connection pool? You can use c3po or dbcp standalone, too. Refer to their documentation.

I am just not able to find some standard documentaion on C3PO ....Moreover I am not sure if they support connection to multiple database's at runtime.

Any pointers will be greatly appreciated...

Thanks,
Amit

Look at the examples directory of the c3po distribution