Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Transaction already connected

  1. Issue
0
Votes
Undo
  1. Santosh Pawar
    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
           
           

 

 

  1. Transaction
Get PBL version from application
Transaction already connected after communication ...
Responses (2)
Chris Pollach
Chris Pollach Accepted Answer Pending Moderation
  1. Tuesday, 9 May 2017 18:59 PM UTC
  2. PowerBuilder
  3. # 1

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
Berka Frenfert
  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.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Wednesday, 10 May 2017 02:44 AM UTC
  2. PowerBuilder
  3. # 2

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.
  • Page :
  • 1


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