Hi Sylvain,
As you've discovered, ij only handles one connection at a time. You
could use a table function to solve this problem.
Regards,
-Rick
Sylvain Leroux wrote:
Hi,
Is it currently possible to use IJ to copy data from one DB to an
other one? I mean, without writing any line of Java...
By looking at the code, it seems that prepared statements and cursors
are tight to one specific DB connection. Thus preventing something like:
CONNECT 'jdbc:derby:src_db'
PREPARE SRC AS 'SELECT x FROM SOURCE_TABLE';
CONNECT 'jdbc:derby:dest_db'
PREPARE COPY AS 'INSERT INTO DEST_TABLE VALUES(?)';
EXECUTE COPY USING SRC;
Thanks,
Sylvain
PS/If such a feature is not available, I'll be glad to work on it!
