Hi Tim and Gandhi,
Thanks allot for your responses. I just found we can pass
database external source name through JdbcCollectionReader.example.xml
file.
Regards,
Kishore.
On Mon, Jan 22, 2018 at 6:21 PM, Gandhi Rajan Natarajan <
gandhi.natara...@arisglobal.com> wrote:
> I guess that should be the database resource name.
>
> You can have a look at the following file - http://svn.apache.org/viewvc/
> ctakes/trunk/ctakes-dictionary-lookup/src/main/java/org/apache/ctakes/
> dictionary/lookup/ae/UmlsDictionaryLookupAnnotator.java?view=markup where
> you could see db resource name like ' DbConnection', '
> OrangeBookIndexReader' etc.
>
> Regards,
> Gandhi
>
>
> -----Original Message-----
> From: kishore [mailto:kasaraneni.kish...@gmail.com]
> Sent: Monday, January 22, 2018 4:55 PM
> To: dev@ctakes.apache.org
> Subject: Re: Can we build CollectionReader from database [EXTERNAL]
>
> Hi Tim,
>
> I tried as you suggested. but I couldn't understand the variable
> PARAM_DB_CONN_RESRC.
> Do we need to pass "driver_url;connection_string;user;password".
>
> Thanks,
> Kishore.
>
> On Fri, Jan 12, 2018 at 4:59 PM, Miller, Timothy <
> timothy.mil...@childrens.harvard.edu> wrote:
>
> > Hi Kishore,
> > Take a look in this directory for many different collection reader
> options:
> > http://svn.apache.org/viewvc/ctakes/trunk/ctakes-core/src/
> > main/java/org/apache/ctakes/core/cr/
> >
> > JcdbCollectionReader may work for you.
> >
> > here are the parameters with comments:
> >
> > 59 /**
> > 60 * SQL statement to retrieve the document.
> > 61 */
> > 62 public static final String PARAM_SQL = "SqlStatement";
> > 63
> > 64 /**
> > 65 * Name of column from resultset that contains the document
> > text. Supported
> > 66 * column types are CHAR, VARCHAR, and CLOB.
> > 67 */
> > 68 public static final String PARAM_DOCTEXT_COL =
> > "DocTextColName";
> > 69
> > 70 /**
> > 71 * Name of external resource for database connection.
> > 72 */
> > 73 public static final String PARAM_DB_CONN_RESRC =
> > "DbConnResrcName";
> > 74
> > 75 /**
> > 76 * Optional parameter. Specifies column names that will be
> > used to form a
> > 77 * document ID.
> > 78 */
> > 79 public static final String PARAM_DOCID_COLS =
> "DocIdColNames";
> > 80
> > 81 /**
> > 82 * Optional parameter. Specifies delimiter used when document
> > ID is built.
> > 83 */
> > 84 public static final String PARAM_DOCID_DELIMITER =
> > "DocIdDelimiter";
> > 85
> >
> >
> > Tim
> >
> > ________________________________________
> > From: kishore <kasaraneni.kish...@gmail.com>
> > Sent: Friday, January 12, 2018 6:26 AM
> > To: dev@ctakes.apache.org
> > Subject: Can we build CollectionReader from database [EXTERNAL]
> >
> > Hi,
> > I got to know we can build CollectionReader using
> FileCollectionReader.
> > Do we have option to build CollectionReader from database? Can you
> > suggest me how to do that?
> >
> > Thanks,
> > Kishore.
> >
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If you are not the named addressee you should not disseminate, distribute
> or copy this e-mail. Please notify the sender or system manager by email
> immediately if you have received this e-mail by mistake and delete this
> e-mail from your system. If you are not the intended recipient you are
> notified that disclosing, copying, distributing or taking any action in
> reliance on the contents of this information is strictly prohibited and
> against the law.
>
