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)
-> + Specifying EDI Delimiters (2)
-> - Defining 'connection string' f... (9)
-> ->Defining 'connection stri...
-> ->Defining 'connection stri...
-> ->Defining 'connection stri...
-> ->Defining 'connection stri...
-> ->Defining 'connection stri...
-> ->Defining 'connection stri...
-> ->Defining 'connection stri...
-> ->Defining 'connection stri...
-> + Help Programatically Convertin... (2)
-> + Using adapter URL in pipeline. (7)
-> + How to enable EDI functionalit... (2)
-> + Unable to open file with '%2F'... (2)
-> + How to create a dependency gra... (2)
-> + If block (2)
-> + Mapping multiple files within ... (7)
-> + StylusStudio vs Altova vs BizT... (4)
-> + Command line execution (7)
-> + CSS and Styling in X15 (2)
-> + Ignores debug breakpoints in X... (5)
-> + Cursor dissapearing in Text vi... (5)
-> + compile error xquery java styl... (3)
-> + Stylus Studio Setup: Applicati... (10)
-> + Stylus StudioX15 Crashing whe... (4)
-> + Upgrade Stylus 14 to 15 (2)
-> + ACE Broker Download v2.5 (2)
-> + Help creating custom convertor (7)
-> + Problem saving Documentation (5)
-> + Registry keys for Stylus x15 (8)
-> + How to add a value when conver... (10)
-> + Stylus Studio Pro & Ent X15r1 ... (2)
-> + You need to install Java 2 SDK... (4)
-> - How to disable automatic and m... (1)
-> + Does Stylus Studio / DataDirec... (4)
-> + Stylus Studio fails with 'The ... (12)
-> + Struzzo.exe side by side confi... (7)
-> + unable to use converter (5)
-> + How to enable XSD 1.1 for Saxo... (3)
-> + XSD v.1.1 validation and Xerce... (8)
-> + FATAL ERROR: unsupported XML v... (2)
-> + Java Runtime Environment boot ... (2)
-> + Associate XML with Schema (3)
-> + JVM not found in stylus studio... (2)
-> + Change newline to Linux (on Wi... (4)
-> + Indent XML Tags only partially... (2)
-> + dealing with invalid character... (2)
-> + Unable to call Webservice thro... (2)
-> + XML to CSV Video create csv te... (5)
-> + Try to test this product, (2)
-> + How to migrate license? (3)
-> - kepp your settings on X15 upda... (1)
-> + No Topic (2)
-> + XSD validation scalability iss... (2)
-> + Installing documentation in ai... (4)
-> + Stylus Studio is currently una... (2)
-> + Change from SS Pro 2011 to SS ... (2)
-> + Problem with pipeline function... (2)
-> + Min and Max Occurs for Choices... (2)
-> + XSLT without Preview window ou... (3)
-> + How to achieve this transforma... (2)
-> + Licence Authentication Failed (2)
-> - using Oracle V2 for validation... (1)
-> + Steps needed to execute standa... (2)
-> + xsi:noNamespaceSchemaLocation ... (8)
-> + Using Saxon 9.4 and integrated... (4)
-> + "net XML Parser (5)
-> + How to undo in Stylus Studio X... (2)
-> + .RENAME section not loaded cor... (3)
-> + Stylus StudioŽ X14 Release 2 X... (2)
-> + The JVM initialization failed ... (2)
-> + XML schema to XML does not wor... (4)
-> + missing ExtraLines (3)
-> + EDI validation tool (2)
-> + Registering Custom Tool from c... (5)
-> + Setting Default XML Validation... (2)
-> + Project Directory in Custom Do... (3)
-> + Problem with Saxon 9.4.0.4 AVT... (5)
-> + XML To HL7 (3)
-> + Siblings not repeating when mi... (7)
-> + Nesting of records from fixed ... (5)
-> + Licensing (3)
-> + CSV set up to support predefin... (10)
-> + Scripting conversion (2)
-> + Edi/Euritmo automatic conversi... (4)
-> + Have new stylesheet automatica... (3)
-> + Text file to CSV to xml (9)
-> + EDIFACT to XML (4)
-> + About Stylus Studio... dialog ... (5)
-> + Set Stylus as default editor f... (3)
-> + CSV to XML (11)
-> + Indent XML tags no longer work... (9)
-> + XSL code completion moe like o... (3)
-> + xsl:fo - unable to use any fon... (5)
-> + Bug when calling a ms script f... (13)
-> - url schema (1)
-> + Quickbooks invoice to XML (4)
-> + X14 locks up, Unresponsive (4)
-> + Fields missing from middle of ... (2)
-> + Cannot install trial (2)
-> + Text File with Page breaks - H... (8)
-> + Complex transactional CSV mapp... (2)
-> + XML Report (2)
-> - Create an XML feed for videos (1)
-> + word doc (2)
-> + Saving to a UNC path (7)
-> + sharing violation (3)
-> + Convert XML to XML (6)
-- Previous [181-200] [201-220] [221-240] 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.