Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

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!

Shuttle Bean with a Composite View Link

BradWFeb 18 2014

JHS Version 11.1.2.??

It appears there is a bug in the Shuttle Bean.  When creating the otherParentRefAttrs, it puts the values in a HashMap.  At first glance, this looks simple enough.  However, each new map-entry is added at the beginning of the HashMap and thus when creating a key like the bean does, it creates a corrupted key as the values are not in the proper order.  For now, I have been putting the values in reverse order in the taskflow.  This seems to have resolved the issue...  Definitely not ideal as I am sure that this behaviour could change.  I am thinking of changing this to an array list with a delimited entry so that the values can always be in the proper order.  This proves to be a bit too much from a template perspective.  So, I had to do this in my own ShuttleBean class on setting of the other params.

Thoughts on this???


BradW

Comments

i don't see that behavior, also on 4.1.3

monitor_session_query.jpg

Buntoro

Hi Jeff,

It seems to be program specific problem.

We have an old ETL Tools called Sagent and it seems all queries fired from that tool are coming in this one-line format.

Notice the horizontal scroll bar at the bottom.

Please don't mind the Master layout of the Session Monitor, which I adjust to be more informational with Gauge Bar and so on.

pastedImage_2.png

For the time being, I need to open another worksheet, copy and paste that line and use Ctrl + F7 to re-format.

pastedImage_4.png

Thank you for clarifying.

Regards,

Buntoro

Buntoro

Hi Jeff,

On second thought.

I need to unmark as correct.

Probably this problem happened on DML command (insert / update / delete) only.

Here is another example, query coming from user tool (PL/SQL Developer).

pastedImage_0.png

I try to dig into the query for "Active SQL" and try to execute it myself on worksheet.

Notice the SID = 2024 which I get from the above.

I thought that it will return one line, which justify why SQL Dev show single line output.

However, as you can see it is not.

pastedImage_1.png

The question still hold.

Regards,

Buntoro

you customized the report...does it do this on the original Tools > Monitor Session screen?

Buntoro

I copy the Report from the Template (All Reports - Data Dictionary Reports - Database Administration - Sessions - Sessions).

And paste it under User Defined Reports, and name it Session Browser instead.

Every time I open Tools - Monitor Sessions, it seems to be pointing out to the User Defined Reports - Session Browser (the one that I modified).

Regards,

Buntoro

thatJeffSmith-Oracle

what's the sql behind your report? compare it to mine in the screenshot up top

tools > monitor sessions going to your custom report...that would be weird. maybe something else is happening

Buntoro

Hi Jeff,

Mine is :

select replace(q.SQL_TEXT, chr(0), chr(10) || chr(13)) sql_text

  from gv$session s, v$sqltext_with_newlines q

where  s.sql_address = q.address

  and  s.sql_hash_value = q.hash_value

  and  s.sid = :SID

order by q.piece

I also tried yours too. But on detail tab produces the same result.

select replace(q.SQL_FULLTEXT,chr(0)) sql_text

  from gv$session s, gv$sql q

where  s.sql_address = q.address

  and  s.sql_hash_value = q.hash_value

  and  s.sid = :SID

FYI, if executed on Worksheet

My query will produce multiple rows result

Your query will produce single line result

Nevertheless, both produce the same single line output on Detail tab.

Regards,

Buntoro

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

Post Details

Locked on Mar 18 2014
Added on Feb 18 2014
0 comments
867 views