commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gibbs, Philip \(Robert Half\)" <>
Subject RE: DBCP Question
Date Fri, 05 May 2006 18:57:03 GMT
I have resolved this issue.
I determined that the link name had to have a '@' prepended to it as in TABLE_NAME@LINKNAME
T1, ......

Phil Gibbs
Consultant - Robert-Half Int'l.

-----Original Message-----
From: Tahir Akhtar [] 
Sent: Friday, May 05, 2006 2:24 PM
To: 'Jakarta Commons Users List'
Subject: RE: DBCP Question

I have only indirectly used DBCP. Well, my gut feeling is that this problem must be related
to the database driver being used.  But lets for an expert to jump in ☺.

Have you tried the same query on a direct jdbc connection or by getting the underlying connection
from the pool

    Connection conn = ds.getConnection();
    Connection dconn = ((DelegatingConnection) conn).getInnermostDelegate();

See the complete discussion under description of  accessToUnderlyingConnectionAllowed parameter

Tahir Akhtar
From: Gibbs, Philip (Robert Half) [] 
Sent: Friday, May 05, 2006 9:14 PM
Subject: DBCP Question

Apologies for perhaps sending this to the wrong group.  If you know the appropriate group
perhaps you could forward this to it.
I am using the ‘PoolingDataSource’ and am successfully getting a connection to the DB.
However, the Select statements I’m using are utilizing ‘database links’ in the table
naming – eg; 
SELECT * FROM PROJECT some_link_name A, WORK_ORDER some_link_name B WHERE …..
If I submit this query as is, I get a ‘Statement not properly ended’ error.  If I remove
the link names it works fine.
The question is, does the DBCP datasource support the use of these link names.
The DB is Oracle 9.
Phil Gibbs
Consultant - Robert-Half Int'l. 

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 5/4/2006

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message