Using database links in JDBC query

From: Paul Pratte <paul_pratte_at_umsl.edu>
Date: Fri, 04 Jun 1999 14:48:13 GMT
Message-ID: <7j8mvl$db2@news.umsl.edu>

We are receiving an error when using a select that contains a database link in it. For example as select like;

        Select Name, Address, mac_address from network_table x,
        customer_table_at_remote_db y 
        where x.id=y.id

balks when executed. Copy the customer_table locally and execute the following:

        Select Name, Address, mac_address from network_table x,
        customer_table y 
        where x.id=y.id

And it works fine.
I suspect it is a problem with the Oracle JDBC thin client drivers and parsing

the @ sign.
Any Ideas? Received on Fri Jun 04 1999 - 09:48:13 CDT