db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Using IJ to copy data from one DB to an other one
Date Mon, 15 Feb 2010 18:59:17 GMT
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!
>
>


Mime
View raw message