Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <dataConfig>
- <dataSource type="JdbcDataSource"
- driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
- url="jdbc:sqlserver://192.168.1.20\SQLEXPRESS:1433;databaseName=webscrape"
- user="kveer"
- password="kevin" />
- <document name="tableAbstract">
- <entity name="[PubMedstg][tblAbstracts]" PK="id" query="SELECT txtTitle, lngAbstractID as id, memBody FROM [webscrape].[dbo].[PubMedstg.tblAbstracts]"
- deltaQuery="SELECT 1 AS did"
- deltaImportQuery="SELECT txtTitle, lngAbstractID as id, memBody FROM [webscrape].[dbo].[PubMedstg.tblAbstracts] WHERE DATEDIFF(SECOND,{d '1970-01-01'}, CAST(CONVERT(datetime,[DateLoaded]) AS TIMESTAMP)) > DATEDIFF(SECOND,{d '1970-01-01'}, CAST(CONVERT(datetime,REPLACE('${dih.last_index_time}', '\', '')) AS TIMESTAMP))">
- </entity>
- </document>
- </dataConfig>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement