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 (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2017)
-> + Issue with Processing Instruct... (2)
-> + problem converting json to XML... (2)
-> + Problem base64 decoding string... (3)
-> + Problems posting multipart for... (5)
-> + trouble with download of price... (2)
-> + Problem with http-post not bei... (3)
-> + path problem, xps_file:writeAl... (9)
-> + Xquery update support? (2)
-> + problem with Stylus studio try... (5)
-> + adding dtd reference to xml ou... (4)
-> + xquery escaping ambarsand when... (3)
-> + Whitespace problem when return... (5)
-> + Problem with namespace prefix ... (5)
-> - Sending via SFTP returns unexp... (1)
-> + Query and Sftp clent (4)
-> + xquery and try - catch (3)
-> + Query + ddtek:http-post optio... (5)
-> + Example files referenced in do... (3)
-> + Automatic Error Detection and ... (3)
-> + Working with result of ddtek:h... (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Posttop
Bruce CantorSubject: Sending via SFTP returns unexpected exception
Author: Bruce Cantor
Date: 31 Aug 2021 01:19 PM
Hi

At my company we would like to exchange information about delivery via sftp as a logfile that can be read by our ERP system.
That way the user will be able to see whether an file has been delivered with success or not.

I therefore thought I would create a xquery script that should write a log file with the result of the transmission in XML format.

The log file is created successfully when the transmission goes well. However it is not possible for me to get it write the log file if anything fails.
The method (ddtekjava:com.ivitechnologies.pipeline.ext.net.SFTP.sendString) unexpectedly throws an exception instead of the expected boolean.

I did a test script, attached to this entry, if I change the login so that the credentials are wrong the script fails with:

[DataDirect][XQuery]Error at line 17, column 27. Error in call to extension function "public static boolean com.ivitechnologies.pipeline.ext.net.SFTP.sendString(org.w3c.dom.Element,java.lang.String,java.lang.String) throws java.lang.Throwable": Exception in extension function "com.jcraft.jsch.JSchException: Auth fail"

Making it impossible to create the failed transmission in a log file.

Is it possible to make a script that handles any errors and at least logs that something went wrong, even better what went wrong?

Kind regards
Bruce


UnknownLogTest.zip
Project zipped

   
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.