Hi!
I think it works but using alias with Oracle database....
<entity name="documento" query="SELECT iddocumento,nrodocumento,asunto as
asunto1,autor FROM documento">
<field column="iddocumento" name="iddocumento" />
<field column="nrodocumento" name="nrodocumento" />
<field column="asunto1" name="asunto1" />
<field column="autor" name="autor" />
</entity>
Am i wrong with this??? Anyone tried DIH with Oracle?
Thanks for your help
On Fri, Jun 1, 2012 at 10:34 AM, Jack Krupansky <j...@basetechnology.com>wrote:
> James: Is there some particular DIH logging he can turn on to see what is
> really happening with his field name mapping? In other words, if DIH/Solr
> really is ignoring that field mapping, to find out exactly why.
>
> -- Jack Krupansky
>
> -----Original Message----- From: Dyer, James
> Sent: Friday, June 01, 2012 10:50 AM
> To: solr-user@lucene.apache.org
> Subject: RE: Data Import Handler fields with different values in column
> and name
>
>
> Are you leaving both mappings in there, like this...
>
> <entity name="documento" query="SELECT iddocumento,nrodocumento,**asunto
> FROM documento">
> <field column="iddocumento" name="iddocumento" />
> <field column="nrodocumento" name="nrodocumento" />
> <field column="asunto" name="asunto" />
> <field column="asunto" name="anotherasunto" />
> </entity>
>
> If so, I'm not sure you can map "asunto" to two different fields like
> this. For that, you may need to write a transformer that will duplicate
> "asunto" for you. Although, in most cases all you need to do is add a
> <copyField /> in schema.xml to copy "asunto" to "anotherasunto". But a DIH
> Transformer would be helpful, for instance, if "asunto" is multi-valued but
> you only want to copy the first value to "anotherasunto" (perhaps you need
> to sort on it, which is not possible with multi-valued fields).
>
> If this doesn't help, let us know exactly why you need to duplicate
> "asunto" and maybe you can get more help from there.
>
> (If you're not trying to duplicate "asunto" and you're sure you've taken
> the duplicate out of data-config.xml, then go ahead and double-check
> spelling and case in all your config files. Besides a typo somewhere, I'm
> not sure what else would cause this not to map.)
>
> James Dyer
> E-Commerce Systems
> Ingram Content Group
> (615) 213-4311
>
>
> -----Original Message-----
> From: Rafael Taboada
> [mailto:kaliman.forever@gmail.**com<kaliman.fore...@gmail.com>
> ]
> Sent: Thursday, May 31, 2012 4:13 PM
> To: solr-user@lucene.apache.org
> Subject: Fwd: Data Import Handler fields with different values in column
> and name
>
> Please,
>
> Can anyone guide me through this issue? Thanks
>
>
>
> ---------- Forwarded message ----------
> From: Rafael Taboada <kaliman.fore...@gmail.com>
> Date: Thu, May 31, 2012 at 12:30 PM
> Subject: Data Import Handler fields with different values in column and
> name
> To: solr-user@lucene.apache.org
>
>
> Hi folks,
>
> I'm using Solr 3.6 and I'm trying to import data from my database to solr
> using Data Import Handler. My db-config is like this:
>
> <dataConfig>
> <dataSource driver="oracle.jdbc.**OracleDriver"
> url="jdbc:oracle:thin:@**localhost:1521:XE" user="admin" password="admin"
> />
> <document>
> <entity name="documento" query="SELECT
> iddocumento,nrodocumento,**asunto FROM documento">
> <field column="iddocumento" name="iddocumento" />
> <field column="nrodocumento" name="nrodocumento" />
> <field column="asunto" name="asunto" />
> </entity>
> </document>
> </dataConfig>
>
> My problem is when I'm trying to use a different values in the field tag,
> for example
>
> <field column="asunto" name="anotherasunto" />
>
> When I use different name from column, this field is omitted. Please can
> you help me with this issue?
>
> My schema.xml is:
>
> <types>
> <fieldtype name="string" class="solr.StrField" sortMissingLast="true"
> />
> </types>
>
> <fields>
> <!-- general -->
> <field name="iddocumento" type="string" indexed="true" stored="true"
> required="true" />
> <field name="nrodocumento" type="string" indexed="true" stored="true"
> />
> <field name="anotherasunto" type="string" indexed="true"
> stored="true" />
> </fields>
>
> Thanks in advance!
>
> --
> Rafael Taboada
>
>
>
>
>
>
> --
> Rafael Taboada
>
> /*
> * Phone >> 992 741 026
> */
>
--
Rafael Taboada
/*
* Phone >> 992 741 026
*/
