I have used Solr 3.3 version as Data Import Handler(DIH) with Oracle.Its
working fine for me.
Now I am trying the same with Mysql.With the change in database, I have changed
the query used in data-config.xml for MySql.
The query has variables which are passed url in http.The same thing works fine
in Oracle with variable resolver but not in MySql.
The query is :
SELECT DISTINCT doc.document_id,doc.first_version_id,doc.acl_id,fol.folder_id
FROM ds_document_c doc, ds_folder folWHERE doc.cabinet_id =
${dataimporter.request.cabinetId} AND fol.folder_id =
doc.document_folder_id AND doc.index_state_modification_date >=
to_date('${dataimporter.request.lastIndexDate}', 'DD/MM/YYYY HH24:MI:SS')
and the Url is :
localhost:8983/solr/dataimport?command=full-import&clean=true&commit=true&cabinetId=17083360&lastIndexDate='24/05/2015
00:00:00'
Solr is building the query as below : SELECT DISTINCT
doc.document_id ,doc.first_version_id,doc.acl_id,fol.folder_id FROM
ds_document_c doc,ds_folder fol WHERE doc.cabinet_id = 24AND fol.folder_id =
doc.document_folder_id AND doc.index_state_modification_date >= to_date('[?,
'28/05/2015 11:13:50']', 'DD/MM/YYYY HH24:MI:SS')
I am not able to figure it our why the date variable is not resloved properly
in this case.
Because of `to_date('[?, '28/05/2015 11:13:50']'` is not in a proper MySql
syntax, I am getting MySql Syntax error.
I get the following error You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near '[?, '28/05/2015 11:13:50'], 'DD/MM/YYYY HH24:MI:SS')))' at line 1
Anyone knows where is the problem? Why is the variable resolver not working as
expected?
Note : to_date is function written by us in MySql.
I have checked out the solr code from svn... trying it by adding logs to
it...but the logs are not reflected and i m not able to move it.
I am not very sure very it is wrong ...but just a wild guess that something is
wrong at variableResolverImpl.replaceTokens or at the
TemplateString.fillTokens...
I will keep on it but if you know/get a chance to look at it, it would be of
great help from your end..
Regards,Abhijit
