IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Loading xml objects in to database

  • 1.  Loading xml objects in to database

    Posted Wed November 07, 2001 08:01 AM

    When i try to load xml objects in database it is always loaded in ino:etc instead of getting loaded in hospital collection.I had followed sequence given in tamino docs.

    schema file which i am using is

    <?xml version="1.0"?>

    <ino:collection ino:name=“Hospital” ino:key=“Hosp01”>

    <ino:doctype ino:name=“patient”
    ino:key=“Patient001”
    ino:options=“READ INSERT UPDATE DELETE”>

    <ino:node ino:name=“patient”
    ino:key=“Patient002”
    ino:obj-type=“SEQ”
    ino:parent=“Patient001”
    ino:search-type=“no”
    ino:map-type=“native”/>

    <ino:node ino:name=“name”
    ino:key=“Patient003”
    ino:obj-type=“SEQ”
    ino:parent=“Patient002”
    ino:search-type=“no”
    ino:map-type=“native”/>

    <ino:node ino:name=“surname”
    ino:key=“Patient004”
    ino:obj-type=“PCDATA”
    ino:parent=“Patient003”
    ino:map-type=“InfoField”
    ino:data-type=“WCHAR”
    ino:search-type=“text standard”/>

    <ino:node ino:name=“firstname”
    ino:key=“Patient005”
    ino:obj-type=“PCDATA”
    ino:parent=“Patient003”
    ino:map-type=“InfoField”
    ino:data-type=“WCHAR”
    ino:search-type=“text standard”/>

    </ino:doctype>

    </ino:collection>


    And xml file is

    <?xml version="1.0"?>



    Bloggs
    Fred


    I confirmed that this xml object is getting loaded in ino:etc by using a xquey
    database:
    http://localhost/tamino/test1/ino:etc?_xql=patient

    query;
    patient

    it gives me result,but i want this xml object to be loaded in Hospital collection instead of ino:etc.

    Thanx
    Swapnil


    #API-Management
    #webMethods
    #Tamino


  • 2.  RE: Loading xml objects in to database

    Posted Wed November 07, 2001 09:48 AM

    Hi,

    When inserting documents you need to specify the collection name, otherwise ino:etc is assumed. So the URL is http://localhost/tamino/myDB/hospital.

    If you use the TII to load data, then simply specify http://localhost/tamino/myDB for the database, and hospital for the collection. A little Javascript in the TII just concatenates these two values together.


    #Tamino
    #API-Management
    #webMethods