PowerBuilder multi-threading woes

[former_SQLA_member1694946]

I wrote a PowerBuilder framework that receives Winsock messages over the web and uses SharedObject multi-threading to process the messages. The framework demo uses MS Access and works great for me. My customer is using it with SQL Anywhere and reports all sorts of issues with it hanging up when multiple messages come in at the same time. Are there any tips on how to handle multiple simultaneous connections from the same process?

[chris_keating]

Can you expand on "hanging up". Is it PB or SQLA?

Are you using a single transaction object? In general, you may need to protect against the same connection executing operations at the same time. One way to approach this is instantiating the transaction object (you will need an object inherited from Transaction ) in the Winsock processing thread. The other is to use mutexes to prevent threads from stepping on each other. It has been a while but I don't think PB has native support for mutexes but implementing using the Windows API can be used.

[former_SQLA_member1694946]

PowerBuilder multi-threading gives each thread its own set of global variables including sqlca. Each thread makes a separate connection to the database. The main thread does not connect to the database. Is there a limit to how many connections can be made with the same userid ?

[chris_keating]

The personal server allows no more than 10 connections.

The default limit of concurrent connections for the network database server is equal to the maximum number of connections allowed by your per-seat license or 32766 connections if you have a per-core license. This can also be controlled by changing the default engine configuration i.e., max_connections option, login policies.

Note that if they are using a Developer Edition, there is a limit of 3 connections when installed. This can be changed with dblic command line utility as long as the usage aligns with the license agreement.

It would still be useful to understand what is meant by "hanging up".