Spring Transactional Support

Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Spring Transactional Support

Robert Price-2
Seeing conflicting information and wanted to confirm that the transactional annotation was supported by sping jdbc. Also wanted to see if anyone had attempted to set session variables in postgres before executing a query.
Reply | Threaded
Open this post in threaded view
|

Re: Spring Transactional Support

Dave Cramer-8
Hi Robert,

Care to elaborate on the question ?


On 10 October 2017 at 20:36, Robert Price <[hidden email]> wrote:
Seeing conflicting information and wanted to confirm that the transactional annotation was supported by sping jdbc. Also wanted to see if anyone had attempted to set session variables in postgres before executing a query.

Reply | Threaded
Open this post in threaded view
|

Re: Spring Transactional Support

Dave Cramer-8
Well I don't think the driver itself has any issue with this, nor does it care about the annotation. This is all hibernate AFAIK ?


On 11 October 2017 at 23:39, Robert Price <[hidden email]> wrote:
Yeah I was thinking of using the @transactional annotation to do transactions in postgres and wanted to verify that postgres supported this annotation. Use case would be to set session variables and then use a table filter that referenced the session variables. Requires multiple queries to be run in the same session/transaction


On Wed, Oct 11, 2017 at 11:35 AM, Dave Cramer
Hi Robert,

Care to elaborate on the question ?


On 10 October 2017 at 20:36, Robert Price <[hidden email]> wrote:
Seeing conflicting information and wanted to confirm that the transactional annotation was supported by sping jdbc. Also wanted to see if anyone had attempted to set session variables in postgres before executing a query.


Reply | Threaded
Open this post in threaded view
|

Re: Spring Transactional Support

Dave Cramer-8
Spring should still do all the work. It doesn't know what driver is underneath it.


On 12 October 2017 at 10:52, Robert Price <[hidden email]> wrote:
Ok thanks will give a shot then. It is a spring boot project and we are using jdbc for db queries so not using hibernate. 



From: Dave Cramer <[hidden email]>
To: "[hidden email]" <[hidden email]>; List <[hidden email]>
Sent: Thursday, October 12, 2017 6:33 AM
Subject: Re: [JDBC] Spring Transactional Support

Well I don't think the driver itself has any issue with this, nor does it care about the annotation. This is all hibernate AFAIK ?


On 11 October 2017 at 23:39, Robert Price <[hidden email]> wrote:
Yeah I was thinking of using the @transactional annotation to do transactions in postgres and wanted to verify that postgres supported this annotation. Use case would be to set session variables and then use a table filter that referenced the session variables. Requires multiple queries to be run in the same session/transaction


On Wed, Oct 11, 2017 at 11:35 AM, Dave Cramer
Hi Robert,

Care to elaborate on the question ?


On 10 October 2017 at 20:36, Robert Price <[hidden email]> wrote:
Seeing conflicting information and wanted to confirm that the transactional annotation was supported by sping jdbc. Also wanted to see if anyone had attempted to set session variables in postgres before executing a query.





Next Thread