XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> - Stylus Studio - Registrar en o... (1)
-> + Stylus Studio - Registrar en o... (2)
-> + Can a pipeline send a file by ... (2)
-> + After Updateing WIN10 to WIN11... (12)
-> + Where do I add the custom java... (3)
-> + Where is the Diagram tab? (5)
-> + Applying XSLT to Word DOCX/XML (2)
-> - CSV conversion via ConvertToXM... (1)
-> + Text symbols in SS not same as... (4)
-> + Exposing xquery as webservice ... (6)
-> + Syntax Identifier (2)
-> + Saving a Converted XML as an X... (5)
-> + Output document cannot be pars... (4)
-> - Archiving output from conversi... (1)
-> + EDIFACT guideline from Stylus ... (3)
-> + CSV file putting all the data ... (5)
-> + Can't install Home version 64b... (5)
-> + presale - Can I covers this sc... (5)
-> + Problem with UNB (5)
-> + Splitting EDIFACT files pipeli... (4)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2016)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Christopher ArthurSubject: ddtek:sql-delete
Author: Christopher Arthur
Date: 21 Feb 2008 04:56 PM
Hi, I'm having a problem with ddtek:sql-delete when I try to run it outside of Stylus Studio in our production environment. We use Stylus Studio 2007 to develop pipelines and complile them for Java which we run under DataDirect on a server.

I have a pipeline that uses ddtek:sql-delete that is failing with the following message:

Failure executing XML Pipeline com.edictsystems.xmlpipeline.KawasakiAccessoriesItems.KawasakiAccessoriesItems com.stylusstudio.xmlpipeline.runtime.PipelineException: Delete from BINLOC: Unable to convert value for parameter {http://org.jcp.xqj}context-item to a DOM.

The entire XQuery is the following line with a database reference:

The name of the table is actually longer with a schema name but I removed the names of the innocent. The entire pipeline runs without a hitch in Stylus Studio on my machine but once we port the compiled pipeline over we get this error and I have no idea what the error means really. I get that it is having problems converting a parameter to the type it needs but not why when it works fine in Stylus Studio. Any insight and help is appreciated.

Minollo I.Subject: ddtek:sql-delete
Author: Minollo I.
Date: 21 Feb 2008 05:35 PM
It sounds like a problem in the generated pipeline code; what version and build number (Help > About) of Stylus Studio (which generates the pipeline) are you using? Can you email us the Java code for the pipeline at stylus-field-report@progress.com?

Christopher ArthurSubject: ddtek:sql-delete
Author: Christopher Arthur
Date: 22 Feb 2008 09:32 AM
We are currently using Stylus Studio 2007 XML Enterprise Suite build 894m with DataDirect 3.0. I will email the code for the generated pipeline.

Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.