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
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
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"
Compiling...
EDI2Manifest.java
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
Jon

Postnext
(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,
Alberto

Postnext
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?

Regards
Jon

Postnext
(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,
Alberto

Postnext
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.

Thanks

Postnext
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.
Jon

Posttop
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.

Ivan

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
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.