Re: Can't index sub-entitties in DIH

On 5 June 2012 20:08, Rafael Taboada wrote: > Hi Gora, > > Yes, I restart Solr for each change I do. > > Thanks for your help... > > An small question Is DIH work well with Oracle database? Using all the > features It can do? Unfortunately, I have never used DIH with Oracle. However, this sho

Re: Can't index sub-entitties in DIH

On 5 June 2012 20:05, Rafael Taboada wrote: > Hi James. > > Thanks for your advice. > > As I said, alias works for me. I use joins instead of sub-entities... > Heavily... > These config files work for me... [...] How about NULL values in the column that you are doing a left outer join on? Cannot

Re: Can't index sub-entitties in DIH

Hi Gora, Yes, I restart Solr for each change I do. Thanks for your help... An small question Is DIH work well with Oracle database? Using all the features It can do? On Tue, Jun 5, 2012 at 9:32 AM, Gora Mohanty wrote: > Hi, > > Sorry, I am stumped, and cannot help further without > acces

Re: Can't index sub-entitties in DIH

am Content Group > (615) 213-4311 > > > -Original Message- > From: Rafael Taboada [mailto:kaliman.fore...@gmail.com] > Sent: Tuesday, June 05, 2012 8:58 AM > To: solr-user@lucene.apache.org > Subject: Re: Can't index sub-entitties in DIH > > Hi Gora, > >

Re: Can't index sub-entitties in DIH

Hi, Sorry, I am stumped, and cannot help further without access to Oracle. Please disregard the bit about the quotes: I was reading a single quote followed by a double quote as three single quotes. There was no issue there. Since your configurations for Oracle, and mysql are different, are you us

Re: Can't index sub-entitties in DIH

Hi, One of the possibilities for this kind of issue to occur may be the case sensitivity of column names in Oracle. Can you apply a transformer and check the entity map which actually contains the keys and their values ? Also, please try specifying upper case field names for Oracle and try if that

RE: Can't index sub-entitties in DIH

ell try it. James Dyer E-Commerce Systems Ingram Content Group (615) 213-4311 -Original Message- From: Rafael Taboada [mailto:kaliman.fore...@gmail.com] Sent: Tuesday, June 05, 2012 8:58 AM To: solr-user@lucene.apache.org Subject: Re: Can't index sub-entitties in DIH Hi Gora, &

Re: Can't index sub-entitties in DIH

Hi Gora, > Your configuration files look fine. It would seem that something > is going wrong with the SELECT in Oracle, or with the JDBC > driver used to access Oracle. Could you try: * Manually doing the SELECT for the entity, and sub-entity > to ensure that things are working. > The SELECTs

Re: Can't index sub-entitties in DIH

On 5 June 2012 08:26, Rafael Taboada wrote: > Hi Gora. > > My apologizes for this subject. It wasn't my intention to be rude or > something like that. No need to apologize. I was hoping to make it easier for people to help you. > As I said about mapping database columns with solr fields, it work

Re: Can't index sub-entitties in DIH

Hi Gora. My apologizes for this subject. It wasn't my intention to be rude or something like that. As I said about mapping database columns with solr fields, it works in mysql. Maybe I'm wrong with some config file because I'm new with Solr. By the way, it is a great product. But I've just tried

Re: Can't index sub-entitties in DIH

On 4 June 2012 22:27, Rafael Taboada wrote: > > Hi folks, > > I've just solved using outer joins like this: > > >         >         >         >         > > Any idea why I can't index using sub-entities? [...] Dear Rafael, No offence meant, but please take a look at http://wiki.apache.org/so

Re: Can't index sub-entitties in DIH

Hi folks, I've just solved using outer joins like this: Any idea why I can't index using sub-entities? Thanks in advance On Mon, Jun 4, 2012 at 11:13 AM, Rafael Taboada wrote: > Hi folks, > > I'm using DIH in order to index my Oracle database but I'm h

Can't index sub-entitties in DIH

Hi folks, I'm using DIH in order to index my Oracle database but I'm having some issues. Right now, I can't index fields from sub-entities. I have in my db-data-config.xml: My schema.xml is: