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 (1182)
- Stylus Studio Technical Forum (14569)
-> + 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)
-> + Problem with SAXO processor - ... (5)
-> + PDF Format Help (4)
-> + License check unreliable (2)
-> - XML related issue (1)
-> + Need help regarding pipeline o... (2)
-> + Error converting XML to EDIFAC... (4)
-> + XSLT Profiling for XSLT 1.0 s... (2)
-> + 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)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (247)
+ XSLT Help and Discussion (7617)
+ XQuery Help and Discussion (1966)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Jon RobertsSubject: Automation using Visual Studio
Author: Jon Roberts
Date: 19 Mar 2008 12:24 PM
Originally Posted: 19 Mar 2008 12:23 PM
I'm after a little direction, please. I am developing in VB.NET using VS 2005 and am using Stylus Studio 2008 Enterprise to build an interface between EDIFACT messages and SQL 2005 database.

Using SS I can convert EDIFACT to an XML format suitable. This requires two steps - one is the EDI Converter, the second an XQUERY to produce a simplified XML structure that we can use.

Ultimately, I need to automate this. I need to poll / monitor for incoming EDIFACT files (which will be written to a designated folder) and run the SS Pipeline to convert either to XML files that I know I can process (or directly into the SQL DB).

I've tried the .NET API, but this seems to just run the converter, not the XQUERY (I think). I've downloaded Java SDK and tried compiling the Pipeline but get the following compile error:

Classpath:"w:\Development\EDI\";"c:\XTND\ProgramFiles\Stylus Studio 2008 XML Enterprise Suite\Components\XML Converters for Java\lib\XMLConverters.jar";"c:\XTND\ProgramFiles\Stylus Studio 2008 XML Enterprise Suite\Components\DataDirect XQuery\lib\ddxq.jar";"c:\XTND\ProgramFiles\Stylus Studio 2008 XML Enterprise Suite\Components\XML Converters for Java\lib\codehaus\wstx-asl.jar";"W:\Clients\Victoria Group\EDI\EDI2Manifest";"C:\XTND\ProgramFiles\Stylus Studio 2008 XML Enterprise Suite\bin\saxonsa.jar"
Exception in thread "Thread-22" java.lang.NoClassDefFoundError: com/sun/tools/javac/Main

Can I call the Pipeline (or at least call the Converter & then the XQUERY) through VB.NET? Or am I better off trying to resolve the issues compiling the Pipeline & just run that as an automated 'black box' task and then just handle the converted XML files in my program?

Any advice would be gratefully received. I have spend some hours reading the forums, but can find anything to fully resolve this for me.

Many thanks

(Deleted User) Subject: Automation using Visual Studio
Author: (Deleted User)
Date: 26 Mar 2008 12:07 PM
Hi Jon,
I think that the compilation step for the Java code is failing because you don't have chosen a valid JDK installation in the Tools | Options | Java Virtual Machine dialog.

Hope this helps,

Jon RobertsSubject: Automation using Visual Studio
Author: Jon Roberts
Date: 26 Mar 2008 12:15 PM
Hi Alberto,

Many thanks - that's fixed it. However, it has generated a secondary question.

I can now compile the XQUERY and the Pipeline, but now get the message "The evaluation period for DataDirect XQuery has expired. Please contact DataDirect Technologies to purchase a valid license."

Does the stylus studio license not cover compilation & automation? Do I need an additional license for this?


(Deleted User) Subject: Automation using Visual Studio
Author: (Deleted User)
Date: 26 Mar 2008 12:27 PM
Hi Jon,
Stylus Studio includes a license for the DataDirect XQuery engine when used from inside the IDE; when you build Java code that invokes the DDXQ engine as a standalone (and deployable) application, you need a standalone license of DDXQ (see http://www.xquery.com/buy/ for pricing).
If you don't need the scalability, performance and database access that DDXQ provides, you can always pick a different XQuery processor in the pipeline scenario (e.g. Saxon-B) and re-generate the Java code.

Hope this helps,

Jon RobertsSubject: Automation using Visual Studio
Author: Jon Roberts
Date: 26 Mar 2008 12:53 PM
Hi Alberto,

Thanks - things are becoming clearer now (& significantly more expensive!). It looks like I'm going to need to buy some additional software, but I need to know what.

My project needs the EDIFACT to XML conversion, which I think means I need the DataDirect XML convertor.

I use the XML generated by the convertor and run it through an XQUERY to simplify it. I then plan to write the resulting simplied XML data into a MS SQL DB.

Does that mean I also need to by the DataDirect XQUERY software or can I then use stylus studio's compiled Java (assuming I've bought the DataDirect convertor).

I'm keen to know what I really need. I will have a little egg on face going back for more budget (having been claiming what a result we'd had finding stylus studio) but can live with that - I don't want to do it twice though (i.e. buy the convertor now & find I need another bit later).

Can you help, please, and let me know what - realistically - I now need to purchase to make this work.


Jon RobertsSubject: Automation using Visual Studio
Author: Jon Roberts
Date: 27 Mar 2008 05:44 AM
Hi Ivan,

Thanks, but I'm in the UK & it's product info I need, not license info and I'd just prefer to clarify this with a 'techie' first, before getting into discussions with a sales guy (forgive my cynicism, but I've fallen over on that one before!).

Is this correct:

To automate the reading of Edifact files and convert them to XML, I need DataDirect XML Converter. This will allow me to do this in VB.NET using VS 2005.

To automate the running of an XQUERY on the the resulting XML, I can use Saxon and use the Java compiled from Stylus Studio, but this means running two (fairly) separate processes.

I would prefer to run the XQUERY in my VB.NET program (directly after running the converter). Can I do this & if so, do I need additional product for this?

Many thanks.

Ivan PedruzziSubject: Automation using Visual Studio
Author: Ivan Pedruzzi
Date: 27 Mar 2008 11:10 AM

In order to transform XML to XML I would rather use XSLT in your scenario, .NET has built-in support for XSLT, see XslCompiledTransform.

You could also consider Saxonica Saxon XQuery for .NET as well.


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.