Please know I always search the mail list archive before posting to the listserve. I usually find my answer without having to post. Thanks to those of you that take the time to answer all of our questions.
That said, I found much mention of datasourcelife (Feb/June 2005) and reports of it successfully opening, reuising and expiring datasources. Also of increasing the datasourcelife to prevent crashes. But no mention of the database (Oracle in our case) not abiding by Witango's call to expire a connection. I'll increase our datasourcelife setting from 30 to 90 so fewer connections are opened. We'll be running some more tests and seeing if we can find out why Oracle isn't closing expired Witango datasource connections. I'll let you know what we find out. Thanks, Matt [email protected] writes: >I think that issue was discussed in the past, and a known issue, you >should search the archives. > >-- > >Robert Garcia >President - BigHead Technology >VP Application Development - eventpix.com >13653 West Park Dr >Magalia, Ca 95954 >ph: 530.645.4040 x222 fax: 530.645.4040 >[EMAIL PROTECTED] - [EMAIL PROTECTED] >http://bighead.net/ - http://eventpix.com/ > >On Nov 16, 2006, at 2:13 PM, Matt Muro wrote: > >> We're doing some testing and noticed that while our Witango 5.5.018 >> logs >> report it is expiring DataSource connections after 30 minutes, as >> we have >> set by the datasourcelife setting in the witango.ini, our Oracle >> database >> is not closing these connections. Anyone know of a problem with >> Witango >> 5.5 and Oracle 9i or 10g? >> >> We have installed Oracle's 10.2 "instantclient" AND Oracle 9 >> drivers. 10g >> is first in Windows PATH: C:\instantclient_10_2;C:\oracle\ora90\bin >> >> Witango logs show datasources expiring: >> [Expired] Oracle datasource tns:oracle_prod >> >> Thanks, >> Matt >> >> ________________________________________________________ >> Matt Muro [EMAIL PROTECTED] >> Harvard University phone: 617.998.8522 >> Division of Continuing Education fax: 617.495.9176 >> >> ______________________________________________________________________ >> __ >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >________________________________________________________________________ >TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________ Matt Muro [EMAIL PROTECTED] Harvard University phone: 617.998.8522 Division of Continuing Education fax: 617.495.9176 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
