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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  Problems with XQuery

    Posted 08/29/01 01:56 PM

    Hello,
    I have some problems with XQuery.
    when I query Tamino database, using java API

    String str =
    “//menuLeaf[@src=‘100301_140745_0.xml’]”;
    TaminoResult tr = tamino.query(str);
    System.out.println(tr.toXmlString());

    I have such result:
    ino:messagelineXQL Request processed, no object
    returned</ino:messageline>

    When I repeat this query once again I have result:
    <ino:messagetext ino:code=“INOXYE9279”>Internal database error has occurred</ino:messagetext>

    but when I do the same query, using Tamino Interactive Interface I have another rasult

    - xql:result


    </xql:result>

    Would you explain me please what’s a difference between these queries and why I have internal database error?


    #API-Management
    #Tamino
    #webMethods


  • 2.  RE: Problems with XQuery

    Posted 08/31/01 03:58 AM

    The query looks OK. Have you checked your csDatabaseURL (your base URL)?

    eg. http://localhost/tamino/mydb/mycollection


    #API-Management
    #Tamino
    #webMethods


  • 3.  RE: Problems with XQuery

    Posted 08/31/01 10:14 AM

    Hi:

    It’s very strange that you have in your Interactive Interface response two documentes with the same ino:id

    - xql:result
    <menuLeaf **** ino:id=“1” **** name=“SMTH” src=“100301_140745_0.xml” />
    <menuLeaf **** ino:id=“1” **** name=“SMTH” src=“100301_140745_0.xml” />
    </xql:result>

    You can make check and repair of your database with Tamino Manager or delete and reload this document.

    Regards.


    #webMethods
    #API-Management
    #Tamino


  • 4.  RE: Problems with XQuery

    Posted 08/31/01 11:49 AM

    Hi easy!

    I have checked the path to the database several times. It’s correct.
    Other queries, for example //menu, execute by the database coprrectly.

    I think something wrong with the query I wrote in my last question.
    I have another guess maybe something wrong with my database - administrate wrong or something else.
    What do you think?


    #Tamino
    #API-Management
    #webMethods


  • 5.  RE: Problems with XQuery

    Posted 08/31/01 05:31 PM

    the query looks correct. as juan pointed out (and i missed out earlier), the results seem a bit odd. I’ve yet to see Tamino return duplicate ino:id’s. As juan has mentioned, something could really be wrong with the database.


    #Tamino
    #API-Management
    #webMethods


  • 6.  RE: Problems with XQuery

    Posted 09/03/01 11:36 AM

    The result of the query is not dublicated. You see “menuLeaf” twice because of it’s met twice in the same document. So the result is correct.
    I am confused that the internal database error is appeared during the query when I do this query USING the java API.

    Juan recomended me to check and repair the database. I did. Nothing changed. Also he said “to delete and reload the document”. I did too. The same situation.
    Have you got any ideas else?


    #webMethods
    #Tamino
    #API-Management


  • 7.  RE: Problems with XQuery

    Posted 09/04/01 10:20 AM

    Hi:

    The document is not duplicated, i made a mistake.
    I have prove something like this and no error have been returned.
    You can try to set a pagesize (my Taminio Interactive Interface set pagesize to 16):

    tamino.setPageSize(16);

    And can try to answer from first element:

    tr=tamino.query(str,1);

    I have made a program in Java 1.3 to test response time with Tamino Java API or URL (Tamino Interactive Interface). I can send you this by e-mail, the only problem is the language of this program is Spanish.

    Regards.


    #API-Management
    #Tamino
    #webMethods


  • 8.  RE: Problems with XQuery

    Posted 09/04/01 03:09 PM

    Hi, Juan.

    I have tried to set another pagesize and to answer from first element. Unfortunately the same situation. :frowning:
    I like your idea to send me your program. It’s ok that it is in Spanish. Just in case my e-mail: nata@alee.com
    From my side I can send you my program if you don’t mind. Maybe you can find a mistake.
    I look forward to hear from you soon.
    Thank you for your interest.


    #API-Management
    #webMethods
    #Tamino