• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 6 replies
  • Subscribers 12 subscribers
  • Views 4836 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

How Oracle Global Temporary Table works in Appian

Vinay Kumar Rai

Hi,

I have created a GTT table(ON COMMIT PRESERVE ROWS) and mapped to Appian CDT, but the database session seems expired in couple of seconds. how to prevent the database session?

 

Thanks

Vinay

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    Hi Vinay,

    Database session is managed by Appian Web App. There is no way it could be changed. Appian internally manages connection open, close and commit. Appian is dependent on Hibernate internally.

    You may need to change the approach .

    Can you please describe what you are trying to achieve ?
  • 0 in reply to Roopesh Rambhatla
    Hi Roopesh and Jose,

    I am trying to optimize the Oracle view which contains 30 columns and millions of records, we have a grid where user select the particular record, so in the back-end we execute the Stored Procedure and save all the data related to the selected record in the GTT table, and populate the grid using the table. it help the performance. but the Oracle DB session is expire after couple of minutes.
    We can use permanent table because of concurrency and need to delete the record every time.

    Do you have any alternative?


    Thanks
    Vinay
  • 0
    Certified Lead Developer
     in reply to Vinay Kumar Rai

    Hi Vinay,

    Having a Permanent table is a better solution. what I can suggest is have some kind of Identifier that marks the old records as invalid , so that you can avoid deleting them. As you are dealing with huge data set, the disabling can be achieved using stored Procedures. This approach is better from Audit perspective as well.

    Thanks & Regards
    Roopesh Rambhatla

Reply Children
No Data

© 2024 Appian. All rights reserved.