Agreed. This should be a flag in the datasource mapping.
-dain
Hunter Hillegas wrote:
I saw that it was Oracle specific, but I didn't see it mentioned that it
only kicked in when using the JBoss-QL <order-by>.
Also, I still think it would be useful to have it only kick in for databases
that require it... The behavior required by Oracle isn't part of the SQL
spec is it?
Hunter
From: Emerson Cargnin - SICREDI Serviços <[EMAIL PROTECTED]>
Organization: SICREDI
Reply-To: [EMAIL PROTECTED]
Date: Mon, 28 Oct 2002 17:57:24 -0200
To: [EMAIL PROTECTED]
Subject: Re: [JBoss-dev] [ jboss-Bugs-591835 ] Include ORDER BY cols in SELECT
clause
if you read carefully the above bug you will see that it's a oracle
issue, the solution here will not generate any orderby, but when it's
used (jboss-ql order by) it uses the fields in orderby clause in the
select [fiels] where ...
Hunter Hillegas wrote:
Will this be something that is configurable per datasource type or mandated
in JBossCMP as the default? Will there be any way to tell JBoss *not* to add
these order bys in the event we don't want them?
Hunter
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date: Mon, 28 Oct 2002 11:57:13 -0800
To: [EMAIL PROTECTED]
Subject: [JBoss-dev] [ jboss-Bugs-591835 ] Include ORDER BY cols in SELECT
clause
Bugs item #591835, was opened at 2002-08-06 22:46
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=591835&group_id
=2
2866
Category: JBossCMP
Group: v3.2
Status: Open
Resolution: Accepted
Priority: 5
Submitted By: Stephen Coy (scoy)
Assigned to: Dain Sundstrom (dsundstrom)
Summary: Include ORDER BY cols in SELECT clause
Initial Comment:
Some databases, Oracle in particular, require that columns named
in an ORDER BY clause be included in the SELECT clause when
SELECT DISTINCT is used.
Here is some text from current Oracle documentation:
Restrictions on the order_by_clause:
* If you have specified the DISTINCT operator in this statement,
then this clause cannot refer to columns unless they appear in the
select list.
* An order_by_clause can contain no more than 255 expressions.
This can be worked around using on-find loading with load groups,
but it sure would be useful if JBoss managed it for us.
----------------------------------------------------------------------
Comment By: Emerson Cargnin (echofloripa)
Date: 2002-10-28 17:57
Message:
Logged In: YES
user_id=378942
the workaround is useless if I use a dynamic-ql, correct me
if I'm wrong
----------------------------------------------------------------------
Comment By: Emerson Cargnin (echofloripa)
Date: 2002-10-15 16:23
Message:
Logged In: YES
user_id=378942
For oracle users, this is really a showstopper bug. I'll try
to undertand to (maybe) try to solve that : ) obs: i think
it'll take too long to me to take this : )
----------------------------------------------------------------------
Comment By: Dain Sundstrom (dsundstrom)
Date: 2002-08-23 22:00
Message:
Logged In: YES
user_id=251431
This is really a bug.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=591835&group_id
=2
2866
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
--
xxxxxxxxxxxxxxxxxxxxxxxxxxxx
| Emerson Cargnin |
| Analista de Sistemas Sr. |
| Tel : (051) 3358-4959 |
| SICREDI Serviços |
| Porto Alegre - Brasil |
|xxxxxxxxxxxxxxxxxxxxxxxxxx|
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
--
xxxxxxxxxxxxxxxxxxxxxxxx
Dain Sundstrom
Chief Architect JBossCMP
JBoss Group, LLC
xxxxxxxxxxxxxxxxxxxxxxxx
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
