Mailing-List: contact connectors-commits-help@incubator.apache.org;
 run by ezmlm
Precedence: bulk
Reply-To: connectors-dev@incubator.apache.org
Date: Wed, 13 Oct 2010 13:08:00 -0400 (EDT)
From: confluence@apache.org
To: connectors-commits@incubator.apache.org
Message-ID: <31064729.175.1286989680034.JavaMail.confluence@thor>
Subject: [CONF] Apache Connectors Framework > How to Write an Output
 Connector
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Auto-Submitted: auto-generated

Space: Apache Connectors Framework (https://cwiki.apache.org/confluence/display/CONNECTORS)
Page: How to Write an Output Connector (https://cwiki.apache.org/confluence/display/CONNECTORS/How+to+Write+an+Output+Connector)
Comment: https://cwiki.apache.org/confluence/display/CONNECTORS/How+to+Write+an+Output+Connector?focusedCommentId=24182874#comment-24182874

Comment added by Karl Wright:
---------------------------------------------------------------------

The best answer I can give right at the moment&nbsp;is to look at what the web connector does for tables.&nbsp; You will find that it creates two of them.&nbsp; Follow the same conventions and you should be OK.&nbsp; Naming is up to you, but obviously a good practice is to use a prefix that is likely to keep your table name from colliding with other tables from other connectors, or from future versions of the framework.&nbsp; If or when there is&nbsp;a ManifoldCF book, be assured that this topic will be covered in depth.\\

In reply to a comment by Farzad:
I'd like to create an output connector where I can detect duplicate files (documents) in the repository.  My thought is to store a hashsum value for each document, SHA-512, and store that in a table and set it as a primary key.  Subsequent insert with the same value would be rejected indicating a duplicate.

I read connectors are allowed to have their own tables.  What would the table name be?  I issue SQL over JDBC to modify table data?  How do you establish a connection to the db?  Any other thoughts about my approach?

Thanks!


Change your notification preferences: https://cwiki.apache.org/confluence/users/viewnotifications.action