Clovertech

Persisting SQL result as an XML file

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › Persisting SQL result as an XML file

  • Creator
    Topic
  • February 23, 2006 at 7:30 pm #48346
    John Perks
    Participant

      I am developing a tps procedure which uses odbc calls to retrieve orders from an Oracle database; I saw something in the DataDirect Connect documentation suggesting that the sql result could be persisted (i.e. saved) as an XML file.  But the odbc call to persist the data returns the SQL error “[DataDirect][ODBC Oracle Wire Protocol driver]Optional feature not implemented”.

      If anyone has any experience with this, questions, suggestions, please respond.

    • Creator
      Topic
    Viewing 4 reply threads
    • Author
      Replies
      • February 23, 2006 at 10:42 pm #58370
        Charlie Bursell
        Participant

          All I can tell you is that the message is what it is.  The feature was not implemented in our port of the ODBC API to Tcl

        • February 23, 2006 at 11:16 pm #58371
          Jim Kosloskey
          Participant

            John,

            Couldn’t you get the information via ODBC and send it through the engine (as a message) and Xlate it into XML; then deliver it to a file thread?

            Of course you would have to build your own schema ot DTD.

            Jim Kosloskey

            email: jim.kosloskey@jim-kosloskey.com 29+ years Cloverleaf, 59 years IT - old fart.

          • February 24, 2006 at 7:00 pm #58372
            John Perks
            Participant

              Jim,

              I am doing that now; I think I would have had to do that regardless in order to do a XML-HL7 xlate.  I was just trying to get the odbc call to build the tagged message for me, instead of coding the TCL procedure to do so.

              Regards,

              Jim

            • February 24, 2006 at 7:02 pm #58373
              John Perks
              Participant

                Or rather

                Regards

                John

              • March 7, 2006 at 8:57 pm #58374
                Scott Folley
                Participant

                  It is possible (I would think) to use a java upoc and jdbc-odbc to perform this function since there is a fair amount of likelihood that the good folks at Sun have implemented that functionality into the jdbc-odbc implementation.  No guarantees and it is a bit of a daunting prospect if you do not regularly program in java, but it might be an option.

                  *** please note all of the qualifiers…lol

              • Author
                Replies
              Viewing 4 reply threads
              • The forum ‘Cloverleaf’ is closed to new topics and replies.