approach other than connection pooling

[ankur rathi]

What is best approach for writing database operation in web application if you are not going for connection pooling?

Thanks.

[Paul Sturrock]

The is not likely to be any difference in the code, but your code is probably going to use up more database resources, since a Connection will actually equal a connection to the database, rather than sharing connections in the way connection pooling does it.

I suppose if you didn't want to use connection pooling you could try to write your code to share connections. But why bother? There are plenty of connection pool implementations out there, why reinvent the wheel?

[Jeanne Boyarsky]

Originally posted by ankur rathi:
What is best approach for writing database operation in web application if you are not going for connection pooling?

I guess that would just mean that you have your own connection factory that always creates a new connection. Make sure to close the connection when you are done so you don't have a resource leak.