Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
inbiz
Post subject: HP Nonstop SQL connection problem  PostPosted: 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 ^^
 
 View user's profile Send private message  
Reply with quote Back to top
Support-Brian
Post subject:   PostPosted: Nov 23, 2006 - 04:04 PM
Moderator
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
 
 View user's profile Send private message Visit poster's website  
Reply with quote Back to top
inbiz
Post subject:   PostPosted: 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
 
 View user's profile Send private message  
Reply with quote Back to top
support-snpe
Post subject:   PostPosted: Nov 24, 2006 - 03:27 AM
Moderator
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!
 
 View user's profile Send private message  
Reply with quote Back to top
inbiz
Post subject:   PostPosted: 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

Image

I want add to Optional Property in Myeclipse.
ex)
catalog=audsch
schema=devsch
 
 View user's profile Send private message  
Reply with quote Back to top
support-snpe
Post subject:   PostPosted: Nov 27, 2006 - 02:51 AM
Moderator
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!
 
 View user's profile Send private message  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT - 6 Hours
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Powered by PNphpBB2 © 2003-2004 The PNphpBB Group
Credits