Re: java.lang.NullPointerException with MySQL DataImportHandler

2010-02-03 Thread Lance Norskog
I just tested this with a DIH that does not use database input. If the DataImportHandler JDBC code does not support a schema that has optional fields, that is a major weakness. Noble/Shalin, is this true? On Tue, Feb 2, 2010 at 8:50 AM, Sascha Szott sz...@zib.de wrote: Hi, since some of the

Re: java.lang.NullPointerException with MySQL DataImportHandler

2010-02-03 Thread Noble Paul നോബിള്‍ नोब्ळ्
On Thu, Feb 4, 2010 at 10:50 AM, Lance Norskog goks...@gmail.com wrote: I just tested this with a DIH that does not use database input. If the DataImportHandler JDBC code does not support a schema that has optional fields, that is a major weakness. Noble/Shalin, is this true? The problem is

java.lang.NullPointerException with MySQL DataImportHandler

2010-02-02 Thread Jean-Michel Philippon-Nadeau
Hi, It is my first install of Solr. The setup has been pretty straightforward and yet, the performance is very impressive. I am running into an issue with my MySQL DataImportHandler. I've followed the quick-start in order to write the necessary config and so far everything seemed to work.

Re: java.lang.NullPointerException with MySQL DataImportHandler

2010-02-02 Thread Sascha Szott
Hi, can you post * the output of MySQL's describe command for all tables/views referenced in your DIH configuration * the DIH configuration file (i.e., data-config.xml) * the schema definition (i.e., schema.xml) -Sascha Jean-Michel Philippon-Nadeau wrote: Hi, It is my first install of

Re: java.lang.NullPointerException with MySQL DataImportHandler

2010-02-02 Thread Shalin Shekhar Mangar
On Tue, Feb 2, 2010 at 8:36 PM, Jean-Michel Philippon-Nadeau j...@jmpnadeau.ca wrote: I am running into an issue with my MySQL DataImportHandler. I've followed the quick-start in order to write the necessary config and so far everything seemed to work. However, I am missing some fields in

Re: java.lang.NullPointerException with MySQL DataImportHandler

2010-02-02 Thread Jean-Michel Philippon-Nadeau
Hi, Thanks for the reply. On Tue, 2010-02-02 at 16:57 +0100, Sascha Szott wrote: * the output of MySQL's describe command for all tables/views referenced in your DIH configuration mysql describe products; ++--+--+-+-++ | Field

Re: java.lang.NullPointerException with MySQL DataImportHandler

2010-02-02 Thread Sascha Szott
Hi, since some of the fields used in your DIH configuration aren't mandatory (e.g., keywords and tags are defined as nullable in your db table schema), add a default value to all optional fields in your schema configuration (e.g., default = ). Note, that Solr does not understand the