Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Dali » Multiple schema
Multiple schema [message #433992] Fri, 14 July 2006 15:47 Go to next message
Jacky is currently offline Jacky
Messages: 4
Registered: July 2009
Junior Member
Hi,

I downloaded this plugin yesterday and I have difficulty trying to adopt
this tool for my application. My application (uses Oracle) needs access
to tables in different schema (e.g. schema1.user, schema2.user), but the
plugin force me to pick only one schema at a time. As a result, whenever
I choose schema1, my entity beans that uses schema2 will show an error,
vice versa. Is there any way to get around this problem?

Thanks.

Jacky
Re: Multiple schema [message #433993 is a reply to message #433992] Fri, 14 July 2006 19:42 Go to previous message
Neil Hauge is currently offline Neil Hauge
Messages: 469
Registered: July 2009
Senior Member
Hi Jacky,

Unfortunately this is a limitation in the current release. In cases where
different schemas are used in the same persistent unit, the schema
attribute must be specified on the Table annotation when different than
the default. At this time, Dali doesn't manage or acknowledge
configuration of the schema attribute on the Table annotation.

I can't think of a good workaround for this at the moment. If there are
only a few tables in the non-default schema(s), you could ignore the
errors and type in the table and column names. Not a great workaround if
you have a lot of these tables.

If you could, please enter a bug in bugzilla for this limitation, filed
under Technology->Dali. If possible, I would like to have this issue
fixed for the next milestone release, which should be available around the
end of August.

Neil

Jacky wrote:

> Hi,

> I downloaded this plugin yesterday and I have difficulty trying to adopt
> this tool for my application. My application (uses Oracle) needs access
> to tables in different schema (e.g. schema1.user, schema2.user), but the
> plugin force me to pick only one schema at a time. As a result, whenever
> I choose schema1, my entity beans that uses schema2 will show an error,
> vice versa. Is there any way to get around this problem?

> Thanks.

> Jacky
Re: Multiple schema [message #588975 is a reply to message #433992] Fri, 14 July 2006 19:42 Go to previous message
Neil Hauge is currently offline Neil Hauge
Messages: 469
Registered: July 2009
Senior Member
Hi Jacky,

Unfortunately this is a limitation in the current release. In cases where
different schemas are used in the same persistent unit, the schema
attribute must be specified on the Table annotation when different than
the default. At this time, Dali doesn't manage or acknowledge
configuration of the schema attribute on the Table annotation.

I can't think of a good workaround for this at the moment. If there are
only a few tables in the non-default schema(s), you could ignore the
errors and type in the table and column names. Not a great workaround if
you have a lot of these tables.

If you could, please enter a bug in bugzilla for this limitation, filed
under Technology->Dali. If possible, I would like to have this issue
fixed for the next milestone release, which should be available around the
end of August.

Neil

Jacky wrote:

> Hi,

> I downloaded this plugin yesterday and I have difficulty trying to adopt
> this tool for my application. My application (uses Oracle) needs access
> to tables in different schema (e.g. schema1.user, schema2.user), but the
> plugin force me to pick only one schema at a time. As a result, whenever
> I choose schema1, my entity beans that uses schema2 will show an error,
> vice versa. Is there any way to get around this problem?

> Thanks.

> Jacky
Previous Topic:Multiple schema
Next Topic:better late than never ;)
Goto Forum:
  


Current Time: Tue Oct 21 02:24:53 GMT 2014

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

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