Eclipse Community Forums: EclipseLink » Select from partition ?

Help

Home

Home » Eclipse Projects » EclipseLink » Select from partition ?

Show: Today's Messages :: Show Polls :: Message Navigator

Select from partition ? [message #756676]

Mon, 14 November 2011 11:08

Krzysztof Kowalczyk is currently offline

Krzysztof Kowalczyk
Messages: 113
Registered: July 2009

Senior Member

Hi,

I have an application running on Oracle and EclipseLink 2.1(if really needed I can upgrade it) using the old ExpressionBuilder api. I would like to optimise a long running query to use only one known partition.

Is it possible to construct a query that use both: a bit of native SQL (From x partition(y)) and ExpressionBuilder api for the rest of query?

Regards,
Krzysztof Kowalczyk

Report message to a moderator

Re: Select from partition ? [message #758009 is a reply to message #756676]

Mon, 21 November 2011 13:12

James
Messages: 272
Registered: July 2009

Senior Member

It is probably better to use an SQL query then try to mix objects and SQL.

You can use the getTable() API to get a table reference, but I don't think you could generate what you want. EclipseLink's AsOfClause does do something similar in syntax.

--
James : http://wiki.eclipse.org/EclipseLink : http://en.wikibooks.org/wiki/Java_Persistence : http://java-persistence-performance.blogspot.com/

Report message to a moderator

Previous Topic:	Select from partition ?
Next Topic:	Problem with @OneToMany from an @Embeddable

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 03:43:01 EDT 2013