Results 1 to 3 of 3

Thread: OCI 21500 exception

  1. #1
    Junior Member
    Join Date
    Jun 2013
    Posts
    2

    OCI 21500 exception

    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

  2. #2
    Junior Member gtruong_rw's Avatar
    Join Date
    Mar 2008
    Posts
    13
    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

  3. #3
    Junior Member
    Join Date
    Jun 2013
    Posts
    2
    Thanks Giai.

    Saby

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •