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

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

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

Wed, 01 April 2009 18:27

Marc Richards

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

Marc Richards

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

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
>

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

Marc Richards

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

Marc Richards

Messages: 6
Registered: July 2009

Junior Member

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

Brian Fitzpatrick

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

Marc Richards

Messages: 6
Registered: July 2009

Junior Member

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 09 04:32:20 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter