A JDBC connection should have a reset method to reset it to the original state

[olavloite]

Applications that use a connection pool might set certain properties on a JDBC connection. These will 'leak' to other users of the same session pool if the user does not reset the connection manually. Having a generic reset method will make this easier for users.

Unfortunately there is no generic reset method in the JDBC API.

There should also be a SQL command that can do the same, so it can be registered as a reset SQL command in the connection pool