Description

Oracle Version 7.3 on Windows and Macintosh provides support for thread safety in its client libraries. To enable this feature, the Oracle 7.3 database interface in PowerBuilder and InfoMaker on Windows and Macintosh includes a new DBParm parameter named ThreadSafe. ThreadSafe specifies whether your connection should take advantage of the Oracle 7.3 thread-safe client libraries.

By default, ThreadSafe is set to No to specify that your connection does not use the thread-safe client libraries. This setting is recommended when you build nondistributed applications that require a single-threaded environment. To specify that your connection should use the thread-safe client libraries, set ThreadSafe to Yes. This setting is recommended when you build distributed applications that require a multithreaded environment.

Purpose

Setting ThreadSafe to Yes to take advantage of the Oracle 7.3 thread-safe client libraries enables you to build distributed applications in PowerBuilder, InfoMaker, or Web.PB without the risk of side effects among multiple threads making calls to the Oracle database server. Note, however, that your application may incur a performance penalty by using the thread-safe client libraries.

Usage

As with any other DBParm parameter, you can set ThreadSafe in the Database Profile Setup dialog box for your connection or in a PowerBuilder application script.

You must specify a value for ThreadSafe before connecting to the database in PowerBuilder or InfoMaker.

The ThreadSafe DBParm parameter applies only when using the Oracle 7.3 database interface in PowerBuilder or InfoMaker on the Windows and Macintosh platforms. Due to limitations in the Oracle Call Interface (OCI) on the UNIX platform, ThreadSafe is not available with the Oracle 7.3 interface in PowerBuilder on UNIX.