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
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext 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

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
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.