Re: Getting started with indexing a database

2012-01-15 Thread Rakesh Varna
Hi Mike, Can you try removing ' from the nested entities? Just keep it in the top level entity. Regards, Rakesh Varna On Wed, Jan 11, 2012 at 7:26 AM, Gora Mohanty wrote: > On Tue, Jan 10, 2012 at 7:09 AM, Mike O'Leary wrote: > [...] > > My data-config.xml file looks like this: > > > > >

Re: Getting started with indexing a database

2012-01-11 Thread Gora Mohanty
On Tue, Jan 10, 2012 at 7:09 AM, Mike O'Leary wrote: [...] > My data-config.xml file looks like this: > > >                url="jdbc:mysql://localhost:3306/bioscope" user="db_user" > password=""/> >   >                deltaQuery="SELECT doc_id FROM bioscope.docs where last_modified > > '${datai

Re: Getting started with indexing a database

2012-01-11 Thread Erick Erickson
I'm not going to be much help here since DIH is a mystery to me, I usually go with a SolrJ program when DIH gets beyond simple cases. But have you seen: http://wiki.apache.org/solr/DataImportHandler#interactive It's a tool that helps you see what's going on with your query. Best Erick On Mon, Ja

Getting started with indexing a database

2012-01-09 Thread Mike O'Leary
I am trying to index the contents of a database for the first time, and I am only getting the primary key of the table represented by the top level entity in my data-config.xml file to be indexed. The database I am starting with has three tables: The table called docs has columns called doc_id,