Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Select from partition ?
Select from partition ? [message #756678] Mon, 14 November 2011 16:08 Go to next message
Krzysztof Kowalczyk is currently offline Krzysztof KowalczykFriend
Messages: 113
Registered: July 2009
Senior Member

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?

Krzysztof Kowalczyk
Re: Select from partition ? [message #757803 is a reply to message #756678] Mon, 21 November 2011 18:12 Go to previous message
James Sutherland is currently offline James SutherlandFriend
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
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 : Wiki : Book : Blog : Twitter
Previous Topic:OnetoOne mapping issue
Next Topic:Select from partition ?
Goto Forum:

Current Time: Mon May 28 09:55:32 GMT 2018

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

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

Back to the top