XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Defining 'connection string' for ddtek:sql-insert at runtime.
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + Grouping (2)
-> + Best Practice for Pipeline err... (2)
-> + pdf generation (4)
-> + Problems excuting a Pipeline w... (2)
-> + XML serializer (3)
-> + Supported EDIFACT versions (5)
-> - Anyone know XActimate ESX file... (1)
-> + Stylus Studio with OpenJDK (2)
-> - Encoding error when importing ... (1)
-> - SEO Service in Delhi, India (1)
-> - HP Printer Support (1)
-> + Stylus Studio X16 Professional... (5)
-> + Stylus Studio X16 Enterprise -... (4)
-> - Overly complicated formatting ... (1)
-> + java apparently running, canno... (2)
-> + Stylus on Citrix - unable to v... (6)
-> + XSLT and XPath Questions (New ... (13)
-> + EDIFACT D96A CONTRL XML schema (2)
-> + JDK dropdown box empty and Jav... (2)
-> + Replacing XSD files in Report (4)
-> + Cannot locate WYSIWIG tab on X... (3)
-> + EDI X12 xml schema with segmen... (2)
-> + Error Message (4)
-> + jvm disabled message keeps pop... (2)
-> + XTSE0620: An xsl:param element... (3)
-> + Fail in installing “Apache FOP... (5)
-> - Jenkins: about the path of bui... (1)
-> + problem with Stylus X15 XML RE... (2)
-> + Cannot remove a row into a tab... (6)
-> + prevent the meta data from bei... (3)
-> + Unable to auto detect JRE in X... (2)
-> - Unable to auto detect JRE in X... (1)
-> - where to find information (1)
-> + X16 - XPath 3.0, XQuery 3.0, X... (2)
-> - Test (1)
-> + XSLT debugger shows [symbol u... (3)
-> - How do i use *.conv to process... (1)
-> - How do i use *.conv to process... (1)
-> + Not able to configure JVM in ... (5)
-> + Converting Cobol flat file to ... (2)
-> + Problem with uninstall - Windo... (2)
-> + Function current() is not reco... (6)
-> + API or web version (2)
-> + How to use Saxon for X16 on WI... (9)
-> + Error in SS X14 syntax highlig... (2)
-> + Option not available (2)
-> + XML Diff functionality and sor... (3)
-> + Convert Oagis XML file to TXT (4)
-> + DataDirect xqresultsequence is... (2)
-> - xfile Legacy file format suppo... (1)
-> + TPFDF (3)
-> + Help needed with SLSRPT - EDIF... (2)
-> - keeps crashing after I try and... (1)
-> + Can SS do this? (14)
-> - CargoImp support (1)
-> + No Preview Displayed - File is... (3)
-> - Stylus Studio X16 build 1974l ... (1)
-> + Help! Help!Help! Regading form... (2)
-> + FileNotFoundException generati... (6)
-> + FO External Graphic Producing ... (2)
-> + Use of Java methodes (4)
-> + get generated XQuery output on... (2)
-> - right construct for involving ... (1)
-> + SS JRE Version has "Stylus Stu... (3)
-> + Trying to validate an XSD: co... (3)
-> + Disable "Output" windows (4)
-> + Stylus Studio V16 X64 update d... (2)
-> + Could not load the Java Virtua... (2)
-> + .NET XslCompileTransform strip... (6)
-> + XML Report Preview and Save Ev... (8)
-> + X16 Enterprise 32bit crash on ... (5)
-> - MSXML6.0 SAX Parser, "Index re... (1)
-> + MSXML6.0 DOM Parser stops afte... (4)
-> + How to disable checking for up... (2)
-> + XML Publisher requires duplica... (4)
-> + Modifying Field Name in XML (4)
-> + Java Runtime Environmnet Libra... (2)
-> + Passing Parameters and Multipl... (4)
-> + Total Newbie Question... where... (3)
-> + XML Pipeline (2)
-> + Encoding problem in text previ... (5)
-> + New Installation on windows 20... (4)
-> - Exception while calling Java m... (1)
-> + Jars to be included for callin... (2)
-> + SXXP0003: Error reported by XM... (2)
-> + Validation error (5)
-> + Windows 10, latest Java, new t... (2)
-> + using help crashes stylus stud... (3)
-> + Web Service Call error (5)
-> + javax.xml.xquery.XQException: ... (2)
-> + Trang translator is not availa... (2)
-> + Replacement for flat2xml (2)
-> + CONV CSV Display Problem (3)
-> + StylusValidator.exe Command Li... (3)
-> + Cannot run Java built in valid... (2)
-> + Windows 10??? (3)
-> + Stylus Custom XML Conversion (... (8)
-> + X14 enterprise and saxon 9.4.0... (3)
-> + Open an XML document in the XM... (3)
-> + How to generate mapping report... (4)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
chris miszturSubject: Defining 'connection string' for ddtek:sql-insert at runtime.
Author: chris misztur
Date: 12 Jun 2013 02:21 PM
ERROR:
"Argument 1 of function 'ddtek:sql-insert' must be a string literal."

XQUERY:
ddtek:sql-insert(mf:getConnectionString("F0101Z2")...)

QUESTION:
I have a requirement to execute the same xquery against different database environments. Can I do this with the same xquery document but different dbs?

-c
Postnext
Ivan PedruzziSubject: Defining 'connection string' for ddtek:sql-insert at runtime.
Author: Ivan Pedruzzi
Date: 12 Jun 2013 02:58 PM
This is by design, DataDirect XQuery requires a literal to identify the table.

You will need to create multiple queries. You may also insert on multiple tables from the same query as long as the tables resides on the same database.


Ivan Pedruzzi
Stylus Studio Team
Postnext
Ivan PedruzziSubject: Defining 'connection string' for ddtek:sql-insert at runtime.
Author: Ivan Pedruzzi
Date: 12 Jun 2013 03:05 PM

notice also that the first argument is not a connection string but a table name.

The database connection (server, driver port, username, password, ...) is set outside the query.

In Stylus Studio you do that when you drag&drop a connection from File Explorer into the XQuery Editor.

When running the XQuery processor through the API you have to setup such connection in DataSource object
http://www.datadirect.com/resources/dis/xqj-tutorial/index.html


Ivan Pedruzzi
Stylus Studio Team

Postnext
chris miszturSubject: Defining 'connection string' for ddtek:sql-insert at runtime.
Author: chris misztur
Date: 12 Jun 2013 03:18 PM
I do see the connection info in the xqery metadata. So basically I would have to pre-process the file somehow to alter the metadata or API or create another xquery.

Do you have a .NET port of the SS api?
Postnext
Ivan PedruzziSubject: Defining 'connection string' for ddtek:sql-insert at runtime.
Author: Ivan Pedruzzi
Date: 12 Jun 2013 03:46 PM

I have to warn you, changing the metadata block outside Stylus Studio is not supported, this means there is no guarantee that will work on future releases.

DataDirect XQuery is only available as Java library.

Ivan
Postnext
chris miszturSubject: Defining 'connection string' for ddtek:sql-insert at runtime.
Author: chris misztur
Date: 13 Jun 2013 08:06 AM
Even though it's not supported and I might change my mind as the xquery complexity changes, this works for me ... for now.

http://pastebin.com/2MCn2awz

Postnext
chris miszturSubject: Defining 'connection string' for ddtek:sql-insert at runtime.
Author: chris misztur
Date: 13 Jun 2013 08:31 AM
And the executing batch file looks like this:

%SystemRoot%\system32\WindowsPowerShell\v1.0\powershell.exe -command "Set-ExecutionPolicy -Scope Process -ExecutionPolicy Unrestricted; . .\AriadneChangeEnvironment.ps1; AriadneChangeEnvironment %1 %2"
Postnext
chris miszturSubject: Defining 'connection string' for ddtek:sql-insert at runtime.
Author: chris misztur
Date: 12 Jun 2013 03:43 PM
also, in a pipeline, is there a way to select the xquery scenario or whichever one is default is the one executed?
Posttop
chris miszturSubject: Defining 'connection string' for ddtek:sql-insert at runtime.
Author: chris misztur
Date: 12 Jun 2013 04:10 PM
I answered my own question. I see the declared external variables as inputs to the xquery files.
   
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!  
go

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.