I wish I knew the specifics, maybe someone remembers...
But I am sure this same issue came up, and it was with oracle, the
issue was specific to oracle. I am just going by memory, but I think
the problem didn't occur when they went to oracle JDBC with witango.
I don't have many clients using the witango oracle combination....
However, I have a few, and there have been several issues with
witango/oracle, when NOT using jdbc. Give JDBC a try.
--
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 17, 2006, at 7:15 AM, Matt Muro wrote:
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
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
