Re: java.lang.NullPointerException with MySQL DataImportHandler

2010-02-03 Thread Noble Paul നോബിള്‍ नोब्ळ्
On Thu, Feb 4, 2010 at 10:50 AM, Lance Norskog 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 obviously not wi

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 wrote: > Hi, > > since some of the fields used

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 db-rela

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 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 fie

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 Solr