problem with uniqueKey in solr

I am new to solr, while creating the indexes i am attaching string to database table id

my field in schema.xml as follows

<field name="id" type="string" indexed="true" stored="true" required="true"/>
<uniqueKey>id</uniqueKey>

and i am passing 'GROUP1' for id, but it is sto开发者_开发问答ring [B@1e090ee like this.

How could i store the same value(GROUP1) instead of [B@1e090ee ?

Please help

Is group_id string or some numeric data type?
If it's not string you need to cast it to char before concatenation with appropriate encoding.

Also add encoding (that matches your MySQL db encoding) parameter to dataSource tag, like this:

<dataSource 
    driver="com.mysql.jdbc.Driver" 
    url="jdbc:mysql://host/dbname" 
    batchSize="-1" 
    user="username" 
    password="password" 
    readOnly="true" 
    autoCommit="true" 
    encoding="UTF-8" />

Which DB are you using?
Do you see the correct values when you execute your query directly in your db?

IMHO, the problem has to be either with DataImportHandler or you actually have values like that ([B@1e090ee) in your group_id field.
Have you checked that encoding param in your dataCofig's dataSource is the same as your db's encoding?

Can you post your dataConfig file?

@mbonaci

I am using mysql database.

when i execute the same query, the results are coming fine

the following is my data config file

<?xml version="1.0" encoding="UTF-8" ?>
<dataConfig>
<dataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://host/dbname" batchSize="-1" user="username" password="password" readOnly="true" autoCommit="true" />
  <document name="products">
        <entity name="item" query="select group_id,group_title,description,DATE_FORMAT(created_date, '%Y-%m-%dT%H:%i:%sZ') as createdDate,group_status,CONCAT('GROUP',group_id) as id,'GROUP' as itemtype  from collaboration_groups where group_status=1 ">
            <field column="id" name="id" />
            <field column="group_id" name="itemid" />
            <field column="itemtype" name="itemtype" />
            <field column="group_title" name="fullName" />
            <field column="description" name="description"/>
            <field column="createdDate" name="createdDate"/>
        </entity>
 </document>
</dataConfig>