Subject: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.
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.
Subject: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?
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.
Subject: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.
Subject: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?