OCI 21500 exception

[sabyasachin]

I am getting OCI-21500 exception in my C++ code where I use RWDBConnection to connect oracle 11g.

My question is what exception can I catch if somehow it happens to use the same connection.

I using a code snippet like this:


newConnection.beginTransaction();
RWDBResult myResult=newConnection.executeSql(mySql);

RWDBTable myTable=myResult.table();

RWDBReader rdbReader = myTable.reader(newConnection);

Where "newConnection" is a RWDBConnection variable already having a valid connection, but may be used by another thread.

Can anybody please advise.

Saby

[gtruong_rw]

The best approach is to lock the connection until the execution is finished and then release the connection so other threads can have access to it.

http://www.roguewave.com/portals/0/p...reug/11-4.html

Giai Truong
Rogue Wave Software
5500 Flatiron Parkway, Suite 200, Boulder, CO 80301
| P 303.545.3205 | US 800.404.4767 | F 303.473.9137 |
support@roguewave.com
www.roguewave.com/support

[sabyasachin]

Thanks Giai.

Saby