Persisting SQL result as an XML file

This topic has 5 replies, 4 voices, and was last updated 18 years, 6 months ago by Scott Folley.

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.

Persisting SQL result as an XML file

Forums

Forum Statistics