DataImportHanler JDBC case problems

[JCodina <jo...@barcelonamedia.org>]

I tried to perform a DataImportHandler where the column name "user" and the
field name  "User" are  the same  but the case of the first letter,
when performing a full import, I was getting different sorts of errors, on
that field depending on the cases of the names, I tried the four possible
combinations,  and none worked. 
At the end, I changed column name in the database to be "User" and everthing
was fine.
  
<dataConfig>
    <document >
        <entity name="item" query="select * from DeNDocs">
	    <field column="ID" name="id" />
            <field column="User" name="User" />
....

-- 
View this message in context: http://www.nabble.com/DataImportHanler-JDBC-case-problems-tp20617216p20617216.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: DataImportHanler JDBC case problems

[Noble Paul നോബിള്‍ नोब्ळ् <no...@gmail.com>]

The column value should be same as it is in the DB and the name value
should be same as it is in the schema.

BTW, if you are using a latest nightly all this must be fixed. The
case does not matter.

On Fri, Nov 21, 2008 at 2:13 PM, JCodina <jo...@barcelonamedia.org> wrote:
>
> I tried to perform a DataImportHandler where the column name "user" and the
> field name  "User" are  the same  but the case of the first letter,
> when performing a full import, I was getting different sorts of errors, on
> that field depending on the cases of the names, I tried the four possible
> combinations,  and none worked.
> At the end, I changed column name in the database to be "User" and everthing
> was fine.
>
> <dataConfig>
>    <document >
>        <entity name="item" query="select * from DeNDocs">
>            <field column="ID" name="id" />
>            <field column="User" name="User" />
> ....
>
> --
> View this message in context: http://www.nabble.com/DataImportHanler-JDBC-case-problems-tp20617216p20617216.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>



-- 
--Noble Paul