3 Replies Latest reply on May 11, 2017 9:28 PM by polinao RSS
    dsenniappan Explorer

    MSSQL Extension package error

    Hi , Cant get enough on the following error, Any help please !


    The extension  'MSSQL_ExtensionPackage'  version [1.0] must match the "major.minor.patch" pattern containing only integer values. Assuming a zero value for patch number. Please fix this in the metadata.xml file of the extension.


    ThingWorx version : 7.1.2

    Relation database connector from Market place .

    MSSQL 2012


    Thanks in advance !

      • Re: MSSQL Extension package error
        polinao Ninja

        From the marketplace page,


        ThingWorx 6.5.0, 6.6.2


        This item has been tested and certified by ThingWorx to successfully work with the ThingWorx platform, however this item is not currently supported by ThingWorx. By utilizing this item you acknowledge that the content is provided in ‘as-is’ condition and support will not be provided.



        Alternatively to using that extension, you may

        1) Look into this thread for the Correct answer post on how to set up jdbc driver: Using a third party Jar file for Database connection

        2). Set up Thingworx 7.4 MSSQL version

          • Re: MSSQL Extension package error
            dsenniappan Explorer

            Hi , I get the same error when i import the extension i created ( 'SQLServerExtenstion'  version [1.0] must match the "major.minor.patch" pattern containing only integer value) . My metadata looks like below, (Structure lib/common/sqljdbc42.jar)




            <ExtensionPackage name="SQLServerExtenstion" description="MSSQL JDBC Extension" vendor="Created by Dinesh" packageVersion="1.0" minimumThingWorxVersion="5.0.0">


            <FileResource type="JAR" file="sqljdbc42.jar" description="MSSQL JDBC JAR"/>





            <ThingTemplate name="DBConnection" baseThingTemplate="Database" description="Database ThingTemplate"/>




            FYI - My isConnection is True and lastConnection is current time