Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Specifying the default schema for code completion
Specifying the default schema for code completion [message #53983] Wed, 01 April 2009 18:27 Go to next message
Marc Richards is currently offline Marc RichardsFriend
Messages: 6
Registered: July 2009
Junior Member
Hi,

I am using the datatools project to connect to an Oracle database by I am
having some usability issues.

By default code-completion in the SQL Editor/Scrapbook only shows you
options from tables in the schema which corresponds to the username used
to login. In my case most of the tables I work with are in another schema
which I have access to, so I would like to tell the editor to use a
specific schema is the default...is there a way to do this? If not is
there a bug for this (I couldn't find one).

It seems like the SQL Query Builder respects the Schema Filter preferences
when showing the list of available tables to choose from and it even has a
preference omitting the default schema name and specifying what that
default should be. Shouldn't both tools be using the same option?


Marc

Report message to a moderator

Re: Specifying the default schema for code completion [message #53985 is a reply to message #53983] Thu, 02 April 2009 17:37 Go to previous messageGo to next message
Marc Richards is currently offline Marc RichardsFriend
Messages: 6
Registered: July 2009
Junior Member
If anybody else is having trouble using Oracle w/ datatools, I would
suggest taking a look at the jOra plugin
( http://www.eclipseplugincentral.com/Web_Links-index-req-view link-cid-1146.html)
It is has more features and is easier to use.

It doesn't seem to support specifying a default schema, but it has support
for code completion on public synonyms (which datatools doesn't) which is
even better in my case because the synonyms we use are shorter and well
documented.


Marc

Report message to a moderator

Re: Specifying the default schema for code completion [message #54081 is a reply to message #53985] Thu, 02 April 2009 23:07 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: brianf.sybase.com

Hey Marc...

Have you entered any enhancement requests or bugzilla entries for the items
that aren't working for you?

--Fitz

"Marc Richards" <email.marc@gmail.com> wrote in message
news:0f437c90e2b2007f2cf79cc9842c4ac0$1@www.eclipse.org...
> If anybody else is having trouble using Oracle w/ datatools, I would
> suggest taking a look at the jOra plugin
> ( http://www.eclipseplugincentral.com/Web_Links-index-req-view link-cid-1146.html)
> It is has more features and is easier to use.
> It doesn't seem to support specifying a default schema, but it has support
> for code completion on public synonyms (which datatools doesn't) which is
> even better in my case because the synonyms we use are shorter and well
> documented.
>
>
> Marc
>

Report message to a moderator

Re: Specifying the default schema for code completion [message #54424 is a reply to message #54081] Sat, 04 April 2009 22:41 Go to previous message
Marc Richards is currently offline Marc RichardsFriend
Messages: 6
Registered: July 2009
Junior Member
Brian Fitzpatrick wrote:

> Hey Marc...

> Have you entered any enhancement requests or bugzilla entries for the items
> that aren't working for you?


Just wanted to check here first.

Default schema - https://bugs.eclipse.org/bugs/show_bug.cgi?id=271232

Synonyms - https://bugs.eclipse.org/bugs/show_bug.cgi?id=271234

Report message to a moderator

Re: Specifying the default schema for code completion [message #594947 is a reply to message #53983] Thu, 02 April 2009 17:37 Go to previous message
Marc Richards is currently offline Marc RichardsFriend
Messages: 6
Registered: July 2009
Junior Member
If anybody else is having trouble using Oracle w/ datatools, I would
suggest taking a look at the jOra plugin
( http://www.eclipseplugincentral.com/Web_Links-index-req-view link-cid-1146.html)
It is has more features and is easier to use.

It doesn't seem to support specifying a default schema, but it has support
for code completion on public synonyms (which datatools doesn't) which is
even better in my case because the synonyms we use are shorter and well
documented.


Marc

Report message to a moderator

Re: Specifying the default schema for code completion [message #594984 is a reply to message #53985] Thu, 02 April 2009 23:07 Go to previous message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 500
Registered: July 2009
Senior Member
Hey Marc...

Have you entered any enhancement requests or bugzilla entries for the items
that aren't working for you?

--Fitz

"Marc Richards" <email.marc@gmail.com> wrote in message
news:0f437c90e2b2007f2cf79cc9842c4ac0$1@www.eclipse.org...
> If anybody else is having trouble using Oracle w/ datatools, I would
> suggest taking a look at the jOra plugin
> ( http://www.eclipseplugincentral.com/Web_Links-index-req-view link-cid-1146.html)
> It is has more features and is easier to use.
> It doesn't seem to support specifying a default schema, but it has support
> for code completion on public synonyms (which datatools doesn't) which is
> even better in my case because the synonyms we use are shorter and well
> documented.
>
>
> Marc
>

Report message to a moderator

Re: Specifying the default schema for code completion [message #595092 is a reply to message #54081] Sat, 04 April 2009 22:41 Go to previous message
Marc Richards is currently offline Marc RichardsFriend
Messages: 6
Registered: July 2009
Junior Member
Brian Fitzpatrick wrote:

> Hey Marc...

> Have you entered any enhancement requests or bugzilla entries for the items
> that aren't working for you?


Just wanted to check here first.

Default schema - https://bugs.eclipse.org/bugs/show_bug.cgi?id=271232

Synonyms - https://bugs.eclipse.org/bugs/show_bug.cgi?id=271234

Report message to a moderator

Previous Topic:Still can't create a connection
Next Topic:How do I repair eclipse (remove datatools)?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 19:16:12 GMT 2024

Powered by FUDForum. Page generated in 0.03856 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly