JSONObject["id"] not found

[David Arcoleo]

Anyone ever get

SEVERE: *****  Data import failed. **********

 Reason is :

net.sf.json.JSONException: JSONObject["id"] not found.

at net.sf.json.JSONObject.getString(JSONObject.java:2092)

at net.sathis.export.sql.es.ESWriter.writeToNoSQL(ESWriter.java:63)

at net.sathis.export.sql.DocBuilder.execute(DocBuilder.java:142)

at net.sathis.export.sql.DataImporter.doFullImport(DataImporter.java:174)

at net.sathis.export.sql.DataImporter.doDataImport(DataImporter.java:93)

at net.sathis.export.sql.SQLToNoSQLImporter.main(SQLToNoSQLImporter.java:19)

My db-data-config.xml is

<dataConfig>

    <dataSource driver="com.mysql.jdbc.Driver" url="jdbc:mysql://127.0.0.1/mydb" user="X" password="X" batch-size="-1"/>

 

    <document name="providers">

       <entity name="mytable" pk="id" query="SELECT id from mytable">

          <field column="id" name="id" type="integer"/>

          <field column="name" name="userName" type="string"/>

       </entity>       

    </document> 

</dataConfig>

if I remove the pk="id" part, it works fine.

Thanks,

-Dave