You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Richard Emberson <re...@edgedynamics.com> on 2004/11/22 22:30:18 UTC
table prefix
A little while ago someone was suggesting that they were working on
adding a feature that would allow one to specify a database table
prefix (to be used by all Slide tables) which would be used both by the
initialization sql and the java code.
Is that work happening?
Thanks.
Richard
--
This email message is for the sole use of the intended recipient(s) and
may contain confidential information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: table prefix
Posted by Richard Emberson <re...@edgedynamics.com>.
If I said suffix its not what I meant .... yes, prefix is much better.
Richard
kranga wrote:
> I would strongly recommend a table prefix as opposed to a suffix as you
> mention at the end of the first paragraph. That was when you list the
> tables, all tables for a given app/module are listed together, yet in
> alphabetic order. With a suffix, the table names will get dispersed among
> the table names from other applications.
>
> my inflation adjusted 17 cents :)
>
> ----- Original Message -----
> From: "Richard Emberson" <re...@edgedynamics.com>
> To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
> Sent: Tuesday, November 23, 2004 10:20 AM
> Subject: Re: table prefix
>
>
>
>>Our application has both tables that we have created and tables from
>>more than one external application, such a Slide. So how to keep table
>>names from colliding? One way of course is to create a different
>>database per section of one's application. Another is for each
>>creator of tables to assume that they will exist in a federated
>>system and thus they should take the effort as a good citizen of that
>>federation to make sure their table names are unique - one way to
>>do this is with a "namespace" suffix.
>>
>>Some in our group believed that they were the center of the universe
>>a could pick whatever table names they wished. Those with more
>>experience with integrating multiple separate software parts into
>>a whole knew that such belief were folly and lead to madness.
>>
>>Richard
>>
>>James Mason wrote:
>>
>>>Not that I know of. That particular issue was resolved by creating the
>>>tables with a non-system user. In Oracle, that puts the tables in the
>>>default schema of the user (versus the System schema).
>>>
>>>Is this a feature that you need?
>>>
>>>-James
>>>
>>>On Mon, 2004-11-22 at 13:30 -0800, Richard Emberson wrote:
>>>
>>>
>>>>A little while ago someone was suggesting that they were working on
>>>>adding a feature that would allow one to specify a database table
>>>>prefix (to be used by all Slide tables) which would be used both by the
>>>>initialization sql and the java code.
>>>>
>>>>Is that work happening?
>>>>
>>>>Thanks.
>>>>
>>>>Richard
>>>>
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>>>For additional commands, e-mail: slide-user-help@jakarta.apache.org
>>>
>>
>>
>>--
>>This email message is for the sole use of the intended recipient(s) and
>>may contain confidential information. Any unauthorized review, use,
>>disclosure or distribution is prohibited. If you are not the intended
>>recipient, please contact the sender by reply email and destroy all
>>copies of the original message.
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: slide-user-help@jakarta.apache.org
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
--
This email message is for the sole use of the intended recipient(s) and
may contain confidential information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: table prefix
Posted by kranga <kr...@k2d2.org>.
I would strongly recommend a table prefix as opposed to a suffix as you
mention at the end of the first paragraph. That was when you list the
tables, all tables for a given app/module are listed together, yet in
alphabetic order. With a suffix, the table names will get dispersed among
the table names from other applications.
my inflation adjusted 17 cents :)
----- Original Message -----
From: "Richard Emberson" <re...@edgedynamics.com>
To: "Slide Users Mailing List" <sl...@jakarta.apache.org>
Sent: Tuesday, November 23, 2004 10:20 AM
Subject: Re: table prefix
> Our application has both tables that we have created and tables from
> more than one external application, such a Slide. So how to keep table
> names from colliding? One way of course is to create a different
> database per section of one's application. Another is for each
> creator of tables to assume that they will exist in a federated
> system and thus they should take the effort as a good citizen of that
> federation to make sure their table names are unique - one way to
> do this is with a "namespace" suffix.
>
> Some in our group believed that they were the center of the universe
> a could pick whatever table names they wished. Those with more
> experience with integrating multiple separate software parts into
> a whole knew that such belief were folly and lead to madness.
>
> Richard
>
> James Mason wrote:
> > Not that I know of. That particular issue was resolved by creating the
> > tables with a non-system user. In Oracle, that puts the tables in the
> > default schema of the user (versus the System schema).
> >
> > Is this a feature that you need?
> >
> > -James
> >
> > On Mon, 2004-11-22 at 13:30 -0800, Richard Emberson wrote:
> >
> >>A little while ago someone was suggesting that they were working on
> >>adding a feature that would allow one to specify a database table
> >>prefix (to be used by all Slide tables) which would be used both by the
> >>initialization sql and the java code.
> >>
> >>Is that work happening?
> >>
> >>Thanks.
> >>
> >>Richard
> >>
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >
>
>
> --
> This email message is for the sole use of the intended recipient(s) and
> may contain confidential information. Any unauthorized review, use,
> disclosure or distribution is prohibited. If you are not the intended
> recipient, please contact the sender by reply email and destroy all
> copies of the original message.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: table prefix
Posted by James Mason <ma...@apache.org>.
Most of the applications I deal with run with a dedicated database. This
makes management and configuration easier, and allows for finer-grained
performance tuning.
Adding a prefix to the table names shouldn't be too hard, though, and
from the other thread it sounds like almost everything has been done.
Anyone volunteer to finish things up?
-James
On Tue, 2004-11-23 at 07:20 -0800, Richard Emberson wrote:
> Our application has both tables that we have created and tables from
> more than one external application, such a Slide. So how to keep table
> names from colliding? One way of course is to create a different
> database per section of one's application. Another is for each
> creator of tables to assume that they will exist in a federated
> system and thus they should take the effort as a good citizen of that
> federation to make sure their table names are unique - one way to
> do this is with a "namespace" suffix.
>
> Some in our group believed that they were the center of the universe
> a could pick whatever table names they wished. Those with more
> experience with integrating multiple separate software parts into
> a whole knew that such belief were folly and lead to madness.
>
> Richard
>
> James Mason wrote:
> > Not that I know of. That particular issue was resolved by creating the
> > tables with a non-system user. In Oracle, that puts the tables in the
> > default schema of the user (versus the System schema).
> >
> > Is this a feature that you need?
> >
> > -James
> >
> > On Mon, 2004-11-22 at 13:30 -0800, Richard Emberson wrote:
> >
> >>A little while ago someone was suggesting that they were working on
> >>adding a feature that would allow one to specify a database table
> >>prefix (to be used by all Slide tables) which would be used both by the
> >>initialization sql and the java code.
> >>
> >>Is that work happening?
> >>
> >>Thanks.
> >>
> >>Richard
> >>
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: slide-user-help@jakarta.apache.org
> >
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: table prefix
Posted by Richard Emberson <re...@edgedynamics.com>.
Our application has both tables that we have created and tables from
more than one external application, such a Slide. So how to keep table
names from colliding? One way of course is to create a different
database per section of one's application. Another is for each
creator of tables to assume that they will exist in a federated
system and thus they should take the effort as a good citizen of that
federation to make sure their table names are unique - one way to
do this is with a "namespace" suffix.
Some in our group believed that they were the center of the universe
a could pick whatever table names they wished. Those with more
experience with integrating multiple separate software parts into
a whole knew that such belief were folly and lead to madness.
Richard
James Mason wrote:
> Not that I know of. That particular issue was resolved by creating the
> tables with a non-system user. In Oracle, that puts the tables in the
> default schema of the user (versus the System schema).
>
> Is this a feature that you need?
>
> -James
>
> On Mon, 2004-11-22 at 13:30 -0800, Richard Emberson wrote:
>
>>A little while ago someone was suggesting that they were working on
>>adding a feature that would allow one to specify a database table
>>prefix (to be used by all Slide tables) which would be used both by the
>>initialization sql and the java code.
>>
>>Is that work happening?
>>
>>Thanks.
>>
>>Richard
>>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: slide-user-help@jakarta.apache.org
>
--
This email message is for the sole use of the intended recipient(s) and
may contain confidential information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: table prefix
Posted by James Mason <ma...@apache.org>.
Not that I know of. That particular issue was resolved by creating the
tables with a non-system user. In Oracle, that puts the tables in the
default schema of the user (versus the System schema).
Is this a feature that you need?
-James
On Mon, 2004-11-22 at 13:30 -0800, Richard Emberson wrote:
> A little while ago someone was suggesting that they were working on
> adding a feature that would allow one to specify a database table
> prefix (to be used by all Slide tables) which would be used both by the
> initialization sql and the java code.
>
> Is that work happening?
>
> Thanks.
>
> Richard
>
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: table prefix
Posted by Richard Emberson <re...@edgedynamics.com>.
Var George,
Yes, thats the thread.
Thanks, hope someone in the Slide project will help.
Richard
Var George wrote:
> Richard
>
>
>
> Are you talking about the following thread?
>
>
>
> http://www.mail-archive.com/slide-user@jakarta.apache.org/msg08307.html
>
>
>
>
> I did all the changes (mostly per Oliver's suggestions – thanks Oliver!) and it is working well for me. I wanted to submit these changes so that slide dev team may add it as a standard feature in slide but I am still waiting to hear from slide team on what is the acceptable solution for fixing RDBMSComparableResourcesPool.java. This is the only file that has SQL outside Adapter classes so I am not really sure how this class is used or if its required. The above link was my last email on it but I haven't heard from Unico or anyone . If someone in slide team can point me to an acceptable solution then I will be glad to make/test those changes and send the updated source
>
>
>
> regards
>
> Varughese George
>
>
> Richard Emberson <re...@edgedynamics.com> wrote:
>
> A little while ago someone was suggesting that they were working on
> adding a feature that would allow one to specify a database table
> prefix (to be used by all Slide tables) which would be used both by the
> initialization sql and the java code.
>
> Is that work happening?
>
> Thanks.
>
> Richard
>
--
This email message is for the sole use of the intended recipient(s) and
may contain confidential information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: table prefix
Posted by Richard Emberson <re...@edgedynamics.com>.
Var George,
RDBMSComparableResourcesPool is used in
org.apache.slide.store.impl.rdbms.expression.RDBMSExpressionFactory
which has the following javadoc:
DASL Basic search expression factory that compiles query expressions
to native SQL queries
While we do not plan to use DASL, for completeness one would like
(and I assume the Slide folks would require) this to work with
table prefixes.
How did you implement adding the prefix to the table names in the
java code and in the sql scripts.
Did you use Ants ability to filter files and copy all of the sources
to a generated-source directory having Ant replace a table prefix
like @TABLE_PREFIX@ with either the empty string "" or with a
supplied prefix string (like "SLIDE_")?
Richard
Var George wrote:
> Richard
>
>
>
> Are you talking about the following thread?
>
>
>
> http://www.mail-archive.com/slide-user@jakarta.apache.org/msg08307.html
>
>
>
>
> I did all the changes (mostly per Oliver's suggestions – thanks Oliver!) and it is working well for me. I wanted to submit these changes so that slide dev team may add it as a standard feature in slide but I am still waiting to hear from slide team on what is the acceptable solution for fixing RDBMSComparableResourcesPool.java. This is the only file that has SQL outside Adapter classes so I am not really sure how this class is used or if its required. The above link was my last email on it but I haven't heard from Unico or anyone . If someone in slide team can point me to an acceptable solution then I will be glad to make/test those changes and send the updated source
>
>
>
> regards
>
> Varughese George
>
>
> Richard Emberson <re...@edgedynamics.com> wrote:
>
> A little while ago someone was suggesting that they were working on
> adding a feature that would allow one to specify a database table
> prefix (to be used by all Slide tables) which would be used both by the
> initialization sql and the java code.
>
> Is that work happening?
>
> Thanks.
>
> Richard
>
--
This email message is for the sole use of the intended recipient(s) and
may contain confidential information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
Re: table prefix
Posted by Var George <va...@yahoo.com>.
Richard
Are you talking about the following thread?
http://www.mail-archive.com/slide-user@jakarta.apache.org/msg08307.html
I did all the changes (mostly per Oliver's suggestions � thanks Oliver!) and it is working well for me. I wanted to submit these changes so that slide dev team may add it as a standard feature in slide but I am still waiting to hear from slide team on what is the acceptable solution for fixing RDBMSComparableResourcesPool.java. This is the only file that has SQL outside Adapter classes so I am not really sure how this class is used or if its required. The above link was my last email on it but I haven't heard from Unico or anyone . If someone in slide team can point me to an acceptable solution then I will be glad to make/test those changes and send the updated source
regards
Varughese George
Richard Emberson <re...@edgedynamics.com> wrote:
A little while ago someone was suggesting that they were working on
adding a feature that would allow one to specify a database table
prefix (to be used by all Slide tables) which would be used both by the
initialization sql and the java code.
Is that work happening?
Thanks.
Richard
--
This email message is for the sole use of the intended recipient(s) and
may contain confidential information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org
---------------------------------
Do you Yahoo!?
The all-new My Yahoo! � Get yours free!