Open Table Problem

[AlexRO]

Hello all,

I've came upon the following problem.
In a BSFN in which we do some DB operations (insert, update) with manual commit, a JDB_OpenTable creates DB connections which doesn't close either on commit or close table. Eventually the max connections are reached and we recieve ORA-12537 and ORA-00020. The connections are realeased only when I close the Solution Explorer. I've not yet run the function on the enterprise server. I mention that the operations are successful open,close,insert,update commit and so on.

Any info on this?

Tanx,
Dan.

 

[craig_welton]

Dan,

Total stab in the dark ... do you have call to JDB_FreeBhvr at the end of the function.

Craig

 

[AlexRO]

Craig, thank you. I did call freebhvr but I needed to call freeuser to end the JDB_InitUser I used to initialize the user. I'm totally ashamed I did not notice this earlier.

Thank you so much.

Dan.