John,
I haven't looked for it. If you can spell out a test case, I can try it out. I am running Witango 5 / myodbc /MySQL 3.23 on Redhat 9. I was planning to try testing W5.5 soon.
I can probably set up a JDBC connector pretty quickly also.
Bill On Wednesday, March 23, 2005, at 03:11 PM, John McGowan wrote:
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
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
