JDBC connection

[evermore]

my question that i can't find an answer to


when you make connections
is the general rule one query for one connection ???


i've tested and it's possible to do many query for one connection


what is the downside of making new connection every query you do


what is downside of making one connection and using it for multiple queries


what is the standard usage ???

thanks for answer

[masijade]

The general rule is to get, use, and release a connection, statement, resultset, whateverSQLresource, in the most local manner reasonable.