You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@manifoldcf.apache.org by Ro...@cognizant.com on 2010/06/04 07:57:15 UTC
Database Connector JOB
Hi,
I am setting up the Database connector Job. In the queries.
SELECT idfield AS $(IDCOLUMN) FROM documenttable WHERE modifydatefield >
$(STARTTIME) AND modifydatefield <= $(ENDTIME)
My document Id field is "DID"
Document Table is "Revisions"
Modifydatefeild is "DINDATE"
I am unable to figure out the substitutions. Should I substitute in
idfield or $(IDCOLUMN)
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com <ma...@cognizant.com>
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.
RE: Database Connector JOB
Posted by ka...@nokia.com.
I should also point out that you can remove all references to $(STARTTIME) and $(ENDTIME) and your job will still function properly. The contract is that you must simply return the records added or modified between those times, but there's no reason you can't return more (other than performance).
Karl
From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 8:32 AM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
In the query I saw there was a '?' substituted instead of $(STARTDATE) and was throwing errors ... I removed it completely.. So I asked this question.
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com<ma...@cognizant.com>
From: karl.wright@nokia.com [mailto:karl.wright@nokia.com]
Sent: Friday, June 04, 2010 5:32 PM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
Milliseconds since epoch implicitly includes the date as well as the time. So I really don't understand your question?
Karl
From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 8:00 AM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
Thanks figured it out.. Should we specify the startdate ?
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com<ma...@cognizant.com>
From: karl.wright@nokia.com [mailto:karl.wright@nokia.com]
Sent: Friday, June 04, 2010 5:18 PM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
$(IDCOLUMN) is the name of the column the connector wants to see in the resultset. So your query would be:
SELECT DID AS $(IDCOLUMN) FROM Revisions WHERE DINDATE > $(STARTTIME) AND DINDATE <= $(ENDTIME)
Bear in mind that if your DINDATE column is not in milliseconds since epoch, you will need to modify the above query to code for date conversion.
Thanks,
Karl
From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 1:57 AM
To: connectors-user@incubator.apache.org
Subject: Database Connector JOB
Hi,
I am setting up the Database connector Job. In the queries.
SELECT idfield AS $(IDCOLUMN) FROM documenttable WHERE modifydatefield > $(STARTTIME) AND modifydatefield <= $(ENDTIME)
My document Id field is "DID"
Document Table is "Revisions"
Modifydatefeild is "DINDATE"
I am unable to figure out the substitutions. Should I substitute in idfield or $(IDCOLUMN)
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com<ma...@cognizant.com>
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.
RE: Database Connector JOB
Posted by ka...@nokia.com.
The ? you see is the standard placeholder for a parameterized query. The $(STARTDATE) will be substituted by a ?, but there will be a corresponding parameter included when the query is actually submitted to JDBC.
What was the error you saw?
Karl
From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 8:32 AM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
In the query I saw there was a '?' substituted instead of $(STARTDATE) and was throwing errors ... I removed it completely.. So I asked this question.
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com<ma...@cognizant.com>
From: karl.wright@nokia.com [mailto:karl.wright@nokia.com]
Sent: Friday, June 04, 2010 5:32 PM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
Milliseconds since epoch implicitly includes the date as well as the time. So I really don't understand your question?
Karl
From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 8:00 AM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
Thanks figured it out.. Should we specify the startdate ?
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com<ma...@cognizant.com>
From: karl.wright@nokia.com [mailto:karl.wright@nokia.com]
Sent: Friday, June 04, 2010 5:18 PM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
$(IDCOLUMN) is the name of the column the connector wants to see in the resultset. So your query would be:
SELECT DID AS $(IDCOLUMN) FROM Revisions WHERE DINDATE > $(STARTTIME) AND DINDATE <= $(ENDTIME)
Bear in mind that if your DINDATE column is not in milliseconds since epoch, you will need to modify the above query to code for date conversion.
Thanks,
Karl
From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 1:57 AM
To: connectors-user@incubator.apache.org
Subject: Database Connector JOB
Hi,
I am setting up the Database connector Job. In the queries.
SELECT idfield AS $(IDCOLUMN) FROM documenttable WHERE modifydatefield > $(STARTTIME) AND modifydatefield <= $(ENDTIME)
My document Id field is "DID"
Document Table is "Revisions"
Modifydatefeild is "DINDATE"
I am unable to figure out the substitutions. Should I substitute in idfield or $(IDCOLUMN)
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com<ma...@cognizant.com>
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.
RE: Database Connector JOB
Posted by Ro...@cognizant.com.
In the query I saw there was a '?' substituted instead of $(STARTDATE)
and was throwing errors ... I removed it completely.. So I asked this
question.
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com
From: karl.wright@nokia.com [mailto:karl.wright@nokia.com]
Sent: Friday, June 04, 2010 5:32 PM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
Milliseconds since epoch implicitly includes the date as well as the
time. So I really don't understand your question?
Karl
From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 8:00 AM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
Thanks figured it out.. Should we specify the startdate ?
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com
From: karl.wright@nokia.com [mailto:karl.wright@nokia.com]
Sent: Friday, June 04, 2010 5:18 PM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
$(IDCOLUMN) is the name of the column the connector wants to see in the
resultset. So your query would be:
SELECT DID AS $(IDCOLUMN) FROM Revisions WHERE DINDATE > $(STARTTIME)
AND DINDATE <= $(ENDTIME)
Bear in mind that if your DINDATE column is not in milliseconds since
epoch, you will need to modify the above query to code for date
conversion.
Thanks,
Karl
From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 1:57 AM
To: connectors-user@incubator.apache.org
Subject: Database Connector JOB
Hi,
I am setting up the Database connector Job. In the queries.
SELECT idfield AS $(IDCOLUMN) FROM documenttable WHERE modifydatefield >
$(STARTTIME) AND modifydatefield <= $(ENDTIME)
My document Id field is "DID"
Document Table is "Revisions"
Modifydatefeild is "DINDATE"
I am unable to figure out the substitutions. Should I substitute in
idfield or $(IDCOLUMN)
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on
this
e-mail is strictly prohibited and may be unlawful.
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on
this
e-mail is strictly prohibited and may be unlawful.
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.
RE: Database Connector JOB
Posted by ka...@nokia.com.
Milliseconds since epoch implicitly includes the date as well as the time. So I really don't understand your question?
Karl
From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 8:00 AM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
Thanks figured it out.. Should we specify the startdate ?
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com<ma...@cognizant.com>
From: karl.wright@nokia.com [mailto:karl.wright@nokia.com]
Sent: Friday, June 04, 2010 5:18 PM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
$(IDCOLUMN) is the name of the column the connector wants to see in the resultset. So your query would be:
SELECT DID AS $(IDCOLUMN) FROM Revisions WHERE DINDATE > $(STARTTIME) AND DINDATE <= $(ENDTIME)
Bear in mind that if your DINDATE column is not in milliseconds since epoch, you will need to modify the above query to code for date conversion.
Thanks,
Karl
From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 1:57 AM
To: connectors-user@incubator.apache.org
Subject: Database Connector JOB
Hi,
I am setting up the Database connector Job. In the queries.
SELECT idfield AS $(IDCOLUMN) FROM documenttable WHERE modifydatefield > $(STARTTIME) AND modifydatefield <= $(ENDTIME)
My document Id field is "DID"
Document Table is "Revisions"
Modifydatefeild is "DINDATE"
I am unable to figure out the substitutions. Should I substitute in idfield or $(IDCOLUMN)
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com<ma...@cognizant.com>
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.
RE: Database Connector JOB
Posted by Ro...@cognizant.com.
Thanks figured it out.. Should we specify the startdate ?
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com
From: karl.wright@nokia.com [mailto:karl.wright@nokia.com]
Sent: Friday, June 04, 2010 5:18 PM
To: connectors-user@incubator.apache.org
Subject: RE: Database Connector JOB
$(IDCOLUMN) is the name of the column the connector wants to see in the
resultset. So your query would be:
SELECT DID AS $(IDCOLUMN) FROM Revisions WHERE DINDATE > $(STARTTIME)
AND DINDATE <= $(ENDTIME)
Bear in mind that if your DINDATE column is not in milliseconds since
epoch, you will need to modify the above query to code for date
conversion.
Thanks,
Karl
From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 1:57 AM
To: connectors-user@incubator.apache.org
Subject: Database Connector JOB
Hi,
I am setting up the Database connector Job. In the queries.
SELECT idfield AS $(IDCOLUMN) FROM documenttable WHERE modifydatefield >
$(STARTTIME) AND modifydatefield <= $(ENDTIME)
My document Id field is "DID"
Document Table is "Revisions"
Modifydatefeild is "DINDATE"
I am unable to figure out the substitutions. Should I substitute in
idfield or $(IDCOLUMN)
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on
this
e-mail is strictly prohibited and may be unlawful.
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.
RE: Database Connector JOB
Posted by ka...@nokia.com.
$(IDCOLUMN) is the name of the column the connector wants to see in the resultset. So your query would be:
SELECT DID AS $(IDCOLUMN) FROM Revisions WHERE DINDATE > $(STARTTIME) AND DINDATE <= $(ENDTIME)
Bear in mind that if your DINDATE column is not in milliseconds since epoch, you will need to modify the above query to code for date conversion.
Thanks,
Karl
From: ext Rohan.GPatil@cognizant.com [mailto:Rohan.GPatil@cognizant.com]
Sent: Friday, June 04, 2010 1:57 AM
To: connectors-user@incubator.apache.org
Subject: Database Connector JOB
Hi,
I am setting up the Database connector Job. In the queries.
SELECT idfield AS $(IDCOLUMN) FROM documenttable WHERE modifydatefield > $(STARTTIME) AND modifydatefield <= $(ENDTIME)
My document Id field is "DID"
Document Table is "Revisions"
Modifydatefeild is "DINDATE"
I am unable to figure out the substitutions. Should I substitute in idfield or $(IDCOLUMN)
Thanks & Regards,
Rohan G Patil
Cognizant Programmer Analyst Trainee,Bangalore || Mob # +91 9535577001
Rohan.GPatil@cognizant.com<ma...@cognizant.com>
This e-mail and any files transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly prohibited and may be unlawful.