commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gibbs, Philip \(Robert Half\)" <>
Subject DBCP Question
Date Fri, 05 May 2006 16:14:00 GMT
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

The DB is Oracle 9.




Phil Gibbs

Consultant - Robert-Half Int'l. 


  • Unnamed multipart/related (inline, None, 0 bytes)
View raw message