On Jun 29, 2011, at 11:22 AM, Bruno René Santos wrote:
> Andrus do you think you will address this issue on
> the 3.0.X or 3.1.X versions?
From what I can tell, the fix should be portable between the two branches, so
yes.
Andrus
Thanx a lot
> > BRuno
> >
> > -- Forwarded message ------
> > From: Bruno René Santos
> > Date: Tue, Jun 14, 2011 at 6:18 PM
> > Subject: Re: Limits & Joins on Oracle
> > To: user@cayenne.apache.org
> >
> >
> > Hi Chris
eas on this subject? Andrus or Gentry could you please dissolve
> these doubts about the possibility of using aliases on the column names?
>
> Thanx a lot
> BRuno
>
> -- Forwarded message --
> From: Bruno René Santos
> Date: Tue, Jun 14, 2011 at 6:18 PM
> Su
ge --
> From: Bruno René Santos
> Date: Tue, Jun 14, 2011 at 6:18 PM
> Subject: Re: Limits & Joins on Oracle
> To: user@cayenne.apache.org
>
>
> Hi Chris,
>
> Your solutions are in consonance with what I said in my mail. But having
> fields with the same name
: Limits & Joins on Oracle
To: user@cayenne.apache.org
Hi Chris,
Your solutions are in consonance with what I said in my mail. But having
fields with the same name is quite common. For instants all our primary keys
are named ID and for all our tables we always have columns like
last_modifie
Hi,
I know repeated column names are common ;) - I was just spelling out how
Oracle works with respect to them. - Hoping to shed some light on why it
isn't working currently.
Someone familiar with cayenne internals should chime in on whether / how it
is possible to alias the columns when running
Hi Chris,
Your solutions are in consonance with what I said in my mail. But having
fields with the same name is quite common. For instants all our primary
keys are named ID and for all our tables we always have columns like
last_modified_at, created_at, last_modified_by or created_by which we
Hi,
We have been using the same pagination pattern on Oracle as Cayenne uses
without problems for quite some time (years). So I can confirm that it looks
sane.
Anyway looking at the query in CAY-1266, one thing sticks out - The inner
query returns both t0.docid and t1.docid, IIRC oracle will "tra
I've just found the issue https://issues.apache.org/jira/browse/CAY-1266
that reveals the same situation I have. Any news about fixing this? A
coleague of mine told me it was a matter of assigning an different alias
for each column (table alias + name maybe?) and that way oracle would be
able t
Yes a regular SelectQuery, with some Expressions possibly
Bruno
Em 02-06-2011 14:23, Andrus Adamchik escreveu:
On Jun 2, 2011, at 4:04 PM, Bruno René Santos wrote:
query.setFetchLimit(count);
Just to clarify - which type of Query? SelectQuery?
Andrus
--
Bruno René Santos | brunor
On Jun 2, 2011, at 4:04 PM, Bruno René Santos wrote:
> query.setFetchLimit(count);
Just to clarify - which type of Query? SelectQuery?
Andrus
Hi Andrus,
Here goes the code (pretty simple):
public List loadItems(int startIndex, int count) {
query.setFetchLimit(count);
query.setFetchOffset(startIndex);
return results =
HolosApplication.getApp().getDatabase().performQuery(query);
}
I have spoken with collea
Ah sorry, it is probably related to Cayenne (the rownum wrapper)... my bad...
Could you post a Cayenne code that you are using to initiate this query?
Andrus
On Jun 2, 2011, at 3:34 PM, Andrus Adamchik wrote:
> This is clearly an Oracle SQL syntax error, nothing to do with Cayenne. I
> don't h
This is clearly an Oracle SQL syntax error, nothing to do with Cayenne. I don't
have a handy Oracle install to try it out. But maybe somebody else here with
more recent Oracle experience can spot the issue? Otherwise you may try the
Oracle forums.
Andrus
On Jun 2, 2011, at 3:19 PM, Bruno René
Here it goes again... Please can anybody help?
Thanx
Bruno
Em 31-05-2011 15:43, Bruno René Santos escreveu:
Hello all,
I am having a problem with the setFetchLimit on Oracle. When I use
joined tables that have fields with the same name i get the error:
Error code 918, SQL state 42000: OR
Sorry the last message had a wrong subject. here it goes again
Em 31-05-2011 15:43, Bruno René Santos escreveu:
Hello all,
I am having a problem with the setFetchLimit on Oracle. When I use
joined tables that have fields with the same name i get the error:
Error code 918, SQL state 42000: O
16 matches
Mail list logo
