How do I have multiple schemas per database connection in Eclipse DTP?

Question

I'm using the Eclipse DTP to do my SQL development. When I create a database connection I'm promoted to enter the name of the database (schema), and I cannot continue until I enter it. However, I have several databases on each server, and I want to see them all under the database connection (like most the database tools let you).

Can I do it in eclipse?

Answer 1

For each database your should create new Database Connection at Data Source Explorer. Database connection represent one-to-one mapping database «atomic user instance» (for example, for oracle this is instance name/user name, for hsqldb in server mode databse location and so on) to connection.