Clarity

  • Private Community
 View Only

  • 1.  XOG GEL script db connection issue

    Posted Nov 12, 2020 06:06 AM
    CA PPM 15.8.1 (On demand)

    Can someone help or advise on the below questions?

    1. We are using "  <gel:setDataSource dbId="niku"/> " to open the database connection.  Do we have any tag to close this connection
    2.   How does session Timeout work in gel script? If a user has a active session even then the session will get timed out based on the default value set in the system ?Do we need to create a session every time when it gets timed out in gel scripts?

    Thanks in advance for your help

    -Venkitta


  • 2.  RE: XOG GEL script db connection issue

    Posted Nov 13, 2020 05:05 AM
    Edited by David Morton Nov 13, 2020 05:06 AM
    See comment in here ; How session works in gel scripts

    (I don't think the same question needs to be asked at the same time 3 times in order to get a response)


  • 3.  RE: XOG GEL script db connection issue

    Posted Nov 13, 2020 04:09 PM
    Choosing which database connection string your calls will use, does not itself open a database connection that you need to close.  It's just a declaration that any sql:query (and related tags) you use, will know which database ID to use by default when requesting a connection to run against.

    I contributed a little more to the session discussion thread/question linked by David too.
    Original Message