dynamobi/dynamobi — Issue #524: [FRG-348] Test SQL/MED JDBC plugin against remote Farrago server
Author: dynamobi-build
Created: 2011-12-30 03:33:19+00:00
State: open
Labels: FRG, JDBC Foreign Data Wrapper

[reporter="stephan", created="Wed, 17 Sep 2008 11:26:45 -0500 (GMT-05:00)"]
Test SQL/MED JDBC plugin against remote Farrago server.

Presently, the SQL/MED JDBC plugin is tested in loopback mode in unitsql/med/loopback.sql. It would be desirable to reproduce some of those tests in an environment where the foreign table is on a remote Farrago server. Alternatively, a test might run a single Farrago server instance and create a server on the SYS_JDBC foreign data wrapper that uses the Farrago client RMI driver:

create server X

foreign data wrapper SYS_JDBC

options (

driver_class 'net.sf.farrago.jdbc.client.FarragoClientJdbcDriver',

url 'jdbc:farrago:rmi://localhost:pppp',

user_name 'sa');

Note that to properly shut down the test requires the data server to be dropped and the code cache flushed:

drop server X;

call sys_boot.mgmt.flush_code_cache();

Test should execute joins again the data server's foreign tables to test simultaneous result sets. Should also verify that queries are NOT being converted into native table lookups (see unitsql/med/loopback.sql where this should happen).