I think I may have stumbled across a problem with Witango, JDBC and MySQL
I was hitting a page in my application listing the contents of a table and it wasn't listing everything, specifically it wasn't listing the record that i had just manually added via the MySQL Control Center. What I was able to determine was that it wasn't showing up because the JDBC connection was getting an Old snapshot of the data. Probably because Witango began a transaction, but never commited it, thereby causing the connection in the pool to have an Old view of the database.
I confirmed this by hitting the page again after hitting another taf file that had actual begin and end transaction actions in it. Now it shows the new data, but will not show newly added items. I have to go pickup dinner for my family so I haven't had a chance to make a very simple test case to reproduce, but I will, and I just was wondering if anybody else out there is using this type of configuration Witango 5, JDBC, MySQL.
/John
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
