Solving problems with Distributed PB Apps

Solving problems with Distributed PB Apps

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.

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:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular

XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved