The variable dataSourceLife is a system scope configuration variable that determines how long a database connection remains open after it is last used. The default value is 30 minutes. Each time the connection is used the timer is reset to zero. If there has been no activity for the time period in the setting, then the connection to the database is closed. Any subsequent calls to that data source open a new connection.
If dataSourceLife is set to zero, the connection is closed after each execution of a taf that makes a call to the data source. If there are multiple calls to the same data source in a single execution the data source does not close after each action, it remains open until the taf completes execution (i.e. the results are returned to the user). Hope this helps, Steve Smith Oakbridge Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.oakbridge.ca > -----Original Message----- > From: run run [mailto:[EMAIL PROTECTED] > Sent: March 2, 2003 3:53 AM > To: [EMAIL PROTECTED] > Subject: Witango-Talk: Question about database connection? > > > > I few questions but I will ask this one(s)first. > > I noticed when you create a query action > in a *.taf file(should it be *.waf,*.wcf, > or *.wep file now) from your witango file > editor you get a window pop up to ask you > to specify your database connection, > I am not sure when and how you tell witango > file to close the database session from the > application file. > > now, > when the witango file executes, > how does a connection session to a > database close after you have made your query.? > > Does a connection stay open or is it close > by witango after the action is finished > proccessing a query from the database? > > T.I.A. > > Tabi > > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Tax Center - forms, calculators, tips, more > http://taxes.yahoo.com/ > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
