[inbiz]

Myeclipse does not support catalog and schema when JDBC Driver configure.

I found catalog and schema support Eclipse datatool project.
DTP support set additional property
ex:
catalog=audcat
schema=devsh

how can I use catalog and schema in myeclipse IDE
help me…

sorry my poor english ^^

[Brian Fernandes]

inbiz,

We do offer some filtering of what is shown in the DB Browser view, see page 2 of the Profile wizard while creating a new profile or editing your existing profile.

Can you explain a use case in which you need the catalog and schema fixed? Are you trying to use this while running SQL queries or otherwise? If you can give us a better idea of how you intend to use this capability, we can point you in the right direction.

[inbiz]

Some DB Browser plugins support additional property settings. ex) Eclipse DTP Project and Weblogic Web Console

[Haris Peco]

inbiz,

MyEclipse support catalogs (databases) and schemas you will got catalogs and schemas (if your database support this concepts) in DB Browser tree.
As Brian said, you can choose catalogs (or schema if your database doesn’t support catalogs) in 2nd Page of Connection profile wizard, but MyEclipse currently doesn’t support other filtering.
Please, can you explain what you want and what is your databases ?

Regards,

[inbiz]

We use HP Nonstop Database.

nonstop database catalog->schema structure.
I found eclipse datatool project. DTP project support add optional property in database connetction wizard.

Reference URL
http://wiki.eclipse.org/index.php/Getting_Started_with_DTP

I want add to Optional Property in Myeclipse.
ex)
catalog=audsch
schema=devsch

[Haris Peco]

inbiz,

We haven’t tested HP Nonstop database, but it will work if jdbc driver is JDBC compliant
You can try set properties to JDBC URL.For example,

jdbc:javaco://localhost/test?catalog=audsch&schema=devsch

I am not sure if you driver support adding properties to url, but it is standard way.

What happen when you doesn’t specify catalog and schema (you have to get all catalogs and schema if your database support them) ?
Could you send error log (Window>Show View>Other>PDE Runtime>Error Log View) ?

Have you set your database with DTP ?

Thanks,

[Author]

Posts