How to use implicit connection in a class?

[TahitiClic]

[Migrated content. Thread originally posted on 01 September 2011]

Hi,

I'm facing this problem : when using implicit connection to an Oracle database, the execution aborts with a "Connection not found" error. If I use an explicit connect in a method of the used object, all goes fine.

This doesn't occur with programs & subprograms where I can use implicit connection without any problem.

So, is an implicit connection compatible with OO Cobol?

Regards,
TahitiClic

[Chris Glazier]

What product and version are you using, Net Express, Server Express or Visual COBOL?
What Oracle product are you using?

Are you using Pro*COBOL and cobsql in a native program or are you using OpenESQL with ODBC or ADO.NET?

Any additional information you can provide would be helpful.

Thanks.

[TahitiClic · Accepted solution]

Hi,

I'm using Server Express 5

ProCobol doesn't support OO Cobol, so I'm using OpenSQL precomp, with OracleOCI targetting (no ODBC).

Oracle is in 10g version.

I want to use implicit connexion since explicit connexion is a lot slower (I can't see why but it's about 40% slower).

[EDIT] : it appears that in this particular case, Explicit connection in main program or implicit connection are not sufficient. The INIT precompiler directive in the main program allows to share connection, so problem solved but I can't see why other types of connection don't share the CONNECT.

Thanks for your help.

TahitiClic