Dear Members,

I have got a DB connection to the Firebird server (super sever) , to
the database say 'c:\temp\one.fdb'. Now I like to switch the database
to 'c:\temp\two.fdb' in the same connection ..

I tried like as in the below code snippet ,

Connection conn = fb.getConnection("c:\temp\one.fdb");
//do some operation
//commit
//then swith db
conn.setCatalog("c:/temp/two.fdb");
// I am not sure of catalog setting will work

but db switching like above failed

So kindly let me know anyway to satisfy my requirement.

with thanks ,
Peter