Help - at wits end :(

[Barry G. Sumpter]

Brilliant!

Could you expand on "tickle"?
i.e. close and open or Select query?

Thanks,
    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 6:27 AM
To: Valentina Developers
Subject: Re: Help - at wits end :(

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
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina