You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@manifoldcf.apache.org by "Rohan G Patil (JIRA)" <ji...@apache.org> on 2010/06/10 14:36:14 UTC
[jira] Created: (CONNECTORS-44) Adding metadata support to JDBC
connector
Adding metadata support to JDBC connector
-----------------------------------------
Key: CONNECTORS-44
URL: https://issues.apache.org/jira/browse/CONNECTORS-44
Project: Lucene Connector Framework
Issue Type: Improvement
Components: JDBC connector
Environment: Windows, Oracle 10g, Oracle Universal Content Management System
Reporter: Rohan G Patil
Priority: Critical
The metadata for the documents checked in is stored in different fields of the Database. for example created date, Author,Title etc.
The BLOB object contains only the text of the document. It would be very helpful if we could add support select Metadata fields (Columns in the database ) while querying the table.
The above support would be helpful and make it a substitute for Oracle UCM (Stellent) Connector.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (CONNECTORS-44) Adding metadata support to JDBC
connector
Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CONNECTORS-44?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12877409#action_12877409 ]
Karl Wright commented on CONNECTORS-44:
---------------------------------------
I think this feature has merit in its own right. I'm a little leery about this becoming a Stellent connector, though, since:
(a) it's hardly end-user friendly for users to have to learn the Stellent schema;
(b) I'm sure Stellent has some kind of security, and this proposal would not address that.
> Adding metadata support to JDBC connector
> -----------------------------------------
>
> Key: CONNECTORS-44
> URL: https://issues.apache.org/jira/browse/CONNECTORS-44
> Project: Lucene Connector Framework
> Issue Type: Improvement
> Components: JDBC connector
> Environment: Windows, Oracle 10g, Oracle Universal Content Management System
> Reporter: Rohan G Patil
> Priority: Critical
> Original Estimate: 0.02h
> Remaining Estimate: 0.02h
>
> The metadata for the documents checked in is stored in different fields of the Database. for example created date, Author,Title etc.
> The BLOB object contains only the text of the document. It would be very helpful if we could add support select Metadata fields (Columns in the database ) while querying the table.
> The above support would be helpful and make it a substitute for Oracle UCM (Stellent) Connector.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (CONNECTORS-44) Adding metadata support to JDBC
connector
Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CONNECTORS-44?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Wright updated CONNECTORS-44:
----------------------------------
Original Estimate: 48h (was: 0.02h)
Remaining Estimate: 48h (was: 0.02h)
Assignee: Karl Wright
Priority: Major (was: Critical)
> Adding metadata support to JDBC connector
> -----------------------------------------
>
> Key: CONNECTORS-44
> URL: https://issues.apache.org/jira/browse/CONNECTORS-44
> Project: Lucene Connector Framework
> Issue Type: Improvement
> Components: JDBC connector
> Environment: Windows, Oracle 10g, Oracle Universal Content Management System
> Reporter: Rohan G Patil
> Assignee: Karl Wright
> Original Estimate: 48h
> Remaining Estimate: 48h
>
> The metadata for the documents checked in is stored in different fields of the Database. for example created date, Author,Title etc.
> The BLOB object contains only the text of the document. It would be very helpful if we could add support select Metadata fields (Columns in the database ) while querying the table.
> The above support would be helpful and make it a substitute for Oracle UCM (Stellent) Connector.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (CONNECTORS-44) Adding metadata support to JDBC
connector
Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CONNECTORS-44?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12877469#action_12877469 ]
Karl Wright commented on CONNECTORS-44:
---------------------------------------
The following proposal would meet the requirement, seems to me:
(1) Rename the internal column names provided by the connector for things like $(IDCOLUMN) to something pretty obscure, e.g. "LCF__ID". This would help prevent unintended collisions.
(2) For the data query, interpret ALL columns that are not part of the predefined set as being metadata, where the name of the metadata item will be the column's name in the corresponding resultset.
It seems to me that this would grant sufficient control to the user to do almost anything with the connector, metadata-wise.
> Adding metadata support to JDBC connector
> -----------------------------------------
>
> Key: CONNECTORS-44
> URL: https://issues.apache.org/jira/browse/CONNECTORS-44
> Project: Lucene Connector Framework
> Issue Type: Improvement
> Components: JDBC connector
> Environment: Windows, Oracle 10g, Oracle Universal Content Management System
> Reporter: Rohan G Patil
> Assignee: Karl Wright
> Original Estimate: 48h
> Remaining Estimate: 48h
>
> The metadata for the documents checked in is stored in different fields of the Database. for example created date, Author,Title etc.
> The BLOB object contains only the text of the document. It would be very helpful if we could add support select Metadata fields (Columns in the database ) while querying the table.
> The above support would be helpful and make it a substitute for Oracle UCM (Stellent) Connector.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (CONNECTORS-44) Adding metadata support to JDBC
connector
Posted by "Karl Wright (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CONNECTORS-44?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Karl Wright resolved CONNECTORS-44.
-----------------------------------
Resolution: Fixed
Committed fix in svn revision 953386.
> Adding metadata support to JDBC connector
> -----------------------------------------
>
> Key: CONNECTORS-44
> URL: https://issues.apache.org/jira/browse/CONNECTORS-44
> Project: Lucene Connector Framework
> Issue Type: Improvement
> Components: JDBC connector
> Environment: Windows, Oracle 10g, Oracle Universal Content Management System
> Reporter: Rohan G Patil
> Assignee: Karl Wright
> Original Estimate: 48h
> Remaining Estimate: 48h
>
> The metadata for the documents checked in is stored in different fields of the Database. for example created date, Author,Title etc.
> The BLOB object contains only the text of the document. It would be very helpful if we could add support select Metadata fields (Columns in the database ) while querying the table.
> The above support would be helpful and make it a substitute for Oracle UCM (Stellent) Connector.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (CONNECTORS-44) Adding metadata support to JDBC
connector
Posted by "Rohan G Patil (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CONNECTORS-44?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12877714#action_12877714 ]
Rohan G Patil commented on CONNECTORS-44:
-----------------------------------------
Regarding this being a Stellent connector.
I was supposed to write a Oracle UCM (Formally Stellent) repository connector.
upon searching, i found that oracle fulltext search actually stores all the documents in the database( 2 tables actually IDCCOLL1 and IDCCOLL2), even the data as BLOB and metadata in different columns.
So i used the JDBC connector as a "substitute" for a stellent connector.
> Adding metadata support to JDBC connector
> -----------------------------------------
>
> Key: CONNECTORS-44
> URL: https://issues.apache.org/jira/browse/CONNECTORS-44
> Project: Lucene Connector Framework
> Issue Type: Improvement
> Components: JDBC connector
> Environment: Windows, Oracle 10g, Oracle Universal Content Management System
> Reporter: Rohan G Patil
> Assignee: Karl Wright
> Original Estimate: 48h
> Remaining Estimate: 48h
>
> The metadata for the documents checked in is stored in different fields of the Database. for example created date, Author,Title etc.
> The BLOB object contains only the text of the document. It would be very helpful if we could add support select Metadata fields (Columns in the database ) while querying the table.
> The above support would be helpful and make it a substitute for Oracle UCM (Stellent) Connector.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.