Re: Witango-Talk: Witango 5.5 / JDBC / MySQL

[Jason Schulz]

What happens when you use a third tool to query the data - does the data returned to it match Witango or the MySQL CC?

It's not clear from what you've written, but are you sure that MySQL CC is committing its transactions?

J.

On 24/03/2005, at 10:11 AM, 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

<x-tad-bigger>
</x-tad-bigger><x-tad-bigger>WITH IMAGINATION
</x-tad-bigger><x-tad-bigger>Planning, Implementation and Management of Web Applications
</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>160 Pacific Highway North Sydney NSW Australia 2060</x-tad-bigger><x-tad-bigger>
</x-tad-bigger><x-tad-bigger>phone +</x-tad-bigger><x-tad-bigger>�</x-tad-bigger><x-tad-bigger>612 9929 9229</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>fax +</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>612 9460 4770</x-tad-bigger><x-tad-bigger>�
</x-tad-bigger><x-tad-bigger>web -</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>email -</x-tad-bigger><x-tad-bigger> </x-tad-bigger><x-tad-bigger>[EMAIL PROTECTED]
</x-tad-bigger>