Are odbc connections supposed to support multiple threads?
am 16.01.2008 05:53:15 von don-iscompI have a java applet that originally used the mysql java connector.
The applet uses multiple threads and they all share the same database
connection. I recently started using another driver that uses odbc.
I now find that I have problems when two threads try to use the
connection at the same time. My debug output shows things like this:
thread1: CallableStatement c1 = prepareCall(...)
thread2: CallableStatement c2 = prepareCall(...)
thread1: if (c1.getMoreResults()) ...
thread2: if (c2.getMoreResults()) ...
Normally both calls to getMoreResults should return true, but with
this interleaving the second one returns false.
Is this supposed to work with myodbc? Or is there something that
you're supposed to do in order to make it work? Or was it never
expected to work? I'd appreciate pointers to existing documentation
that answers these questions.
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org