Help - at wits end :(

[Ivan Smahin]

Hello Eytan,

Monday, July 9, 2007, 9:25:44 PM, you wrote:

BE> I have an application that I am supposed to ship already. All the coding is
BE> done, and everything seemed to work great.

BE> I am using the V4MD Xtra, version 2.5.10

BE> I can get info from the database all I want, and everything works. I can let
BE> the program sit idle, click on a student in my application, and have
BE> database queries work fine.
BE> I can assign an activity to the students, creating a new record, and
BE> everything works fine (again, all this using SQL queries)
BE> I can then Querry the database the same way, and everything works fine.

BE> However, if I let my program sit idle AFTER modifying the database, for more
BE> than a minute or so, the application quits (either my app is I create a
BE> runtime, or the director environment). It reports that the connection is no
BE> longer open, I open it, and then havoc ensues. Note I am not CLOSING the
BE> connection, and yet it closes.

BE> Has anyone else seen this? Does anyone else know how to solve this? I am
BE> about to add a timer to director that if no database queries are done for 59
BE> seconds, I close the database, destroy the Valentina Xtra, and recreate it.
BE> This is driving me crazy, I have been tackling it for a week now, with no
BE> solution in site.


Take a look at VServer.ini :

MaxClientTimeout=20;             Specifies the IDLE timeout in minutes for a client.
;                                On timeout VServer will disconnect that client.
;                                0 - means inifinite timeout.

There is only reason to disconnect client in that way.
Probably that period is too short.


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com