es索引，创建在ora上

#!/bin/sh

# This example is a template to connect to Oracle
# The JDBC URL and SQL must be replaced by working ones.
#"schedule" : "0 0/5 * * * ?",
DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" && pwd )"
bin=${DIR}/../bin
lib=${DIR}/../lib

echo '
{
"type" : "jdbc",
"jdbc" : {

"url" : "jdbc:oracle:thin:@//10.101.5.165:1521/orcl",//本地数据库
"connection_properties" : {
"oracle.jdbc.TcpNoDelay" : false,
"useFetchSizeWithLongColumn" : false,
"oracle.net.CONNECT_TIMEOUT" : 10000,
"oracle.jdbc.ReadTimeout" : 50000
},
"user" : "btddd",
"password" : "btddd",
"metrics" : {
"enabled" : "true"
},
"statefile" : "000017.json",
"sql" : [
{"statement" : "select sfz_id, zzjgdm, yyzzzch, mc, lx, jyfw, hylb, zt, clrq, frdb, zczb, qydz, xtsj, jy_qx,xtsj AS \"time\" ,(sfz_id) AS \"title\" from DM_CZRDWZCXX "}//sql 时间戳+title
],
"threadpoolsize" : 1,
"locale" : "zh_CN",
"index" : "000017_index",//索引id
"type" : "000017_type",
"index_settings" : {
"index" : {
"number_of_shards" : 15,
"number_of_replicas" : 0
}
},
"type_mapping" : {
"000017_type" : {
"_all" : {"enabled" : false},
"properties" : {
"title":{
"analyzer":"whitespace",
"type":"string"
}
}
}
},
"elasticsearch" : {
"cluster" : "els",
"host" : [
"10.101.5.101:9310","10.101.5.101:9320","10.101.5.101:9330","10.101.5.177:9310","10.101.5.177:9320","10.101.5.177:9330"
]
},
"max_bulk_actions" : 20000,
"max_concurrent_bulk_requests" : 16
}
}
' | java \
-cp "${lib}/*" \
-Dlog4j.configurationFile=${bin}/log4j2.xml \
org.xbib.tools.Runner \
org.xbib.tools.JDBCImporter