Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tricky: Column sort with Popup-key LOV

614097Feb 8 2008 — edited Feb 27 2009
Hi everyone,

I guess this is a tricky one:
Column sorting doesn't seem to work if you have a Popupkey LOV in your tabular form.

See the following example:
http://quickimg.com/uploads/f6388ab3680bdeac63cb8795a98d81fe.png

(The yellow fields you see are form detail information displayed by the Firefox Extension Web Developer Toolbar, highly recommendable, by the way)

The form element names now are in the right order (00, 01, 02, 03 ...).

However, if you sort the table by Column 1 (Source) this order gets tumbled:
http://quickimg.com/uploads/93b976c603132db84fc8881211617718.png

That's quite some problem because the Key returned by the popup refers to the ROWNUM which does not correlate with the correct row anymore.

Anyone got an idea how to workaround this problem?

cheers,

Michael

Comments

alwu-Oracle
What is your DB version and what version of Jena Adaptor are you using?

Thanks,

Zhe Wu
Ram Krishna
The oracle database is v11.1.0.7 and we are using the new Jena adaptor (rel 3) that we got from our metalink site.

ram
alwu-Oracle
Hi,

It seems that the new version of Jena Adaptor is doing the right job to convert the whole SPARQL into a single SEM_MATCH based query. Now the problem is that 11.1.0.7 database has this known server side bug (table function related) when the query is too big. You did not see this problem with Jena Adaptor v2 because ARQ breaks the query into many small pieces.

To fix this problem, there are a few choices:

1) upgrade to database 11.2, or
2) shorten your query, or
3) file a tar with Oracle support.

We are working on an optimization in Jena Adaptor to convert a SPARQL (with just a base BGP and a number of parallel OPTIONAL clauses) into a plain SQL. This may solve your problem even if you continue use 11.1.0.7.

Cheers,

Zhe Wu
1 person found this helpful
Ram Krishna
Thanks Zhe- that is helpful. We will use one of the workarounds before we switch to 11.2.

ram
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 27 2009
Added on Feb 8 2008
#apex-discussions
9 comments
2,286 views