Hi Krishna;

   If you want to "hold" the transaction(s) open - then you cannot use a "local" transaction object reference as local variables are destroyed at the end of your script. The TO should be declared as either an Instance of something or another Global variable.

   For PowerServer Apps though, the "server" itself controls the connection an not your Web / Mobile App. Thus, you need to use a different approach called "Dynamic Transaction Object". This means that PowerServer contains the list of DB connections (aka DataSources). Then all your App needs to do is specify (redirect) PS as to which one to use based on the customer.

For example (with SQL Server): 

• SQLCA.DBMS = "MSS"
• SQLCA.DBParm="CacheName='CacheName" + <No> + "'"

Note: No Transaction object arrays or other TO variables are required ... Only SQLCA should be used!

HTH

Regards ... Chris

Hi Mr.Chris,

Thanks for your quick response.

I have already connected the sqlca with my main database using the connection cache concept in webserver. In our case while saving the transaction in main database using sqlca, I need to connect to different dependent databases (Eg: db1, db2 ... dbn) at the same time and once all the insert/update to these databases are successful then only I need to commit/rollback all the transaction objects including the SQLCA. For achieving this purpose I am using transaction object as array to handle all the dependent databases.

Thanks,

Krishnaprasad

Hi Chris,

Thanks For your suggestion and my apology for the delay in response.

We are using the same cache concept to connect the transaction object in deployed APP. In my sample I just shown as local transaction object but in actual code we are creating the transaction object as instance only.

The difference of my connection is, I am using array concept of transaction object like below example

(Eg: Transacton Tranobj[] // This Transaction object created as Instance variable

Long ll_row

Boolean lb_sucess = true

For ll_cnt = 1 To dw_dblist.rowcount() //Datawindow with total number of databases need to connect

 ll_row = upperbound(Tranobj)

 Tranobj[ll_row] = create transaction

 Tranobj[ll_row].Database = <sample>

 Tranobj[ll_row].LogId = <sampleid>

 Tranobj[ll_row].LogPass = <sampleLog>

 Tranobj[ll_row].DBMS = <sampleDBMS>

 Tranobj[ll_row].ServerName= <sampleserver>

 Tranobj[ll_row].DbParm = <ls_DbParm >

 Tranobj[ll_row].DBMS = 'MSS'

 Tranobj[ll_row].DBParm =ls_DbParm+" CacheName='"+<cache_name>+"'" 

  Connect using Tranobj[ll_row] // In deployed APP, error is throwing here. Its working fine in EXE

Next

//Once connection is successful then update the data to all the databases using the transaction array object

For ll_cnt = 1 To upperbound(Tranobj)
  update <table_name>
  set <col_name> = :value
  where <condition>
  using Tranobj[ll_cnt];

 // If any error while updating in any database then need to rollback all the connected transaction objects

 If Tranobj[ll_cnt].sqlcode <> 0 Then
   For ll_row = 1 To upperbound(Tranobj)
    Rollback Using Tranobj[ll_row];
    Disconnect using Tranobj[ll_row];
    Destroy Tranobj[ll_row]
   Next
   lb_sucess = False
   Exit
 End If
Next

//If No Error in above update statement then commit the transactions

If lb_sucess Then
  For ll_row = 1 To upperbound(Tranobj)
     commit Using Tranobj[ll_row];
     Disconnect using Tranobj[ll_row];
     Destroy Tranobj[ll_row]
   Next
End If

Please advise if Transaction object in array concept is not supported in PB APP deployed version and is there any Workaround for this.



Thanks in Advance..

0

Hi Krishna,

Thanks for reporting this problem! We reproduced it on our end and will do further research to figure it out. We will keep you posted on the progress.

Is it possible to work around the issue by using transaction object instead of transaction array, you can try to execute all operations in one for loop. For example:

Long ll_row

Boolean lb_sucess = true

For ll_cnt = 1 To dw_dblist.rowcount() //Datawindow with total number of databases need to connect

Tranobj = create transaction

Tranobj.DBMS = 'MSS'

Tranobj.DBParm =ls_DbParm+" CacheName='"+<cache_name>+"'"

Connect using Tranobj;

update <table_name>
set <col_name> = :value
where <condition>
using Tranobj;

If Tranobj.sqlcode <> 0 Then

Rollback Using Tranobj;
Disconnect using Tranobj;
Destroy Tranobj;

lb_sucess = False
Exit
End If

commit Using Tranobj;
Disconnect using Tranobj;

Next

Destroy Tranobj;

Regards,
ZhaoKai