No, I agree. Witango is very particular. But in my experience, you
aren't going to get much help on the witango side with that, so you
are better off changing to mysql or mssql, or leaving witango.
The number of issues that have been brought up with oracle in the
past are very long. I am actually working with 2 companies that had
oracle. I already converted one over to mysql, and the second one in
the process. The second one, tried JDBC for oracle first, which was
better, but mysql is about the most trouble free database to use with
witango.
I use PHP on my biggest projects, and have a couple of installations
on oracle and I don't see the same issues that witango has.
As a side note, I originally moved to mysql, just to have a more
trouble free witango setup, which it DEFINITELY did. However, I
became a huge mysql advocate, and am in love with its power and
flexibility.
Just food for thought. But to sum up, MANY on this list have come up
against issues with oracle and witango, and there has been little to
no resolution.
--
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 Oct 1, 2007, at 3:35 PM, Shannon Henderson wrote:
We use JDBC with Filemaker and OCI with Oracle. We're not having
trouble with anything but Witango connections now. I'm finding it
harder to believe that all of the driver creators got it wrong and
Witango got it right...
On Oct 1, 2007, at 2:43 PM, Robert Garcia wrote:
The old database I used to use, would require this when for some
reason witango would burp or lost connection. It was very
frustrating, but I never found a way to just stop that one thread
from the witango side. It should be noted, that other dbs don't
require this. Both MS SQL 2000 and MySQL don't have this problem.
I can reboot mysql, and leave witango alone, and it will
reconnect. This led me to realize, it is more of an issue with the
ODBC driver/db from the vendor. I experimented with other code and
found this to be the case, outside of witango.
What database do you use?
--
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 Oct 1, 2007, at 1:20 PM, Shannon Henderson wrote:
Does anyone know if it is possible to kill open database
connections without restarting the witango server process? We've
had some cases lately where a connection will fail somewhere
between the witango server and the database server. Everything
but witango recognizes that the session is dead and ditches it.
Rather than starting a new session, witango just keeps returning
"113 Unable to communicate with the specified data source. The
existing connection was lost." on the old session until the
datasource timeout kicks in.
The problem is that the some other sessions are often fine, so I
hate to kill off everything if I can tell that there are specific
dead sessions.
--------------------------------------------------------------------
Shannon Henderson
Web Support Services
Reed College
Portland, OR 97202-8199
[EMAIL PROTECTED]
--------------------------------------------------------------------
____________________________________________________________________
____
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
