OraFAQ Forum: JDeveloper, Java & XML » Sorting Issue in ViewObject(Without database trip i want to sort fetched record by column)

Home » Developer & Programmer » JDeveloper, Java & XML » Sorting Issue in ViewObject(Without database trip i want to sort fetched record by column)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sorting Issue in ViewObject(Without database trip i want to sort fetched record by column) [message #274265]

Mon, 15 October 2007 04:54

janak.nirmal
Messages: 5
Registered: October 2007

Junior Member

Hello,

I am having 1 view which is fetching some records from database. Now my requirement is that i want to sort those records by column name without going to database.

I am using Jdeveloper 10.1.2.1.0 which does not have such kind of facility compare to new Version 10.1.3.

Does anybody have any idea how it can be accomplish ?

any help would be heartily appreciated...

Thanks in advance

Janak

Report message to a moderator

Re: Sorting Issue in ViewObject(Without database trip i want to sort fetched record by column) [message #274273 is a reply to message #274265]

Mon, 15 October 2007 05:14

Frank
Messages: 7901
Registered: March 2000

Senior Member

I really doubt if that would be possible, since the data is fetched in batches, based on the previous order..
This can only work if the set you display is the complete set (or you only want to sort the displayed set)

Report message to a moderator

Re: Sorting Issue in ViewObject(Without database trip i want to sort fetched record by column) [message #274279 is a reply to message #274273]

Mon, 15 October 2007 05:46

janak.nirmal
Messages: 5
Registered: October 2007

Junior Member

Hello Frank,

Thank you so much for immediate response.

I surfed for this issue and i got 1 link

http://radio.weblogs.com/0123729/2003/10/09.html

Here everything is mentioned for the issue i am having. I tried this solution but it get stuck when implemented.

It is going in infinite loop somewhere in condition.

Please if you can look at this code and suggest any changes may be I will get solution.

Once again Thanks a lot for immediate response.

Thanks
Janak

Report message to a moderator

Re: Sorting Issue in ViewObject(Without database trip i want to sort fetched record by column) [message #274350 is a reply to message #274279]

Mon, 15 October 2007 13:19

Frank
Messages: 7901
Registered: March 2000

Senior Member

janak.nirmal wrote on Mon, 15 October 2007 12:46

I surfed for this issue and i got 1 link

http://radio.weblogs.com/0123729/2003/10/09.html

Ok, that's good you found an example!

Quote:

It is going in infinite loop somewhere in condition.

I don't see a method called condition.
How do you know it is in an infinite loop? The only way of knowing is to use debug. That should also reveal the reason why it does not get out.
Since I have no idea in which part you are looping, I cannot help you out.

Report message to a moderator

Re: Sorting Issue in ViewObject(Without database trip i want to sort fetched record by column) [message #274409 is a reply to message #274350]

Mon, 15 October 2007 23:55

janak.nirmal
Messages: 5
Registered: October 2007

Junior Member

Hi Frank,

Once again Thank you to have a look at issue.

I debug the execution.

In the method executeQueryForCollection() it goes perfactly for the first time and creates new view on the basis of current view.

Than sortData(qc) is called. It also gets executed fine. Now when
super.executeQueryForCollection(qc, params, noUserParams); is executed it goes into

createRowFromResultSet(Object qc,ResultSet resultSet) method here mSortData is getting always true as it is true by default.

So else part is executed in IF condition.

Here it is coming in another IF condition beneath the ELSE Part condition and i put System.out.println in that part like this .

system.out.println("before indx ---->"+indx );
ViewRowImpl rowBase=(ViewRowImpl)mUnsortedBaseVO.getRowAtRangeIndex(indx);
system.out.println("after indx ---->"+indx );

now here it is not print these after SOP. so i m confused that what is wrong with this.

Please Help out if you can.

Once Again Thanks,

Janak

Report message to a moderator

Re: Sorting Issue in ViewObject(Without database trip i want to sort fetched record by column) [message #274448 is a reply to message #274409]

Tue, 16 October 2007 01:58

Frank
Messages: 7901
Registered: March 2000

Senior Member

Did you wrap the line in a try-catch (Exception e)?
It might be that it fails, causing the after indx not to be printed. That would make you search in the wrong place.

Report message to a moderator

Re: Sorting Issue in ViewObject(Without database trip i want to sort fetched record by column) [message #276792 is a reply to message #274448]

Fri, 26 October 2007 06:03

janak.nirmal
Messages: 5
Registered: October 2007

Junior Member

Hello Frank

I want to know that whether executeQueryCollection() method will go to database and fetch the result or what ?

I solved the problem and now I am getting sorted records. But now my question is that whether view is going to fetch data from database when i m sorting records.

Can you help me out ?

Thanks,
Janak

Report message to a moderator

Re: Sorting Issue in ViewObject(Without database trip i want to sort fetched record by column) [message #276802 is a reply to message #276792]

Fri, 26 October 2007 06:11

Frank
Messages: 7901
Registered: March 2000

Senior Member

That should be easy enough to test.
Fetch your data, update the data in the database & commit, and then call executeQueryForCollection()

Report message to a moderator

Re: Sorting Issue in ViewObject(Without database trip i want to sort fetched record by column) [message #277555 is a reply to message #276802]

Tue, 30 October 2007 09:32

janak.nirmal
Messages: 5
Registered: October 2007

Junior Member

Hello Frank,

I checked about it and it is reflecting the data.

Can you tell me executeQuery() method of ViewObject is actually going in database or what ?

how do it fetches the records ? I mean whether to go in database or from cache ? how does Shocked

the viewobject knows from where to fetch data?

I mean everytime it is going in database. So what is the benefit of having view Shocked

.

Thanks,
Janak

Report message to a moderator

Previous Topic:	too many process with Connection OCI
Next Topic:	Removing Whitespace from XML with DBMS_XMLGEN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 23:49:48 CST 2025