dynamobi-build
commented
12 years ago [author="stephan", created="Wed, 17 Sep 2008 11:39:31 -0500 (GMT-05:00)"]
Note that the given CREATE SERVER DDL would need to be executed via a helper method in FarragoTestUDR and an associated UDP: it should lookup the appropriate port number (as tests may be running on non-default ports in shared environments) and issue the DDL.
[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).