<< Back to previous view

[JDBC-79] Add function to group multiple (nested) statements / method calls on one connection without commit / rollback mechanics Created: 11/Dec/13  Updated: 01/Jun/16  Resolved: 12/Dec/13

Status: Closed
Project: java.jdbc
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Enhancement Priority: Major
Reporter: Niels van Klaveren Assignee: Sean Corfield
Resolution: Completed Votes: 0
Labels: None


Currently, it is very easy to get spurious connection use on multiple statements,for instance by mapping a query function over a collection.
A workaround for this can be done by providing a binding through db-transaction.
However, this complects single connection use with commit / rollback mechanics that might be unwanted.

Another option is providing the binding yourself by wrapping it in a with-open/let construction.
This needs people to get into the implementation of the connection system, and might not play well with it.

Using connection pools is the last option, but usually is overkill for simple tasks.

Creating a macro and function that provides a simple binding for a connection in the way db-transaction does, without the included commit/rollback mechanics would do the trick. Such a function would play nice with the rest of the new connection propagation system (even including levels), and still doesn't rely on the rebinding of global vars.

Comment by Sean Corfield [ 11/Dec/13 10:55 AM ]

FYI: https://github.com/clojuredocs/guides/blob/master/articles/ecosystem/java_jdbc/home.md#reusing-connections

I'll probably add with-db-connection for this.

Comment by Sean Corfield [ 12/Dec/13 6:57 PM ]

Added with-db-connection. Will be in RC1.

Generated at Sun Jan 21 14:55:41 CST 2018 using JIRA 4.4#649-r158309.