cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

Error when I create database extension

旭王1
1-Newbie

Error when I create database extension

I was wondering how to create metadata.xml when I created the database extension. How to create the following through the eclipse xml file. Xml file is through what kind of process to get. I have Oracle11 to expand the package, I would like to create a mysql extension package based on it myself I do not know what to do?

<Entities>

    <ExtensionPackages>

        <ExtensionPackage name="MYSQL_ExtensionPackage"

                      description="My SQL JDBC Extension"

                      vendor="ThingWorx Customer Service"

                      packageVersion="1.0"

                      minimumThingWorxVersion="4.0.0">

            <JarResources>

                <FileResource type="JAR" file="mysql-connector-java-5.1.22.jar" description="MySQL JDBC JAR" />

            </JarResources>

        </ExtensionPackage>

    </ExtensionPackages>

    <ThingTemplates>

        <ThingTemplate baseThingTemplate="Database" description="MySQL Server" documentationContent="" effectiveThingPackage="" homeMashup="" lastModifiedDate="2015-11-28T11:40:35.355-05:00" name="MySqlServer" tags="" thingPackage="">

            <ThingShape description="" documentationContent="" lastModifiedDate="2015-11-28T11:40:35.355-05:00" name="" tags="">

                <PropertyDefinitions/>

                <ServiceDefinitions/>

                <EventDefinitions/>

                <ServiceImplementations/>

                <ServiceMappings/>

                <Subscriptions/>

            </ThingShape>

            <ImplementedShapes/>

            <ConfigurationTables>

                <ConfigurationTable description="" isMultiRow="false" name="ConnectionInfo">

                    <DataShape>

                        <FieldDefinitions>

                            <FieldDefinition aspect.defaultValue="5.0" baseType="NUMBER" description="Maximum number of connections in the pool" name="maxConnections" ordinal="0"/>

                            <FieldDefinition aspect.defaultValue="jdbc" baseType="STRING" description="jDBCConnectionURL" name="jDBCConnectionURL" ordinal="0"/>

                            <FieldDefinition aspect.defaultValue="SELECT NOW()" baseType="STRING" description="Connection validation string" name="connectionValidationString" ordinal="0"/>

                            <FieldDefinition aspect.defaultValue="com.yourdatabase.yourDriver" baseType="STRING" description="jDBCDriverClass" name="jDBCDriverClass" ordinal="0"/>

                            <FieldDefinition baseType="STRING" description="Database user name" name="userName" ordinal="0"/>

                            <FieldDefinition baseType="PASSWORD" description="Database password" name="password" ordinal="0"/>

                        </FieldDefinitions>

                    </DataShape>

                    <Rows>

                        <Row>

                            <jDBCConnectionURL><![CDATA[jdbc:mysql://localhost:3306/demo]]></jDBCConnectionURL>

                            <maxConnections>100.0</maxConnections>

                            <connectionValidationString><![CDATA[SELECT NOW()]]></connectionValidationString>

                            <jDBCDriverClass><![CDATA[com.mysql.jdbc.Driver]]></jDBCDriverClass>

                            <userName />

                            <password />

                        </Row>

                    </Rows>

                </ConfigurationTable>

                <ConfigurationTable description="" isMultiRow="false" name="ConnectionMonitoring">

                    <DataShape>

                        <FieldDefinitions>

                            <FieldDefinition aspect.defaultValue="1.0" baseType="NUMBER" description="Number of retries" name="numberOfRetries" ordinal="0"/>

                            <FieldDefinition aspect.defaultValue="2000.0" baseType="NUMBER" description="Retry delay in milliseconds" name="retryDelay" ordinal="0"/>

                            <FieldDefinition aspect.defaultValue="false" baseType="BOOLEAN" description="Enable connection monitoring" name="enableMonitor" ordinal="0"/>

                            <FieldDefinition aspect.defaultValue="30000.0" baseType="NUMBER" description="Monitor rate in milliseconds" name="connectionMonitorRate" ordinal="0"/>

                        </FieldDefinitions>

                    </DataShape>

                    <Rows>

                        <Row>

                            <numberOfRetries>1.0</numberOfRetries>

                            <retryDelay>2000.0</retryDelay>

                            <enableMonitor>false</enableMonitor>

                            <connectionMonitorRate>3000.0</connectionMonitorRate>

                        </Row>

                    </Rows>

                </ConfigurationTable>

            </ConfigurationTables>

            <avatar/>

            <DesignTimePermissions>

                <Create/>

                <Read/>

                <Update/>

                <Delete/>

                <Metadata/>

            </DesignTimePermissions>

            <RunTimePermissions/>

            <InstanceDesignTimePermissions>

                <Create/>

                <Read/>

                <Update/>

                <Delete/>

                <Metadata/>

            </InstanceDesignTimePermissions>

            <InstanceRunTimePermissions/>

        </ThingTemplate>

    </ThingTemplates>

</Entities>

1 ACCEPTED SOLUTION

Accepted Solutions
ankigupta
5-Regular Member
(To:旭王1)

Hi

Is there any specific reason to use ecipse to create the extension. Database extensions can be simply created using the following extension available on the marketplace ThingWorx IoT Marketplace jdbc-connector-extension

And here are some already available relational Database extensions for download ThingWorx IoT Marketplace Relational-databases-connectors

I hope it helps.

View solution in original post

1 REPLY 1
ankigupta
5-Regular Member
(To:旭王1)

Hi

Is there any specific reason to use ecipse to create the extension. Database extensions can be simply created using the following extension available on the marketplace ThingWorx IoT Marketplace jdbc-connector-extension

And here are some already available relational Database extensions for download ThingWorx IoT Marketplace Relational-databases-connectors

I hope it helps.

Top Tags