Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X
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>
Solved! Go to Solution.
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.
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.