Advertisement
Guest User

Untitled

a guest
Sep 13th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. <dataConfig>
  2. <dataSource type="JdbcDataSource"
  3. driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
  4. url="jdbc:sqlserver://192.168.1.20\SQLEXPRESS:1433;databaseName=webscrape"
  5. user="kveer"
  6. password="kevin" />
  7.  
  8. <document name="tableAbstract">
  9. <entity name="[PubMedstg][tblAbstracts]" PK="id" query="SELECT txtTitle, lngAbstractID as id, memBody FROM [webscrape].[dbo].[PubMedstg.tblAbstracts]"
  10. deltaQuery="SELECT 1 AS did"
  11. 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)) &gt; DATEDIFF(SECOND,{d '1970-01-01'}, CAST(CONVERT(datetime,REPLACE('${dih.last_index_time}', '\', '')) AS TIMESTAMP))">
  12.  
  13.  
  14. </entity>
  15. </document>
  16.  
  17.  
  18.  
  19. </dataConfig>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement