Solving problems with Distributed PB Apps

Question:
I had some problems with distributed applications. I developed a DPB project (both the server and the client). The server has a NVO that connects to a database and retrieves information. It works great but when I want to make more than one client connection at the same time, it causes problems. My server application crashes and sends the next message to the clients connected. “Error 55 Request terminated abnormally”. To focus the problem, I disabled the code that makes the connection to the database in the server and the problems disappears. That means that the object connection is not the problem. The problem is when i call the function from the remote NVO that makes the connection to a database. The technique that i use is using an instance variable SQLCB (transaction type) in my NVO. So I make the connection in that function (one for each client because it’s an instance varible ).

Maybe that technique is not working. Another solution that i read in Masters of Powerbuilder book is using a global SQLCA in the server and use the dbhandle function to know if the connection is established or not (One connection for all the clients).

I try it too but i have the same results. Pleasehelp me. I’m gonna appreciate that.

Answer:
You do not specify your DBMS so i’m going to tell you about two problems that I know about that could be causing the problems you describe.First of all if you are using Oracle and you are using SQLNet V2.2.x, you will need to upgrade to SQLNet V2.3 as there is a bug in that version that causes an error when you use Distributed PB.Second try making a connection to the DB from your dummy server window beore you start the server listening. This will add one database connection to the transaction pool and it seems to stabilize the pool and stop problems with the database connections.One last note is that you should not use SQLCA in your application server objects. If you ever want to use the same object in a transaction server such as MTS or Jaguar then you will run in to problems as SQLCA does not exist in those environments. Actually you cannot use a single global variable so that also rules out PFC!

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS