I'm using JAVA DB (derby)

I want to import a public view of my data to another database (also in java db).

I want to pass this data and save in to the other database. I'm having trouble since the general rule is one connection to one database.

Help would be much appreciated.

Never have heard of such rule. As far as I know, nothing in the JDBC specification prevents you from creating as many connections as can fit in memory (you are using JDBC, aren't you?)