WARNING: Error creating document : SolrInputDocument[{town=town(1.0)={Recklinghausen}, gender=gender(1.0)={true}, profiletext=profiletext(1.0)={}, zip=zip(1.0)={45657}, country=country(1.0)={DE}, id=id(1.0)={309}, username=username(1.0)={geisha}}]
java.lang.NumberFormatException: For input string: "true"
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
        at java.lang.Integer.parseInt(Integer.java:447)
        at java.lang.Integer.parseInt(Integer.java:497)
        at org.apache.solr.schema.TrieField.createField(TrieField.java:416)
        at org.apache.solr.schema.SchemaField.createField(SchemaField.java:94)
        at org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:246)
        at org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdateProcessorFactory.java:60)
        at org.apache.solr.handler.dataimport.SolrWriter.upload(SolrWriter.java:75)
        at org.apache.solr.handler.dataimport.DataImportHandler$1.upload(DataImportHandler.java:292)
        at org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:392)
        at org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:242)
        at org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:180)
        at org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:331)
        at org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:389)
        at org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:370)


schema.xml

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

   <field name="username" type="textgen" indexed="true" stored="true" required="true"/>
   <field name="country" type="text" indexed="true" stored="true" required="true"/>
   <field name="gender" type="int" indexed="true" stored="true" required="true"/>
   <field name="town" type="textgen" indexed="true" stored="true" required="true"/>
   <field name="zip" type="text" indexed="true" stored="true" required="true"/>
   <field name="profiletext" type="text" indexed="true" stored="true" required="true"/>
   <field name="interests" type="text" indexed="true" stored="true" required="true"/>

data-import.xml

<?xml version="1.0" encoding="UTF-8"?>
<dataConfig>
    <dataSource type="JdbcDataSource"
                  driver="com.mysql.jdbc.Driver"
                  url="jdbc:mysql://localhost/mfv2"
                  user="x"
                  password="x"/>

    <document name="doc">
        <entity name="users"
                  query="select user_uid,user_username,country_iso, user_gender, user_town, user_zip, user_profiletext_long, user_interests from
                  mm_user">
            <field column="user_uid" name="id" />
            <field column="user_username" name="username" />
            <field column="country_iso" name="country" />
            <field column="user_gender" name="gender" />
            <field column="user_town" name="town" />
            <field column="user_zip" name="zip" />
            <field column="user_profiletext_long" name="profiletext" />
            <field column="user_interests" name="interests" />
        </entity>
    </document>
</dataConfig>