problems when multithreaded
An external Rexx function package to connect to SQL databases
Brought to you by:
rexx
Menu
▾
▴
#2 problems when multithreaded
I'm just working on a multithreaded rexx-mysql program under os/2. For multithreading, I use rexx-ipc
(can be found in the attached file). If now one on the threads brings down his connection (they all
have different connection names), all other connections also die. A little sample is included (password
for the db has to be set correctly), which builds a connection to a db, selects some rows from it, then
starts a slave (with its own threadid, variablespace) which itsself builds a connection, selects the same
data an then closes his connection. If the master-process then continues, he has lost his connection.
see detailed describtion
Logged In: YES
user_id=559142
Meanwhile, the source of rexx-ipc was uploaded to hobbes.
Maybe this can help to solve the problem
Logged In: YES
user_id=86185
I've spent a couple of days on this problem, but still can't
resolve the problem. Rexx/SQL is not thread-safe. I have
made significant changes to improve its thread safety, but
obviously not enough :-(
I will keep working on this, but it probably won't be until
I release 2.4.
Logged In: YES
user_id=818502
Hello, I'm very new to REXXSQL and have just found myself in
this same situation.
Has any suggestions been offered? What did you do to get
around the problem?
Logged In: YES
user_id=1062841
Has there been any progress on the threading issue. I have
posted in the Help Forum about this .
Logged In: YES
user_id=86185
An update on the multi-threading capabilities of Rexx/SQL.
I now have a working thread-safe version of Rexx/SQL for
MySQL running under Windows. This has involved a
significant amout of work to get to this point, but the
fundamental principals and infrastructure have been implemented.
Thread-safety for other platforms and other databases (that
are thread-safe themselves) should involve much less work
and should be working within the next few weeks; all going
well!!