I have a javacode that needs to be modified. the modification is below:
Please modify the logic so that when a link is not to HTML we capture the link into the “LL_URL_or_Frame_Name” and Legal language in Null remaining all columns are as usually captured. and write the row into the "tblOIWebCrawlerDetailsHTML" table.
for example:
for example : if the URL is : [login to view URL] Then privacy is : [login to view URL] its not a webpage.. for those type of links which are not webpage can be insert a row with all the details except Legal Language column is NULL and LL_URL_or_Frame_Name will the link as
[login to view URL]
Structure of the table:
[WebCrawlerDetailsHTML](
[AvenueID] [int] NULL,
[URL] [nvarchar](255) NULL,
[Keyword] [nvarchar](255) NULL,
[Date_Run] [nvarchar](10) NULL,
[Date_Effective] [nvarchar](10) NULL,
[LL_URL_or_Frame_Name] [nvarchar](255) NULL,
[Legal_Language_Text] [nvarchar](max) NULL,
[Blocked_By_Ford_Firewall] [bit] NULL,
[batch_Id] [int] NULL,
[Snippet] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
The java Code is uploaded