Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.4K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187.1K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 443 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Escape option for ADF outputText leading to Error 404 in case of CLOB datatype

Dear All,
I am using Jdeveloper 12.1.2.0.0 version for development.
I am facing a problem regarding CLOB columns display as a outputtext. The use case is as follows:
I have a DB column with CLOB as a datatype containing HTML and scripts for jasper reports server. I am displaying it as an outputtext with "escape" option marked "false" , it works fine. Everything loads and BI report works as it is supposed to do but the problem is whenever I click any other component of the application i.e. Home or Language change it crashes with Error 404. I have tried Escape option with simple text fields from bean and hard coded value as well, it works fine for them and doesn't lead to crash. What I believe is that it's CLOB type which is creating problem when used with escape option marked to false. I have also tried applying converter for generic domain but all in vain. Any help is this regard would be much appreciated.
Warm Regards,
--Magwaa
Answers
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,462 Red Diamond
Magwaa, check the page source of the resulting page. E.g. you can copy the source into an editor and verify that the html is valid.
Then you can use your browsers development tools and inspect the network traffic when you click the button. You should see which artifact causes the 404.
Timo
-
Hi Timo,
The page is fine. HTML and everything inside is perfectly running with graph rendering as well. But once i click on Home Page button to go back it goes to 404 without showing any error on weblogic console.
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,462 Red Diamond
You have to check the javascript console, not the weblogic console. The 404 error means that you try to get an artifact but the uri can't be reached. The interesting part is to find out which artifact causes the problem.
Timo
-
There is no error in Browser console, nothing related to any HTML artifact.
<?xml version='1.0' encoding='UTF-8'?>
<jsp:root xmlns:jsp="http://java.sun.com/JSP/Page" version="2.1" xmlns:af="http://xmlns.oracle.com/adf/faces/rich"
xmlns:f="http://java.sun.com/jsf/core">
<af:panelGroupLayout id="pgl1" layout="scroll">
<af:switcher id="s1" facetName="#{sessionScope.lang == 'ar' ? 'arabic' : 'english'}"
defaultFacet="#{sessionScope.lang == 'ar' ? 'arabic' : 'english'}">
<f:facet name="arabic">
<af:outputText value="#{bindings.HtmlContentArb.inputValue}"
shortDesc="#{bindings.HtmlContentArb.hints.tooltip}" escape="false" id="it2"/>
</f:facet>
<f:facet name="english">
<af:outputText value="#{bindings.HtmlContentEng.inputValue}"
shortDesc="#{bindings.HtmlContentEng.hints.tooltip}" id="it1" escape="false"/>
</f:facet>
</af:switcher>
</af:panelGroupLayout>
</jsp:root>
This is the code of a fragment which is part of a BTF and thrown on jspx page as a region. Application runs smooth when clicked inside the fragment, graph response etc. But when clicked on any any action outside this it goes out.
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,462 Red Diamond
Have you looked at the network tab in the browser?
Timo
-
This is happens on Network Console. Before that everything works perfectly fine. URL changes to:
../faces/BI-reports-html-landing-btf/BIReportsHTML?_afrLoop=331664650616142&_afrWindowMode=0&Adf-Window-Id=w0
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,462 Red Diamond
And what is the url before that?
Timo
-
it's just IP of my machine and port along with context root of application.
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,462 Red Diamond
So, somewhat is changing the context url. You need to find this 'something' and then think about how to prevent it.
Timo
-
Hi Timo,
Thanks a lot for tagging along all the way. The problem is resolved. Actually the HTML was using <form> tag and they were many in number. Even a single <form> tag was causing the change in View Root of the application. Removing the <form> tag did the trick. Special thanks to you