1. Santosh Pawar
  2. PowerBuilder
  3. Tuesday, 9 May 2017 10:18 AM UTC

We have multiple users, using same .exe from shared folder (shared folder exist in server), recently i installed the Application first time for one new user but a error is coming

like "Transaction already connected", remaining all users its working fine. i restarted his machine but still issue exist. we are using DB as Oracle 11g and PB 12.5.

Please any hints on this?

Error : Database Connect Error, Database error detected during connect, Transaction already connected
           
           

 

 

Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 10 May 2017 02:44 AM UTC
  2. PowerBuilder
  3. # 1

I can get some sample code tomorrow, but in a nutshell this is the flow:

1. Before you attempt to connect, put a simple SELECT count(*) INTO l_result from TABLE_1;

2. Check the SQLCA.sqlCode. The results will tell you if you succeeded or failed.

3. If you succeeded, then you are already connected!

 

Later -

Olan

Comment
There are no comments made yet.
Chris Pollach Accepted Answer Pending Moderation
  1. Tuesday, 9 May 2017 18:59 PM UTC
  2. PowerBuilder
  3. # 2

Hi Santosh;

   Sounds like a message that gets issues from your PB App. I would also assume that its related around issuing the Connect DB command. I would review your source code and see exactly where & why that message gets displayed.

Regards ... Chris

Comment
  1. Berka Frenfert
  2. Wednesday, 1 February 2023 13:05 PM UTC
Hi Chris,



My issue is almost same accept for that i terminate session from server side manually. when my app starts login window makes connection and my report window when call retrieve it takes long time because i know query is too complex. This is okay but during retrieval when i terminate session from server side and reopen report window which in fact checking connection with Connect Using SQLCA; the SQLCODE returned tells me that transaction is already connected while connection was broken manually. So i was in the impression that Connect statement will give me SQLCODE that is not negative while i get -1. How should i identify a broken link in my app?







True regards



Berka
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.