Could you decribe this effect more detailed?
What is happening? Wich dataaccess method do you use?
Is it a mysql problem or a problem of the datacaching of dbforms?
Regards,
Henner
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have a simple MySQL database, JDBC, no connection pooling. I start off with "A", "B", and "C" in the MySQL rows. My devgui non-editable "list" page displays "A", "B", and "C".
I then go into the MySQL database and do an update of these three rows to "X", "Y", and "Z".
When I refresh the browser displaying the devgui-created non-editable "list" page, "A", "B", and "C" still display.
When I examine the database through another tool (dbTools), it shows the three rows to be "X", "Y", and "Z".
If I shutdown Tomcat 5 and start it up again, the devgui-created non-editable "list" page displays "X", "Y", and "Z".
At the same time I was doing this, I was working on another devgui-generated form that didn't work. This form displays the error messages that I was telling you about the other day ("can't find the datanbase table").
I think that the dbForms failure is locking up Tomcat somehow. This has driven me nuts because I've been thinking that my modifications to the devgui parameters and database structures haven't done any good, while really Tomcat is not working properly.
Thanks,
Charles Kogge
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am using devegui to create a list page with Tomcat 5 and MySQL.
The MySQL data will not refresh until I shutdown Tomcat and start it up again.
Does anyone have a fix for this? Maybe a Tomcat setting or a dbforms tag setting?
Thanks,
Charles Kogge
Could you decribe this effect more detailed?
What is happening? Wich dataaccess method do you use?
Is it a mysql problem or a problem of the datacaching of dbforms?
Regards,
Henner
Henner:
It is a sporadic problem - happens irregularly.
I have a simple MySQL database, JDBC, no connection pooling. I start off with "A", "B", and "C" in the MySQL rows. My devgui non-editable "list" page displays "A", "B", and "C".
I then go into the MySQL database and do an update of these three rows to "X", "Y", and "Z".
When I refresh the browser displaying the devgui-created non-editable "list" page, "A", "B", and "C" still display.
When I examine the database through another tool (dbTools), it shows the three rows to be "X", "Y", and "Z".
If I shutdown Tomcat 5 and start it up again, the devgui-created non-editable "list" page displays "X", "Y", and "Z".
At the same time I was doing this, I was working on another devgui-generated form that didn't work. This form displays the error messages that I was telling you about the other day ("can't find the datanbase table").
I think that the dbForms failure is locking up Tomcat somehow. This has driven me nuts because I've been thinking that my modifications to the devgui parameters and database structures haven't done any good, while really Tomcat is not working properly.
Thanks,
Charles Kogge
Could you try this with an hsql database?
Do you have the same effects?
I think first we should find out if its a mysql or a dbforms problems.
I can't believe that changes to devgui will break tomcat or the dbforms kernel.
Wich modifications do you did?
Do you get some other failures during running? What's about debugging?
Henner