Help - at wits end :(

[Bernet, Eytan]

Trick proposed by my co-worker....

I have set up a 30 second times in Director, and I just "tickle" the
database with a query once every 30 seconds. Seems to have resolved the
problem.
Eytan



On 7/9/07 12:03 PM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

> Hi Eytan,
> 
> I have the same type of issues which may be completely unrelated.
> 
> I've posted warning reminders to myself on:
> http://www.barrysumter.com
> 
> I would be very interested to know if find any of the warnings remotely
> relevant.
> 
> Hth
>      Barry G. Sumpter
> 
> -----Original Message-----
> From: valentina-bounces at lists.macserve.net
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Bernet, Eytan
> Sent: Tuesday, 10 July 2007 4:26 AM
> To: Valentina Developers
> Subject: Help - at wits end :(
> 
> I have an application that I am supposed to ship already. All the coding is
> done, and everything seemed to work great.
> 
> I am using the V4MD Xtra, version 2.5.10
> 
> I can get info from the database all I want, and everything works. I can let
> the program sit idle, click on a student in my application, and have
> database queries work fine.
> I can assign an activity to the students, creating a new record, and
> everything works fine (again, all this using SQL queries)
> I can then Querry the database the same way, and everything works fine.
> 
> However, if I let my program sit idle AFTER modifying the database, for more
> than a minute or so, the application quits (either my app is I create a
> runtime, or the director environment). It reports that the connection is no
> longer open, I open it, and then havoc ensues. Note I am not CLOSING the
> connection, and yet it closes.
> 
> Has anyone else seen this? Does anyone else know how to solve this? I am
> about to add a timer to director that if no database queries are done for 59
> seconds, I close the database, destroy the Valentina Xtra, and recreate it.
> This is driving me crazy, I have been tackling it for a week now, with no
> solution in site.
> 
> 
> Please please please help
> 
> Eytan Bernet
> McGraw-Hill Education
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina