Ricardo: Thanks for your answer. I have been using a own class inherited from connection that, until gambas3 migration of my applications, works fine with opens and closes of Mysql databases (I attach it here). The idea is forget all the thing and let the class do the work. I suspect that the fault lies on my client's lack of updates. I'll look into it more before bothering everybody in the mailing list.
Regards 2013/4/11 Ricardo Díaz Martín <oceanosoftlapa...@gmail.com> > Hi Jorge, > > I'm using gambas like mysql front end apss for a long long time too. I > have never experimented this problem. My question is why do you need > to keep open database connection for a long time? I only keep open > connection for a while when I retrieve/save information from database. > Maybe it's easy for you to change your code to open connection when > required and immediately close after read/write process. Or maybe > not... > > Not glad to help you :-( > > cheers > Ricardo Díaz > > 2013/4/11 Jorge Carrión <sho...@gmail.com>: > > A few weeks ago I post a comment about a bug in gb-db-mysql (I guess) > about > > the loosing of language preferences after de time-out close connection of > > mysql server. The solution aparently was to increase the time-out in the > > server but, if the time-out is too big, then my application hangs after a > > unindetermined amount of time... > > I back to decrease the time-out of server and the application doesn't > hangs > > any more... but the language preferences are loosed again. > > I've read somewhere that this bug have been fixed in 3.4.0 version of > > Gambas3, but I've installed de 3.4.1 of the Nemh Repositories and the bug > > is not fixed. > > What can I do? I'm Spanish and all my databases are in UTF-8 general... > my > > clients are very angry with me... help, please. > > > > Thanks in advance > > > > Regards > > > ------------------------------------------------------------------------------ > > Precog is a next-generation analytics platform capable of advanced > > analytics on semi-structured data. The platform includes APIs for > building > > apps and a phenomenal toolset for data science. Developers can use > > our toolset for easy data analysis & visualization. Get a free account! > > http://www2.precog.com/precogplatform/slashdotnewsletter > > _______________________________________________ > > Gambas-user mailing list > > Gambas-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > ------------------------------------------------------------------------------ > Precog is a next-generation analytics platform capable of advanced > analytics on semi-structured data. The platform includes APIs for building > apps and a phenomenal toolset for data science. Developers can use > our toolset for easy data analysis & visualization. Get a free account! > http://www2.precog.com/precogplatform/slashdotnewsletter > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------------ Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis & visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
