Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Dali » problem mapping to DB
problem mapping to DB [message #433450] Thu, 29 December 2005 15:05 Go to next message
Eclipse UserFriend
Originally posted by: gkatz.allot.com

hello;
i am using a clean jdk1.5.0. update 6, eclipse 3.1.1 WTP 1.0 mysql 4.0.23
and the latest dali;

i cannot get the persistence properties "table name" drop down list to
include the tables of my DB even though i configured a connection to the
DB and can browse it.

see my print screens:
http://img264.imageshack.us/img264/4484/view18dt.jpg
http://img264.imageshack.us/img264/1936/view24fy.jpg

thanks in advance.
Guy.

Report message to a moderator

Re: problem mapping to DB [message #433451 is a reply to message #433450] Tue, 03 January 2006 22:06 Go to previous messageGo to next message
Tran Le is currently offline Tran LeFriend
Messages: 10
Registered: July 2009
Junior Member
Have you select a database connection for your project?

Java Project (PersistenseSe) > Properties > Persistence > Database
Connection

-Tran

"guy katz" <gkatz@allot.com> wrote in message
news:18b2a41ff1e0fba8e0cc89ab94180920$1@www.eclipse.org...
> hello;
> i am using a clean jdk1.5.0. update 6, eclipse 3.1.1 WTP 1.0 mysql 4.0.23
> and the latest dali;
>
> i cannot get the persistence properties "table name" drop down list to
> include the tables of my DB even though i configured a connection to the
> DB and can browse it.
>
> see my print screens:
> http://img264.imageshack.us/img264/4484/view18dt.jpg
> http://img264.imageshack.us/img264/1936/view24fy.jpg
>
> thanks in advance.
> Guy.
>
>

Report message to a moderator

Re: problem mapping to DB [message #433452 is a reply to message #433451] Thu, 05 January 2006 12:03 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: gkatz.allot.com

i have checked it and the 'test' connection is configured so this is not
it...
any other suggestions?

Report message to a moderator

Re: problem mapping to DB [message #433453 is a reply to message #433452] Thu, 05 January 2006 18:57 Go to previous messageGo to next message
Neil Hauge is currently offline Neil HaugeFriend
Messages: 475
Registered: July 2009
Senior Member
Guy,

The problem is probably caused by a current limitation in our DB
integration. We are using your User ID from the DB connection as the
qualifier for your schema. So, I am guessing that your User ID for
logging into the DB does not match the appropriate schema in the database.
This is where we are currently looking for tables and columns for the UI
and validation purposes.

I will add this issue to the Getting Started notes, as this is certainly
not an obvious problem.

I have also entered a bug in bugzilla to track this issue -
http://bugs.eclipse.org/bugs/show_bug.cgi?id=122576. This should be fixed
in the very near future.

Neil

guy wrote:

> i have checked it and the 'test' connection is configured so this is not
> it...
> any other suggestions?

Report message to a moderator

Re: problem mapping to DB [message #433454 is a reply to message #433453] Sun, 08 January 2006 06:29 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: gkatz.allot.com

thanks;
would you be so kind as to explain to me how to bypass my problem for the
time being? i am not sure i understand what to do or if i have any choice
here?
thanks in advance

Report message to a moderator

Re: problem mapping to DB [message #433455 is a reply to message #433454] Mon, 09 January 2006 00:49 Go to previous messageGo to next message
Tran Le is currently offline Tran LeFriend
Messages: 10
Registered: July 2009
Junior Member
Guy,
According to your screen shots: Dali was only looking at tables in the
schema named "GKATZ" (i.e. your User ID name), but couldn't find one.
-Tran

Report message to a moderator

Re: problem mapping to DB [message #433456 is a reply to message #433454] Mon, 09 January 2006 09:28 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: dibyendu.mazumdar.demon.co.uk

Hi,

I had the same problem when trying out Dali. To resolve this you need to
connect to the database using the schema that contains the table -
assuming that the id and schema are the same thing. For example, in Apache
Derby, the default JDBC connect id is APP. But if I create a table called
EMP under schema SCOTT, it won't be visible. I have to change the JDBC
connection id to SCOTT for this table to become visible.

Regards

Report message to a moderator

Re: problem mapping to DB [message #433458 is a reply to message #433456] Mon, 09 January 2006 12:18 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: gkatz.allot.com

guys;
i did not understand what i should do in order to overcome this.
i never encountered the term 'schema name' so i dont know how to define it.
can someone please explain what exacly i should do here.
any help would be great.
thanks in advance.

Report message to a moderator

Re: problem mapping to DB [message #433459 is a reply to message #433458] Mon, 09 January 2006 13:31 Go to previous message
Eclipse UserFriend
Originally posted by: gkatz.allot.com

hi;
i just created a database named 'gkatz' and now the schema name is the
'gkatz' and this is also the connection username so everything is ok now
but of course in my reallife situation i cant do this so hopefully yhe bug
will be resolved soon.
tnanks.

Report message to a moderator

Re: problem mapping to DB [message #562017 is a reply to message #433450] Tue, 03 January 2006 22:06 Go to previous message
Tran Le is currently offline Tran LeFriend
Messages: 10
Registered: July 2009
Junior Member
Have you select a database connection for your project?

Java Project (PersistenseSe) > Properties > Persistence > Database
Connection

-Tran

"guy katz" <gkatz@allot.com> wrote in message
news:18b2a41ff1e0fba8e0cc89ab94180920$1@www.eclipse.org...
> hello;
> i am using a clean jdk1.5.0. update 6, eclipse 3.1.1 WTP 1.0 mysql 4.0.23
> and the latest dali;
>
> i cannot get the persistence properties "table name" drop down list to
> include the tables of my DB even though i configured a connection to the
> DB and can browse it.
>
> see my print screens:
> http://img264.imageshack.us/img264/4484/view18dt.jpg
> http://img264.imageshack.us/img264/1936/view24fy.jpg
>
> thanks in advance.
> Guy.
>
>

Report message to a moderator

Re: problem mapping to DB [message #562039 is a reply to message #433451] Thu, 05 January 2006 12:03 Go to previous message
Eclipse UserFriend
Originally posted by: gkatz.allot.com

i have checked it and the 'test' connection is configured so this is not
it...
any other suggestions?

Report message to a moderator

Re: problem mapping to DB [message #562058 is a reply to message #433452] Thu, 05 January 2006 18:57 Go to previous message
Neil Hauge is currently offline Neil HaugeFriend
Messages: 475
Registered: July 2009
Senior Member
Guy,

The problem is probably caused by a current limitation in our DB
integration. We are using your User ID from the DB connection as the
qualifier for your schema. So, I am guessing that your User ID for
logging into the DB does not match the appropriate schema in the database.
This is where we are currently looking for tables and columns for the UI
and validation purposes.

I will add this issue to the Getting Started notes, as this is certainly
not an obvious problem.

I have also entered a bug in bugzilla to track this issue -
http://bugs.eclipse.org/bugs/show_bug.cgi?id=122576 This should be fixed
in the very near future.

Neil

guy wrote:

> i have checked it and the 'test' connection is configured so this is not
> it...
> any other suggestions?

Report message to a moderator

Re: problem mapping to DB [message #562079 is a reply to message #433453] Sun, 08 January 2006 06:29 Go to previous message
Eclipse UserFriend
Originally posted by: gkatz.allot.com

thanks;
would you be so kind as to explain to me how to bypass my problem for the
time being? i am not sure i understand what to do or if i have any choice
here?
thanks in advance

Report message to a moderator

Re: problem mapping to DB [message #562099 is a reply to message #433454] Mon, 09 January 2006 00:49 Go to previous message
Tran Le is currently offline Tran LeFriend
Messages: 10
Registered: July 2009
Junior Member
Guy,
According to your screen shots: Dali was only looking at tables in the
schema named "GKATZ" (i.e. your User ID name), but couldn't find one.
-Tran

Report message to a moderator

Re: problem mapping to DB [message #562122 is a reply to message #433454] Mon, 09 January 2006 09:28 Go to previous message
Eclipse UserFriend
Originally posted by: dibyendu.mazumdar.demon.co.uk

Hi,

I had the same problem when trying out Dali. To resolve this you need to
connect to the database using the schema that contains the table -
assuming that the id and schema are the same thing. For example, in Apache
Derby, the default JDBC connect id is APP. But if I create a table called
EMP under schema SCOTT, it won't be visible. I have to change the JDBC
connection id to SCOTT for this table to become visible.

Regards

Report message to a moderator

Re: problem mapping to DB [message #562169 is a reply to message #433456] Mon, 09 January 2006 12:18 Go to previous message
Eclipse UserFriend
Originally posted by: gkatz.allot.com

guys;
i did not understand what i should do in order to overcome this.
i never encountered the term 'schema name' so i dont know how to define it.
can someone please explain what exacly i should do here.
any help would be great.
thanks in advance.

Report message to a moderator

Re: problem mapping to DB [message #562192 is a reply to message #433458] Mon, 09 January 2006 13:31 Go to previous message
Eclipse UserFriend
Originally posted by: gkatz.allot.com

hi;
i just created a database named 'gkatz' and now the schema name is the
'gkatz' and this is also the connection username so everything is ok now
but of course in my reallife situation i cant do this so hopefully yhe bug
will be resolved soon.
tnanks.

Report message to a moderator

Previous Topic:Re: base database plugin ?
Next Topic:@GeneratedValue annotation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 10 07:21:15 GMT 2020

Powered by FUDForum. Page generated in 0.02429 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