Skip to main content


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 JackyFriend
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 HaugeFriend
Messages: 475
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 HaugeFriend
Messages: 475
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:Dali 0.5 Release now available
Next Topic:better late than never ;)
Goto Forum:
  


Current Time: Fri Apr 26 06:55:55 GMT 2024

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

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

Back to the top