Sybase db calls in multi-threaded environment 
Author Message
 Sybase db calls in multi-threaded environment


> 3) We tried adding mutex locks before the sybase function ct_results
> and unlocked after the same (In pre compiled embedded sql c code).
> Under this circumstance the above mentioned threads worked fine .
> (ct_results is a library function provided by sybase). But this doesn't
> meet our requirement since this serialises the db calls.
> sybase server           :SQL server R11
> sybase c pre compiler   :ESQL/c PreCompiler/10.09/p/SUN-svr4/SPARC
>                          Solaris 2.3/1/
> ct_library              :CS_VERSION_100
> Threads library         :POSIX , Solaris UI
> Operating system        :Sun solaris 2.5
> Hardware                :Sun (ultra sparc) Workstation.

You need CT-Lib 11.1 or later which has facilities for Thread-safety.
Your solution 3) is the only workable method in prior versions.  The
behavior you describe about only being able to make connections from
the main thread has been observed by many, with both CT- and DB-Lib.

                        -=- D. J.

Tue, 25 Apr 2000 03:00:00 GMT
 [ 2 post ] 

 Relevant Pages 

1. Open ADORecordset returning error into multi-threaded environment for single connection

2. Database contexts in a non multi-threading environment

3. Reading records in a multi-threaded environment..

4. Opening ADORecordset returning error into multi-threaded environment for single connection

5. Help with multi-threaded SQLConnect calls

6. Multi-threading DB Updates

7. DB interface/connection initialization under multi-threading

8. Multi-threaded Ole db Consumer issue

9. Multi Thread + GUI + DB = TROUBLE!

10. Problems with DB connections and Multi-threaded apps

11. DB-Lib - Multi - threaded app on Solaris

12. Sybase and Multi Threading

Powered by phpBB® Forum Software