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 10:05 Go to next message
Eclipse User
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.
Re: problem mapping to DB [message #433451 is a reply to message #433450] Tue, 03 January 2006 17:06 Go to previous messageGo to next message
Tran Le is currently offline Tran Le
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.
>
>
Re: problem mapping to DB [message #433452 is a reply to message #433451] Thu, 05 January 2006 07:03 Go to previous messageGo to next message
Eclipse User
Originally posted by: gkatz.allot.com

i have checked it and the 'test' connection is configured so this is not
it...
any other suggestions?
Re: problem mapping to DB [message #433453 is a reply to message #433452] Thu, 05 January 2006 13:57 Go to previous messageGo to next message
Neil Hauge is currently offline Neil Hauge
Messages: 467
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?
Re: problem mapping to DB [message #433454 is a reply to message #433453] Sun, 08 January 2006 01:29 Go to previous messageGo to next message
Eclipse User
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
Re: problem mapping to DB [message #433455 is a reply to message #433454] Sun, 08 January 2006 19:49 Go to previous messageGo to next message
Tran Le is currently offline Tran Le
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
Re: problem mapping to DB [message #433456 is a reply to message #433454] Mon, 09 January 2006 04:28 Go to previous messageGo to next message
Eclipse User
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
Re: problem mapping to DB [message #433458 is a reply to message #433456] Mon, 09 January 2006 07:18 Go to previous messageGo to next message
Eclipse User
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.
Re: problem mapping to DB [message #433459 is a reply to message #433458] Mon, 09 January 2006 08:31 Go to previous message
Eclipse User
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.
Re: problem mapping to DB [message #562017 is a reply to message #433450] Tue, 03 January 2006 17:06 Go to previous message
Tran Le is currently offline Tran Le
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.
>
>
Re: problem mapping to DB [message #562039 is a reply to message #433451] Thu, 05 January 2006 07:03 Go to previous message
Eclipse User
Originally posted by: gkatz.allot.com

i have checked it and the 'test' connection is configured so this is not
it...
any other suggestions?
Re: problem mapping to DB [message #562058 is a reply to message #433452] Thu, 05 January 2006 13:57 Go to previous message
Neil Hauge is currently offline Neil Hauge
Messages: 467
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?
Re: problem mapping to DB [message #562079 is a reply to message #433453] Sun, 08 January 2006 01:29 Go to previous message
Eclipse User
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
Re: problem mapping to DB [message #562099 is a reply to message #433454] Sun, 08 January 2006 19:49 Go to previous message
Tran Le is currently offline Tran Le
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
Re: problem mapping to DB [message #562122 is a reply to message #433454] Mon, 09 January 2006 04:28 Go to previous message
Eclipse User
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
Re: problem mapping to DB [message #562169 is a reply to message #433456] Mon, 09 January 2006 07:18 Go to previous message
Eclipse User
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.
Re: problem mapping to DB [message #562192 is a reply to message #433458] Mon, 09 January 2006 08:31 Go to previous message
Eclipse User
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.
Previous Topic:@GeneratedValue annotation
Next Topic:persistence perspective not available
Goto Forum:
  


Current Time: Tue Jul 22 13:38:50 EDT 2014

Powered by FUDForum. Page generated in 0.02491 seconds