XSLT 3.0 Streaming and SQL Extension

[random1980]

I am trying to get to work Saxon-EE 9.8.0.12 with XSLT 3.0 streaming enabled as well as the Saxon SQL extension. I'm using it with the Oxygen XML Developer IDE.

In the transformation scenario settings, I have activated Enabled streaming mode.

For the SQL extension, I have activated Use a configuration file. My config file looks like this:

Code: Select all

<configuration xmlns="http://saxon.sf.net/ns/configuration" edition="EE">
  <global allowExternalFunctions="true" versionOfXml="1.0"/>
  <global streamability="on"/>
   <xslt>
    <extensionElement namespace="http://saxon.sf.net/sql"
      factory="net.sf.saxon.option.sql.SQLElementFactory"/>
  </xslt>
</configuration>

However, as soon as I activate Use a configuration file, streaming stops working and it throws the following message:

The unnamed mode is streamable, but the input is not supplied as a stream. Edit the transformation scenario and select the option "Enable streaming mode" in the configuration of the Saxon transformer engine.

Can this problem be resolved? Thanks for your help.

[random1980]

@Admin: Could you please fix my post's title and change it to "... and SQL Extension".
Thanks!

[random1980]

Hello,
Maybe the problem is not the SQL Extension at all.

I ran an experiment and noticed that even if I provide an empty config file, I keep getting the error message:

Engine name: Saxon-EE 9.8.0.12
Severity: error
Description: The unnamed mode is streamable, but the input is not supplied as a stream. Edit the transformation scenario and select the option "Enable streaming mode" in the configuration of the Saxon transformer engine.

My config file contained nothing but:

Code: Select all

<configuration xmlns="http://saxon.sf.net/ns/configuration" edition="EE">
</configuration>

Could it be that I need to provide the name of a Saxon license file in the configuration element? As stated in my initial posting, I am using Saxon as part of Oxygen XML Developer.

I would be thankful for any advice on how to proceed to solve the issue.

[tavy]

Hello,

You don't need a Saxon EE licence if you are transforming from Oxygen. It seems that there is a problem when you set the stremming mode from the configuration file.If you enable the stremming mode from the Saxon configuration dialog options, by checking "Enable streaming mode", and you uncheck the "Use a configuration file" option, the stremming mode works.
I added an issue to analyze this problem. We will update this thread when we will find a solution.

Also , the configuration file is not valid, should be something like this:

Code: Select all

<configuration xmlns="http://saxon.sf.net/ns/configuration" edition="EE">
  <global allowExternalFunctions="true" versionOfXml="1.0" streamability="standard"/>
   <xslt>
    <extensionElement namespace="http://saxon.sf.net/sql"
      factory="net.sf.saxon.option.sql.SQLElementFactory"/>
  </xslt>
</configuration>

I tested with <oXygen/> XML Developer 21.1, build 2019090904.

Best Regards,
Octavian

[random1980]

Hello,

Thanks for getting back.

This is exactly my observation.

Yes, please keep me updated in this thread. Thanks for your help.

[sorin_carbunaru]

Hello,

Just wanted to update this thread and let you know that in the recently released oXygen 22 the Saxon streaming mode now properly works when set from the configuration file.

Best wishes,
Sorin Carbunaru
oXygen XML