Error with JDBC mapping:elasticsearch


(poonam) #1

Hi ,
when I am trying to add mapping to index I am getting above "ElasticsearchIllegalStateException: client is closed" issue.but if I execute without mapping it works fine.
My sence JSON

PUT /kbdbtest
{
"index":
{
"analysis": {

   "filter": {
              "de_stop_filter": {
  "type": "stop",
  "stopwords": ["_german_"]
},
"de_stem_filter": {
  "type": "stemmer",
  "name": "minimal_german"
},
"en_stop_filter": {
  "type": "stop",
  "stopwords": ["_english_"]
},
"en_stem_filter": {
  "type": "stemmer",
  "name": "minimal_english"
}
             },
   "analyzer":
   {
     

     "de_analyzer": {
  "type": "custom",
  "filter": [ "de_stop_filter", "de_stem_filter"],
  "tokenizer": "standard"
},

"en_analyzer": {
  "type": "custom",
  "filter": [ "en_stop_filter", "en_stem_filter"],
  "tokenizer": "standard"
}

  } 
 }

}
}

get /kbdbtest
PUT /kbdbtest/searchproducts/_mapping
{

    "search_analyzer" : "standard", 
    "properties" : {
       
        "solid" :  {"type":"integer" },
        "title": {"type": "string"},
        "AffectedReleases" : {
            "type" : "string" }

        
        
    }        

}

PUT http://localhost:9200/kbdbtest/searchproducts/_meta
{
"type":"jdbc",
"jdbc":
{
"driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
"url":"jdbc:sqlserver://usalvwaldbqa1:1433;databaseName=es",
"user":"es",
"password":"Answ3r21",
"sql":"SELECT top 1 solid,title,AffectedReleases FROM es.es.g_fast_solutions_soho ",

"index" : "kbdbtest",
"type" : "searchproducts"

}
}


(system) #2