Eclipse Community Forums: DTP » Specifying the default schema for code completion

Home » Eclipse Projects » DTP » Specifying the default schema for code completion

Specifying the default schema for code completion [message #53983]

Wed, 01 April 2009 14:27

Eclipse User

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

Re: Specifying the default schema for code completion [message #53985 is a reply to message #53983]

Thu, 02 April 2009 13:37

Eclipse User

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

Re: Specifying the default schema for code completion [message #54081 is a reply to message #53985]

Thu, 02 April 2009 19:07

Eclipse User

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
>

Re: Specifying the default schema for code completion [message #54424 is a reply to message #54081]

Sat, 04 April 2009 18:41

Eclipse User

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

Re: Specifying the default schema for code completion [message #594947 is a reply to message #53983]

Thu, 02 April 2009 13:37

Eclipse User

Re: Specifying the default schema for code completion [message #594984 is a reply to message #53985]

Thu, 02 April 2009 19:07

Eclipse User

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
>

Re: Specifying the default schema for code completion [message #595092 is a reply to message #54081]

Sat, 04 April 2009 18:41

Eclipse User

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

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Apr 29 04:10:12 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter