Bug in OCCI's Environment::createConnectionPool(), or just me?

From: Mark Emmert <marke_at_nospam.lith.com>
Date: Tue, 02 Apr 2002 06:41:31 GMT
Message-ID: <MPG.1712ef8327462084989682_at_news-byoa.prodigy.net>



Everyone,

I have the following code snippet in a test application that I wrote try out OCCI:

Environment * env =

        Environment::createEnvironment(Environment::THREADED_MUTEXED); ConnectionPool * pool =

        env->createConnectionPool("scott", "tiger", "testdb"); Connection * conn = pool->createConnection("scott", "tiger");

I invariably get an SQLException from the last line of code with the diagnostic text "ORA-12154: TNS:could not resolve service name".

The database in question does exist, tnsping resolves the name just fine, and I can connect to it using SQL*Plus (all of this from the same client machine). Furthermore, if I remove the final two lines of code and replace them with:

Connection * conn =

        env->createConnection("scott", "tiger", "testdb");

then everything works fine. Is there some nuance of OCCI connection pools that I don't understand, or is this a bug?

Thanks.

-- 
Mark K. Emmert
Received on Tue Apr 02 2002 - 08:41:31 CEST

Original text of this message