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)
-> - Stylus Studio - Registrar en o... (1)
-> + Stylus Studio - Registrar en o... (2)
-> + Can a pipeline send a file by ... (2)
-> + After Updateing WIN10 to WIN11... (12)
-> + Where do I add the custom java... (3)
-> + Where is the Diagram tab? (5)
-> + Applying XSLT to Word DOCX/XML (2)
-> - CSV conversion via ConvertToXM... (1)
-> + Text symbols in SS not same as... (4)
-> + Exposing xquery as webservice ... (6)
-> + Syntax Identifier (2)
-> + Saving a Converted XML as an X... (5)
-> + Output document cannot be pars... (4)
-> - Archiving output from conversi... (1)
-> + 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)
-- [1-20] [21-40] [41-60] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2016)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Paul HermansSubject: java error message when running a rdbxml sql/xml query
Author: Paul Hermans
Date: 15 Mar 2006 05:27 AM
Originally Posted: 15 Mar 2006 04:55 AM
I have a connection with an MS access database.<br> When I drag a table into the editor pane and paste it as a SQL/XML query and run the scenario without any modification to the code I get a java error of which the screendump is attached.<br> Doing the same with plain SQL runs fine. The auto generated code: <pre> SELECT XMLELEMENT(name "row", XMLELEMENT(name "volgnr",t.volgnr), XMLELEMENT(name "inventarisnr",t.inventarisnr), XMLELEMENT(name "bp_gemeente",t.bp_gemeente), XMLELEMENT(name "bp_deelgemeente",t.bp_deelgemeente), XMLELEMENT(name "bp_gebouw_type",t.bp_gebouw_type), XMLELEMENT(name "bp_algemeen",t.bp_algemeen), XMLELEMENT(name "bp_bijzonder",t.bp_bijzonder), XMLELEMENT(name "bp_tijdelijke",t.bp_tijdelijke), XMLELEMENT(name "eig_nr",t.eig_nr), XMLELEMENT(name "id_benaming",t.id_benaming), XMLELEMENT(name "id_onderwerp",t.id_onderwerp), XMLELEMENT(name "mb_beschrijving",t.mb_beschrijving), XMLELEMENT(name "mb_materiaal",t.mb_materiaal), XMLELEMENT(name "mb_afmeting_h",t.mb_afmeting_h), XMLELEMENT(name "mb_afmeting_b",t.mb_afmeting_b), XMLELEMENT(name "mb_afmeting_l",t.mb_afmeting_l), XMLELEMENT(name "mb_afmeting_o",t.mb_afmeting_o), XMLELEMENT(name "mb_aantal_blz",t.mb_aantal_blz), XMLELEMENT(name "mb_toestand",t.mb_toestand), XMLELEMENT(name "mb_toestand_volledig",t.mb_toestand_volledig), XMLELEMENT(name "mb_toestand_deel",t.mb_toestand_deel), XMLELEMENT(name "ico_benaming",t.ico_benaming), XMLELEMENT(name "ico_opschrift_wapenschild",t.ico_opschrift_wapenschild), XMLELEMENT(name "ico_signatuur_datering",t.ico_signatuur_datering), XMLELEMENT(name "ico_merktekens",t.ico_merktekens), XMLELEMENT(name "ap_produktiecentrum_algemeen",t.ap_produktiecentrum_algemeen), XMLELEMENT(name "ap_produktiecentrum_specifiek",t.ap_produktiecentrum_specifiek), XMLELEMENT(name "ap_auteur_naam",t.ap_auteur_naam), XMLELEMENT(name "dat_periode_begin",t.dat_periode_begin), XMLELEMENT(name "dat_periode_einde",t.dat_periode_einde), XMLELEMENT(name "dat_stijl",t.dat_stijl), XMLELEMENT(name "erf_bescherming",t.erf_bescherming), XMLELEMENT(name "erf_aard_bescherming",t.erf_aard_bescherming), XMLELEMENT(name "erf_publiek_toegankelijk",t.erf_publiek_toegankelijk), XMLELEMENT(name "erf_gebruik",t.erf_gebruik), XMLELEMENT(name "her_herkomst",t.her_herkomst), XMLELEMENT(name "inf_nr",t.inf_nr), XMLELEMENT(name "a_waarde",t.a_waarde), XMLELEMENT(name "a_verzekering_datum",t.a_verzekering_datum), XMLELEMENT(name "a_verzekering_naam",t.a_verzekering_naam), XMLELEMENT(name "a_verzekering_polis",t.a_verzekering_polis), XMLELEMENT(name "a_verzekering_waarde",t.a_verzekering_waarde), XMLELEMENT(name "a_datum_aard_verwerving",t.a_datum_aard_verwerving), XMLELEMENT(name "v_veiligheid",t.v_veiligheid), XMLELEMENT(name "vv_vrij_veld",t.vv_vrij_veld), XMLELEMENT(name "a_wapenschild",t.a_wapenschild), XMLELEMENT(name "naam_gebruiker",t.naam_gebruiker), XMLELEMENT(name "a_foto_1",t.a_foto_1), XMLELEMENT(name "a_foto_2",t.a_foto_2), XMLELEMENT(name "a_foto_3",t.a_foto_3), XMLELEMENT(name "a_foto_4",t.a_foto_4), XMLELEMENT(name "a_foto_5",t.a_foto_5), XMLELEMENT(name "a_foto_6",t.a_foto_6), XMLELEMENT(name "opsteller_inventaris",t.opsteller_inventaris), XMLELEMENT(name "laatste_wijziging",t.laatste_wijziging) ) FROM C:\Temp\Access\licobecu.Fiches t </pre>


Imageerror.png
java error

Postnext
Ivan PedruzziSubject: java error message when running a rdbxml sql/xml query
Author: Ivan Pedruzzi
Date: 15 Mar 2006 11:51 AM
Hi Paul

Could you try replacing

FROM C:\Temp\Access\licobecu.Fiches t

with

FROM Fiches t


Thank You
Ivan Pedruzzi
Stylus Studio Team

Posttop
Paul HermansSubject: java error message when running a rdbxml sql/xml query
Author: Paul Hermans
Date: 15 Mar 2006 01:45 PM
Hi, Yvan,


This does it.

Many thanks.

   
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.