Hi Jon,
On 01.06.2010 07:55, Sahananda (Jon) Wolfers wrote:
> Happiness is proving to be a little more ellusive than that.
:)
> Rexx\SQL is thread-safe as of Version 2.5 where the Database client
> software is thread-safe.
This is good.
> Rexx\SQL reports whether the client is known to be thread safe by the
> variable SUPPORTSTHREADS.
> SUPPORTSTHREADS is 1 where the client is known to be threadsafe and 0
> where it is not.
> In my case the variable SUPPORTSTHREADS is set to -11 :-(
Even if the database does not support threads you may still run your
ooRexx app in multiple threads as long as you make sure that the
interaction with the RDBMS is carried out by one worker thread only
("serializing access to the RDBMS").
> I have submitted a bug report to Mark although I think it is probable
> that Rexx\SQL is just reporting what the libMySql.dll returns from
> it's function mysql_thread_safe().
>
> It may be that upgrading MySQL from my current version (5.1.30) to the
> latest general release version 5.1.47, will resolve this, but a MySQL
> upgrade is not always a straightforward matter (they keep adding new
> reserved words).
Researching that corner a little bit it seems that MySQL can be compiled
with and without thread support, such that you would need to research
how your versions of MySQL got compiled.
Regards,
---rony
------------------------------------------------------------------------------
_______________________________________________
Oorexx-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/oorexx-devel
