# Java Api update Script (multiple Parameters)

**URL:** https://discuss.elastic.co/t/java-api-update-script-multiple-parameters/11429
**Category:** Elasticsearch
**Created:** [April 3, 2013, 1:19pm UTC](https://discuss.elastic.co/t/java-api-update-script-multiple-parameters/11429 "2013-04-03T13:19:04Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![knob1](https://avatars.discourse-cdn.com/v4/letter/k/839c29/32.png) [@knob1](https://discuss.elastic.co/u/knob1)
#### Post date: [April 3, 2013, 1:19pm UTC](https://discuss.elastic.co/t/java-api-update-script-multiple-parameters/11429/1 "2013-04-03T13:19:04Z")

</div>

Hi,  
my Java App does a SQL Request to get some Data.  
This Data is in a resultset, now I would like to update this Data from the Database in my Elasticsearch Index.

HashMap\<String, Object\> params = new HashMap\<String, Object\>();  
for(int i = 1; i\<count;i++){  
params.put(metaData.getColumnName(i), SQLrs.getString(i));  
}

while(SQLrs.next()){  
for(int i = 1; i\<count;i++){  
client.prepareUpdate(idxName, tableName, ID)  
.setScript("ctx.\_source.")  
.setScriptParams(params).execute().actionGet();  
}  
}

I hope this is correct so far, but I don't know how to set the Script to get all of the Parameters.

Before I tried to form many different scripts (setScript("ctx.\_source."+metaData.getColumnName(i)+""="+SQLrs.getString(i)""))  
But this was refused & I don't think this is the right way.

I hope somebody can help me with this.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 2:43am UTC](https://discuss.elastic.co/t/java-api-update-script-multiple-parameters/11429/2 "2017-07-06T02:43:03Z")

</div>