Xml data display in ADF

11-30  Source: Network gathering  Views:2 

In ADF, I need to display a column from a table which is of xml data type. I get this oracle.sql.OPAQUE error in the column. Is there any other way to display the xml data type? Your help is really appreciated. Thanks.
Just to combine the response from steve into mine
To prepare your design*
1) create a xmlSchema that correspond to your document structure
2) use jaxb, castor or top link to generate java class to manipulate this content into a java application
3) import these classes into your jdev project
In the jdev application_
ui layer
Create a data control from xml mapped java classes (use the main object)
Use this data control structure to create ui component, including the method that check the content from the xmlSchema (castor)
middle tier, mapping
Take you xml content as CLOB from the database. Create a business component for this step. Get the xml content as a string (or stringBuffer if I remembering correct). Use this object to load the content into you xml java mapped interface (you will find the method in the object to achieve this step, marshal/unm,unmarshal).
Your xml data will be shown in you ui interface depending on the xml structure (and not as simple xml text, that you don't want I suppose).
To save the editing, you will have to transform you java object into plain xml (marshal/unmarshal), obtain a string again, load it into the business content and save it into the database.
Hope it's help you
Related articles
  • Xml data display in ADF 11-30

    In ADF, I need to display a column from a table which is of xml data type. I get this oracle.sql.OPAQUE error in the column. Is there any other way to display the xml data type? Your help is really appreciated. Thanks.Just to combine the response fro

  • FDTA - XML data display 11-30

    Hi Gurus, I have generated a file using F110 tcode..a XML file is created in FDTA tcode(DMEE tree file)...there are 2 ways of viewing that file in FDTA tcode..first one is directly select that file and click on display button(the file will be opened

  • Invoking binding operation from backing bean -- no data displayed in ADF table ? 11-30

    Hello experts, I have data control derived from  Web Service proxy client.  In this data control,  I have  multi record list derived from web service call.In my ADF page,  I have bunch of input components with many drop down lists and radio buttons,

  • DataGrid does not display XML data 10-11

    Hello, and thanks for reading this... I am having a problem displaying XMLList data in a DataGrid. The data is coming from a Tree control, which is receiving it from a database using HTTPService. The data is a list of "Job Orders" from a MySQL d

  • Display 'No Data Found' when there is inv data but still there is xml data 10-11

    Hi, I am converting an rdf to BI publisher. The issue is when there is no detail (inv) but still there is still xml data , due to which the report is getting printed with the skeleton template and blank details(inv). I need to avoid printing the repo

  • Loading new xml data into a already xml populated image display 10-11

    Hi everybody, I have a question about loading new xml data into a already xml populated image gallery. So I have my gallery set up so it calls some xml when it first loads. What I would now like to do is load different sets of images via a different

  • Display XML data bottom up 11-30

    I have a php form that when processed, opens an existing xml file and writes to the end of it: <code> $file_handle = fopen('products.xml','a'); $content=( <new product> <date>{$_POST['date']}</date> <name>{$_POST['name']}<

  • XML data extraction and new row display 11-30

    I have a table named, SAPDATABROWSER, which has multiple columns and rows. A column named SAPTEXT (DataType: CLOB) consist of xml data. Each XML data is different in terms of number of nodes, but has the same following structure: <SAP_BAPI_PROP> <

  • How to Display XML data on a Window within my JDev App? 11-30

    I want to display some XML data stored on the database (in a CLOB field) in such a way that the XML tags and values are colored/highlighted as if they were read in a browser like Internet Explorer. Currently I am displaying the data using a JEditorPa

  • How to search XML data from a HTTPMultiService and display the result on the Spark List 10-11

    Hello all, I am totally new to Flash Builder and Actionscript and hope someone might be able to help me out. I basically create a mobile app with a single view. The view has a TextInput as a search box and a search button. I conntected a Data/Service

  • Retrieving data from TCP/IP in xml and displaying values? 10-11

    Hey, I am using a program to retrieve data from a machine and outputting it in xml to the localhost.  On a seperate computer, I am trying to create a client application to read the xml data from that IP host and just output the important values inste

  • Graphs: Is it possible to take XML Data and display it as a graph in a LC Form? 10-11

    I am currently using LC ES2 Designer 9 to create PDF reports from XML data. We would also like to incorporate graphs into the PDFs. Has anyone done this or know if it is possible using LiveCycle? ThanksWhat I've seen, is people using a component to r

  • XML data not displayed on external applications (Adobe, PowerPoint, Word) 10-11

    Hi, I have imported an XML file into Xcelsius using the XML data connection button in Xcelsius 2008 SP1. I would like to test whether the model is correctly picking up the data when XML file is updated. The XML file is stored locally on my PC. I'm ab

  • Edit/add XML data in BI Publisher 10-11

    Hi I have a java program that is generating an XML file that I am using as input for my BI publisher for PO report. However, I want to add some extra information(location addresses corresponding to location id) that is not there in the XML and I cann

  • Regrouping the XML data source in BI Publisher 10-11

    Hello, We have a requirement in BI Publisher to develop a template accessing the data from different sources (data sets) and need to regroup the whole data by a field which exists in all the data sets. Below is the sample example of the source file <

  • XML Data ( View Total exist in a different query) 10-11

    Hi, This is a sample of my xml data : <TEST_COMP> - <LIST_G_Q1> - <G_Q1>   <Q1_ITEM_ID>61</Q1_ITEM_ID>   <TOT>13754492</TOT>    </G_Q1> - <G_Q1>   <Q1_ITEM_ID>62</Q1_ITEM_ID>   <TOT>1

  • Report Based on XML Data Template is timing out 10-11

    Hi there, i have an XML publisher report based on an XML data template that i've written. The report is working fine except when there is huge data that is supposed to come out, its timing out. Ive set the db_fetch_size parameter to 20 and scalable_m

  • XML data into Combo & List 10-11

    Hi I am too new to this and still tring to learn. Well here is what I am into. I am trying to make a simple product catalog, using native components      a combobox to display DISTINCT health issues      a listbox to display the products associated t

  • How to read XML data stored in CLOB in Concurrent prog Output 10-11

    Hi All, I'm trying to Generate the XML Data as concurrent Program output. I have a PL/SQL package which generated the XML data by using SQL/XML functions. I'm storing the generated XML data in a CLOB variable. But when i try to read the data using fn

  • Importing XML Data Back into the Form 10-11

    I have a form that shows several subforms based on the selections the user has made while filling in the form. This is working quite well but when I import the XML data back into the form it doesn't show the subforms that have been used. Is there an