XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » err:FODC0004
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + JVM detection not finding JDK ... (2)
-> - stylus studio version 2011 pro... (1)
-> - WSDL 2.0 (1)
-> + Special characters in xml (2)
-> + cannot connect to mysql commun... (2)
-> + create a report from an existi... (2)
-> + Content not allowed in prolog (2)
-> + DB IInformix with database loc... (8)
-> + Stylus Report Designer (XML Re... (4)
-> - error: cos-nonambig: Content m... (1)
-> - UNIX .csv conversion and java ... (1)
-> + Nillable element, Validation e... (2)
-> + EDI Converter Error (2)
-> - CSV FILE INTO CARGO-IMP MESSAG... (1)
-> + BUG: Validation in piple will ... (2)
-> + Is there a 64-Bit Stylus Studi... (2)
-> + BUG: Read structure on SQL Ser... (3)
-> + [Customer Toyoto Motors Europe... (2)
-> - Get a schema for a JSON file (1)
-> + UNOC:4 forces converter to inp... (2)
-> - java class for xs:any elements (1)
-> + changing component separator (3)
-> + Output view disappeared (6)
-> + How to convert deeply nested X... (2)
-> + javax.net.ssl.SSLException (4)
-> + error converting .csv in a uni... (10)
-> + Menu bar disappeared (3)
-> - No Topic (1)
-> - What does "XML" stand for? So... (1)
-> - So XML is just HTML on steroid... (1)
-> + XHTML to XML conversion (2)
-> - Stylus Studio with DDTek xml c... (1)
-> + Installation fails (3)
-> + Is there a keyboard shortcut t... (2)
-> - Bug: Adding a scenario to an X... (1)
-> - Bug: Bug reporting outputs an ... (1)
-> - Tradacoms Invoice 9 Batch Quer... (1)
-> - problem with the product regis... (1)
-> + Help: Documentation... ends in... (2)
-> + How to install LIBxml2 (2)
-> - line numbers in validator outp... (1)
-> + Sharing Viollation in Stylus v... (5)
-> - support for asp.net in stylus... (1)
-> + how to use the latest java xml... (2)
-> - how to show xsd element relate... (1)
-> - Testing Stylus in a secure env... (1)
-> + How do you remove linemarkings... (3)
-> - Bug: Comment / Uncomment via C... (1)
-> + Setting escape (release) chara... (2)
-> + Xalan processor not showing up (2)
-> + Is there a keyboard shortcut t... (3)
-> - Modifying reports outside of S... (1)
-> + Run ALL Scenarios? (2)
-> + predefined macros ${ (4)
-> - TRADACOMS - EDI (1)
-> + SUM not working (3)
-> - Large xml file handling gives ... (1)
-> + 2011 Enterprise code folding f... (9)
-> + custom xml converter (3)
-> - Start Excel feter the mapping ... (1)
-> + Uninstall (2)
-> + xpath to compare two values fr... (2)
-> - xpath to compare two values fr... (1)
-> + SS2011 cannot save XML files u... (3)
-> + SS 2011 Enterprise saying 2010... (2)
-> + How to change the way whitespa... (7)
-> + Updating Relational Data Using... (4)
-> - Contract Stylus Studio help. ... (1)
-> + UTF_8 characters not displayed (6)
-> + Problem XSL to PDF ( dont reco... (2)
-> + HIPAA EDI - Looping question (4)
-> - HIPAA EDI - Looping question (1)
-> + Does XML Report support column... (2)
-> + Limited choice of XSL elements... (2)
-> + Single Source Publishing? (3)
-> - Stylus Stodio License (1)
-> - Stylus Stodio License (1)
-> + relax ng (3)
-> + having problem converting csv ... (8)
-> + error when selecting items fro... (2)
-> + CSV File to XML (3)
-> + Software registration - How to... (4)
-> - Software registration - How to... (1)
-> + .Net Saxon not supported by th... (2)
-> + How do I extend the Evaluation... (2)
-> + dst file (4)
-> + Flat File Custom XML conversio... (4)
-> + converting ascii file to xml f... (2)
-> + Evaluation Copy of Stylus Stud... (8)
-> + Batch process for soap (4)
-> + Strange error when running gen... (5)
-> + Merge Files (2)
-> + Convert cvs to XML (2)
-> + Stylus studio 2010 crashes in ... (5)
-> + excel to text (2)
-> + licence key? (2)
-> + JVM Heap error (4)
-> + How Do I clean TXT File? (2)
-> + SS Web Service Call Tester Pay... (3)
-> - SS Web Service Call Tester Mic... (1)
-- Previous [421-440] [441-460] [461-480] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Michael NevinsSubject: err:FODC0004
Author: Michael Nevins
Date: 19 May 2010 07:51 AM
[DataDirect][XQuery][err:FODC0004]Error at line 1, column 50. Table "rslogix5000content" not found in any JDBC connection.

I have the database and tables show up in the file explorer but I cannot open the tables or run my XQuery's without the above error. Do I need a special JDBC driver besides the MySQL below.

C:\Program Files\Java\drivers\mysql-connector-java-5.1.5-bin.jar

Michael A. Nevins
Northrop Grumman
Electronic Systems
Postnext
Rory FarrellSubject: err:FODC0004
Author: Rory Farrell
Date: 19 May 2010 12:45 PM
Hi Michael,

You should be able to use the MySQL JDBC driver. In order to use the JDBC connection shown in the File Explorer you can switch to the "XQuery Source" tab and then click on the JDBC connection in the File Explorer and drag it to the right window pane (See attached screenshot).

This will store the JDBC connection information as metadata in the XQuery document. You should then be able to use XQuery to query and update the database.

See the URLs below for some video demonstrations that might be helpful.

http://www.datadirect.com/developer/data-integration/videos/xquery-relational-data/index.ssp

http://www.datadirect.com/developer/data-integration/videos/xquery-updates/index.ssp

Regards,
Rory


Imagemysql-jdbc.png
Postnext
Michael NevinsSubject: err:FODC0004
Author: Michael Nevins
Date: 19 May 2010 12:49 PM
I will look at it right away.

Thanks,


Michael A. Nevins
Northrop Grumman
Electronic Systems
Postnext
Michael NevinsSubject: err:FODC0004
Author: Michael Nevins
Date: 19 May 2010 12:57 PM
I attempted it as you describe with the same results. I am in a secure facility that does not allow for viewing videos on site. Any other options?

Thanks,

Michael A. Nevins
Northrop Grumman
Electronic Systems
Postnext
Minollo I.Subject: err:FODC0004
Author: Minollo I.
Date: 19 May 2010 01:15 PM
Any chance you can share with us the XQuery you are trying to run (or at least the collection() expression(s) you are using) so that we can get a better idea about the problem you are hitting?

Thanks.
Postnext
Michael NevinsSubject: err:FODC0004
Author: Michael Nevins
Date: 19 May 2010 01:24 PM
I can take out system names to make it unclassified but I don't think that is needed yet. I seem to be getting a good handle on the Xquery side of things(for a novice). It is actually the very first XQuery on the connection I try to make to the database that it fails. I see the tables and the column headers, but I connect execute the most basic query without that error.?

Thanks,

Michael A. Nevins
Northrop Grumman
Electronic Systems
Postnext
Minollo I.Subject: err:FODC0004
Author: Minollo I.
Date: 19 May 2010 01:33 PM
The error you are getting is from the runtime execution of the XQuery; the UI is clearly able to connect and get the information you need, but for some reason either the XQuery is not setup to be aware of which JDBC connections it should use, or it's referencing tables in the collection() functions in a way which MySQL doesn't "like".

Which is why I suggested providing details about the collection() expressions you are using. Also, in addition to seeing the database and table in the "File Explorer" view, are you also seeing the same information in the panel to the right of the XQuery source editor? If not, you do need to drag&drop the MySQL databaase connection (or the individual table you are trying to use) from File Explorer to that panel.
Postnext
Michael NevinsSubject: err:FODC0004
Author: Michael Nevins
Date: 19 May 2010 02:01 PM
Yes I did as you advised and brought over the MySQL DB to the viwer on the right side of the XQuery Tab view first. I attached a screen shot of XQuery Collectioin syntax.

Thanks,

Michael A. Nevins
Northrop Grumman
Electronic Systems


UnknownErrFODC0004.bmp
Screen shot
Postnext
Minollo I.Subject: err:FODC0004
Author: Minollo I.
Date: 19 May 2010 05:42 PM
What is the JDBC URL you are using to connect to your MySQL database?
Postnext
Michael NevinsSubject: err:FODC0004
Author: Michael Nevins
Date: 20 May 2010 06:35 AM
Server URL : //localhost:3306/GDC1?

File Explorer shows-> jdbc:mysql//localhost:3306/GDC1?

Michael A. Nevins
Northrop Grumman
Electronic Systems
Postnext
Minollo I.Subject: err:FODC0004
Author: Minollo I.
Date: 20 May 2010 09:56 AM
Strange; is the table you are referencing in the XQuery in the GDC1 database? Are you sure the database has been added to the set of XQuery sources? I tried to reproduce the problem with no luck; see attached image.


Imagemysql.png
Postnext
Michael NevinsSubject: err:FODC0004
Author: Michael Nevins
Date: 20 May 2010 11:15 AM
Yes and yes, is there some other setup I might have missed?

Michael A. Nevins
Northrop Grumman
Electronic Systems
Postnext
Minollo I.Subject: err:FODC0004
Author: Minollo I.
Date: 20 May 2010 11:20 AM
Not that I can think of. Can you try creating a new XQuery from scratch, drag&dropping the database in the right panel, drag&dropping a table from the right panel into the XQuery source and seeing if you get the same error?
Postnext
Minollo I.Subject: err:FODC0004
Author: Minollo I.
Date: 21 May 2010 08:52 AM
Something else to try; can you specify the database name as lower case in the JDBC URL, rather than upper case?

jdbc:mysql://localhost:3306/gdc1?
Postnext
Michael NevinsSubject: err:FODC0004
Author: Michael Nevins
Date: 21 May 2010 09:16 AM


I get the same thing on a new XQuery. The URL looks all lowercase to me. I do see that the source shows underscores you might have thought was a capitol :as "jdbc_mysql_localhost_3306"


Michael A. Nevins
Northrop Grumman
Electronic Systems
Postnext
Minollo I.Subject: err:FODC0004
Author: Minollo I.
Date: 21 May 2010 10:22 AM
I'm confused; didn't you write this a few posts ago?

Server URL : //localhost:3306/GDC1?
File Explorer shows-> jdbc:mysql//localhost:3306/GDC1?
Postnext
Michael NevinsSubject: err:FODC0004
Author: Michael Nevins
Date: 21 May 2010 10:28 AM
Oh! the "Database Name "GDC1""

Sorry, I will try that.

Michael A. Nevins
Northrop Grumman
Electronic Systems
Posttop
Michael NevinsSubject: err:FODC0004
Author: Michael Nevins
Date: 21 May 2010 10:34 AM
That Was It!

Thanks,

Michael A. Nevins
Northrop Grumman
Electronic Systems
   
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.