search

jprante / elasticsearch-jdbc

JDBC importer for Elasticsearch
Apache License 2.0
2.84k stars 710 forks source link

How to pass null values in elastic search parameters..Please help me. Thanks in advance #854

Open kavurupavan opened 8 years ago

kavurupavan commented 8 years ago

bin=/home/pavan/Desktop/elasticsearch-jdbc-2.3.1.0/bin lib=/home/pavan/Desktop/elasticsearch-jdbc-2.3.1.0/lib echo ' { "jdbc" : { "driver": "org.postgresql.Driver", "url" : "jdbc:postgresql://192.168.30.51:5432/10kinfo_data", "user" : "b2g_mns", "password" : "b2gmns", "sql" : [ { "callable" : true, "statement" : "{call cloud10k.sp_form_resolution(?::varchar, ?::varchar, ?::varchar, ?::bigint, ?::boolean)}", "parameter" : [ "JPMORGAN CHASE & CO|CLLYF|0000019617", "FWP", "CURRENT", null, "T" ] } ], "index" : "my_jdbc_river17", "type" : "my_jdbc_river17" } }' | java \ -cp "/home/pavan/Desktop/elasticsearch-jdbc-2.3.1.0/lib/*" \ -Dlog4j.configurationFile=/home/pavan/Desktop/elasticsearch-jdbc-2.3.1.0/bin/log4j2.xml \ org.xbib.tools.Runner \ org.xbib.tools.JDBCImporter

Error : [ERROR][importer.jdbc.context.standard][pool-3-thread-1] at fetch: org.postgresql.util.PSQLException: No value specified for parameter 5.

jprante commented 8 years ago

org.postgresql.util.PSQLException is a driver problem, not JDBC importer. Postgresql JDBC driver does not accept null value.

kavurupavan commented 8 years ago

How can solve this problem. Please help me sir.

jprante commented 8 years ago

Ask Postgresl, it is a driver problem. In Postgresl, setting to null is not supported.

http://stackoverflow.com/questions/22045641/is-it-possible-to-pass-a-null-parameter-to-a-stored-procedure-in-java-jpa-2-1