| Author |
Message |
|
|
Post subject: HP Nonstop SQL connection problem
Posted: Nov 23, 2006 - 07:17 AM
|
|

Joined: Apr 15, 2006
Posts: 3
|
|
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 ^^ |
|
|
| |
|
|
|
 |
|
|
Post subject:
Posted: Nov 23, 2006 - 04:04 PM
|
|
Moderator


Joined: Aug 21, 2004
Posts: 2339
|
|
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. |
_________________ Brian
MyEclipse Support
|
| |
|
|
|
 |
|
|
Post subject:
Posted: Nov 24, 2006 - 12:34 AM
|
|

Joined: Apr 15, 2006
Posts: 3
|
|
Some DB Browser plugins support additional property settings. ex) Eclipse DTP Project and Weblogic Web Console |
|
|
| |
|
|
|
 |
|
|
Post subject:
Posted: Nov 24, 2006 - 03:27 AM
|
|
Moderator


Joined: Feb 03, 2006
Posts: 1117
|
|
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, |
_________________ Peco
MyEclipse Support
Please do us a big favor and remember to vote for MyEclipse at the JDJ Reader's Choice Awards.
We really appreciate it!
|
| |
|
|
|
 |
|
|
Post subject:
Posted: Nov 27, 2006 - 02:08 AM
|
|

Joined: Apr 15, 2006
Posts: 3
|
|
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 |
|
|
| |
|
|
|
 |
|
|
Post subject:
Posted: Nov 27, 2006 - 02:51 AM
|
|
Moderator


Joined: Feb 03, 2006
Posts: 1117
|
|
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, |
_________________ Peco
MyEclipse Support
Please do us a big favor and remember to vote for MyEclipse at the JDJ Reader's Choice Awards.
We really appreciate it!
|
| |
|
|
|
 |
|
|