Yes, that is what I remembered...
Now, I have a client on oracle, and we moved them to jdbc, and many
issues we saw with witango and oracle, went away. But I would agree,
it seemed like the issues, were witango related, as I haven't seen
those issues with other software.
--
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 9:56 AM, MC Tay wrote:
We are also experiencing the same problem; and the Oracle thread
count is not released upon the expiration of datasource. We have
contacted Witango support long time ago but they didn't seem to
have any answer.
We use Witango 5.5.09 and Oracle 9i. I think the problem is on the
Witango side .... because if we login to Oracle with Oracle tools,
i.e. SQL Plus, or Oracle Enterprise Manager, its thread count went
up by one, and upon exiting the tool it releases the thread count
by one. But, not in the case of Witango. We have to stop and
restart the Witango service from time to time during off peak
period too ---- pain in the neck :-)
M.C. Tay
At 10:28 AM 11/17/2006, you wrote:
We have experienced this issue since upgrading to Oracle 9/10. We
found that restarting the witango process was clearing the open
sessions. So we've set our datasourcelife higher which means
sessions are less likely to time out in the first place, and we've
set up a cronjob to restart the server process during non-peak
periods.
That doesn't really give you an answer to why it's happening, but
it might help you configure a workaround.
--------------------------------------------------------------------
Shannon Henderson
Web Support Services
Reed College
Portland, OR 97202-8199
503.517.7745
[EMAIL PROTECTED]
--------------------------------------------------------------------
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
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
