Random thought based on complete ignorance:
* Have an error handler trap error -113 and then run a stored
procedure to have Oracle kill the connection from its side.
* Have an error handler trap error -113 and then run set the
DataSourceLife to immediately expire, and then reset it to normal.
Bill
William M. Conlon, P.E., Ph.D.
To the Point
2330 Bryant Street
Palo Alto, CA 94301
vox: 650.327.2175 (direct)
fax: 650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web: http://www.tothept.com
On Oct 5, 2007, at 9:37 AM, Shannon Henderson wrote:
Sure, we have seen those too with FM7; 8 has resolved some of those
issues for us.
These are cases where something happens like a network hiccup that
kills the connection. This is definitely a case where the db
connection is not properly closed. It's also a situation that is
bound to happen from time to time. The db connections that fail
start returning a connection lost message. If persistent
connections are set, Witango just keeps trying to use the dead
session until it times out.
In my ideal world, if Witango got that error, it would actually
close the connection. If it could open a new connection, there
would be no error. I'm sure there a billion reasons why someone
else wouldn't want that to happen. I'd settle for trapping for it
and killing the connection myself, but I don't know if there is a
way to do that. Is there? Right now, that would rock my world.
All in all, I know there are issues. What I'm looking for is a
stopgap that doesn't involve restarting the server and killing all
of the sessions. Right now we have to kill the server and sessions
to almost 100 databases to fix a broken connection to one database.
I'm hoping there is something less heavy handed. If no one has been
able to find a way to do that, we'll just keep on swearing and
otherwise doing what we're doing.
Thanks for an unreligious technical reply. :)
--sh
p.s.
We've already tried turning off the persistent connections, and
then it seems that Witango oracle sessions never close (new
behavior since Oracle 9+), and we end up with a bunch of idle
sessions on the Oracle side. This is very naughty behavior that
made our dba swear, throw up his hands, and start a personal
crusade to rid the network of Witango servers. Less than ideal, i
assure you.
On Oct 5, 2007, at 6:55 AM, Dan Stein wrote:
Shannon,
There are know issues with xODBC and Filemaker 7-9 I am not sure
if they extend to JDBC but there are related to the FMP plug in in
not Witango as I can reproduce them with any ODBC connection to FMP.
I have been working for 1 year with FMI to resolve these.
We are close.
They are
Out of memory errors which cause the plug in stop responding at
all ( these seems resolved with 9)
Failure to close connections properly when shutting down the DB
Dan
--
Dan Stein
FileMaker 7 Certified Developer
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 215-799-0192 (call 1st)
FMP, WiTango, EDI,SQL 2000, MySQL, PHP
[EMAIL PROTECTED]
"The mind is its own place and in itself can make heaven of hell
or a hell of a heaven." John Milton
On Oct 1, 2007, at 6: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
______________________________________________________________________
__ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
