Start transaction database activity and REFramework

Help Studio
, , ,
1

Hi,

How to approach the problem of using the start transaction activity?

I’m using Refframework and it connects to the database at the beginning (init block) and I need to use the start transaction activity in process block, but using the same connection causes the connection to be disconnected from the database. Later use of the same connection is not possible.

Leave the main connection for further DB-related operations, and create a new connection for the Start transaction activity itself, or maybe a different approach?

2

@mican

It has an output parameter as well…you can store the db connection again there …so that it persists for fUrther process.

Hope this helps

Cheers

3

@Anil_G
I receive but it requires reconnecting to the database

4

@mican

So is there any specific issue you are facing if reconnection is being done?

Cheers

5

@Anil_G

each connection to the database is time consuming

6

@mican

If you are trying to connect to same db using same connection two times is it not conflicting with the intial connection?

If its not…then your approach of using one connection for transaction activity and another for remaining all makes sense

Cheers

1 Like
7

@Anil_G thanks

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.