Skip to main content
jwomack1-Visitor
1-Visitor
June 17, 2016
Solved

Unable to import MySQL JDBC connector extension

  • June 17, 2016
  • 6 replies
  • 4011 views

I've created and downloaded a MySQL extension using the JDBC Connector extension created recently obtained from the Marketplace. When importing I get the following error:

Error importing: error: Not Acceptable - [package: mysql-connector-javaJDBC, error: \ThingworxStorage\extensions\mysql-connector-javaJDBC_f1afc6ef-78d3-49c1-ac06-db848f48d213\mysql-connector-javaJDBC\metadata.xml (The system cannot find the file specified)]

Indeed, I looked in the zip file and did not see a metadata.xml file. Should it have been created when I uploaded the file with the JdbcCreator?

Best answer by mpatel-21

James ,

Use this extension from "http://marketplace.thingworx.com/Items/Relational-databases-connectors "

And Follow the steps for install extension in Thingwork from http://marketplace.thingworx.com/-/media/Marketplace/Download%20Item/Related%20Content/Relational-Databases-Connectors-E…  pdf file.

Thanks,

Mayank

6 replies

mpatel-211-VisitorAnswer
1-Visitor
June 17, 2016

James ,

Use this extension from "http://marketplace.thingworx.com/Items/Relational-databases-connectors "

And Follow the steps for install extension in Thingwork from http://marketplace.thingworx.com/-/media/Marketplace/Download%20Item/Related%20Content/Relational-Databases-Connectors-E…  pdf file.

Thanks,

Mayank

jwomack1-VisitorAuthor
1-Visitor
June 17, 2016

I was able to use the MySQLServer thing template from the Relational-databases-connectors to create a database thing. Thanks!

Aanjan5-Regular Member
5-Regular Member
June 17, 2016

James, adding to Mayank's comment - we have a JDBC connector extension too, if you have the .jar file for your jdbc connector, you can use this extension to create an extension of your own.

jwomack1-VisitorAuthor
1-Visitor
June 17, 2016

Aanjan, I downloaded the JDBC connector extension from the Marketplace and obtained a JDBC Driver file from dev.mysql.com/downloads/connector/j/. I followed the five bullets provided in the JDBC Connector instructions. On bullet number four was where I got the error as described in my initial post.

Aanjan5-Regular Member
5-Regular Member
June 17, 2016

Sorry, I misread your post. The connector extension you downloaded met your system requirements, correct? If it did meet the minimum required version, and did not create an extension (with the metadata and jar you provided), I'll take a look at the extensions functionality.

Terms & ConditionsAccessibility statement