|
代码示例:
<dataConfig>
<dataSource type="JdbcDataSource"
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost;databaseName=AdventureWorks2014"
user="sa"
password="sa"/>
<document>
<entity name="address"
pk="id"
query="SELECT [AddressID],[AddressLine1],[ModifiedDate] FROM [AdventureWorks2014].[Person].[Address]"
deltaImportQuery="SELECT -1 as deltaImportQuery,[AddressID],[AddressLine1],[ModifiedDate] FROM [AdventureWorks2014].[Person].[Address] WHERE ModifiedDate > '${dih.address.last_index_time}'"
deltaQuery="SELECT -1 as>
deletedPkQuery="SELECT [AddressID] as> >
<field column="AddressID" name="id"/>
<field column="AddressLine1" name="title"/>
<field column="ModifiedDate" name="postdatetime"/>
</entity>
</document>
</dataConfig> |
|
|