oracle - Solr date variable resolver is not working with MySql -

-

i have used solr 3.3 version data import handler(dih) oracle. working fine me.

now trying same mysql. change in database, have changed query used in data-config.xml mysql.

the query has variables passed url in http. same thing works fine in oracle variable resolver not in mysql.

the query :

select distinct doc.document_id ,   doc.first_version_id,   doc.acl_id,                       fol.folder_id                  ds_document_c doc,   ds_folder fol doc.cabinet_id = ${dataimporter.request.cabinetid}   , fol.folder_id = doc.document_folder_id   , doc.index_state_modification_date >= to_date('${dataimporter.request.lastindexdate}', 'dd/mm/yyyy hh24:mi:ss')

and url : 

localhost:8983/solr/dataimport?command=full-import&clean=true&commit=true&cabinetid=17083360&lastindexdate='24/05/2015 00:00:00'

solr building query below : 

select distinct doc.document_id ,   doc.first_version_id,   doc.acl_id,                       fol.folder_id                  ds_document_c doc,   ds_folder fol doc.cabinet_id = 24 , fol.folder_id = doc.document_folder_id , doc.index_state_modification_date >= to_date('[?, '28/05/2015 11:13:50']', 'dd/mm/yyyy hh24:mi:ss')

i not able figure our why date variable not resloved in case.

because of to_date('[?, '28/05/2015 11:13:50']' not in proper mysql syntax, getting mysql syntax error.

i following error 

you have error in sql syntax; check manual corresponds mysql server version right syntax use near '[?, '28/05/2015 11:13:50'], 'dd/mm/yyyy hh24:mi:ss')))' @ line 1

anyone knows problem? why variable resolver not working expected?

note : to_date function written in mysql.

i checked out source code solr , tried solve issue.

i had fix , working me.

the variable resolve in case of date somehow making array , appends 

'[?, '28/05/2015 11:13:50']'.

in templatestring.java in method filltokens(variableresolver resolver) have added code removes part added date.

if (i < s.length) {    if(s[i].startswith("[")){       string temp = s[i].replace("[?,", "");       temp = temp.replace("]", "");       sb.append(temp);    }else{       sb.append(s[i]);    } }

with change, variable resolver appends date '28/05/2015 11:13:50' , removed mysql syntax error.

(note : didn't had time analyse why date variable resolved array. have done temporary fix , solved issue.)


Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more