# Jdbc\_static filter with multiple parameters crashes

**URL:** <https://discuss.elastic.co/t/jdbc-static-filter-with-multiple-parameters-crashes/147674>\
**Category:** Logstash\
**Created:** [September 7, 2018, 7:56am UTC](https://discuss.elastic.co/t/jdbc-static-filter-with-multiple-parameters-crashes/147674 "2018-09-07T07:56:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![JPelastic](https://avatars.discourse-cdn.com/v4/letter/j/9e8a1a/32.png) [@JPelastic](https://discuss.elastic.co/u/JPelastic)\
**Post date:** [September 7, 2018, 7:56am UTC](https://discuss.elastic.co/t/jdbc-static-filter-with-multiple-parameters-crashes/147674/1 "2018-09-07T07:56:51Z")

</div>

Without the jdbc\_static filter this works fine.

```auto
input {
	jdbc {
		jdbc_driver_library => "\trunk\Installation\sqljdbc_6.4\enu\mssql-jdbc-6.4.0.jre8.jar"
		jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
		jdbc_connection_string => "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
		jdbc_user => "xxxxxx"
		jdbc_password => "xxxxxxx"
		schedule => "13 09 * * *"
		statement => 
        "
           	SELECT DocumentCreateDateTime, DocumentSigned
			FROM Document
			WHERE DocumentID = 121915
        "
	 }
}
filter {

	mutate {
		convert => {"documentcreatedatetime" => "string"}
	}
	date {
		match => ["documentcreatedatetime", "ISO8601"] 
	}
	xml {
		source => "documentsigned"
		target => "invoice"
		remove_namespaces => true
		xpath => [
			"Invoice/ENV/Leverancier/GLN/text()", "gln",
			"Invoice/DET/Artikel/ArtikelcodeLeverancier/text()", "artCodeLev"
		]
	}
	
	jdbc_static {
		loaders => [
			{
				id => "ArtikelLeverancier_id"
				query => "SELECT GLN_leverancier, ArtCodeLev, Kortingsgroep FROM ArtLev ORDER BY Mutatiecode"
				local_table => "ArtikelLeverancier"
			}
		]
		local_db_objects => [
			{
				name => "ArtikelLeverancier"
				columns => [
					["GLN_leverancier", "varchar(13)"],
					["ArtCodeLev", "varchar(20)"],
					["Kortingsgroep", "varchar(35)"]
				]
			}
		]
		local_lookups => [
			{
				id => "local-servers"
				query => "SELECT Kortingsgroep FROM ArtLev WHERE GLN_leverancier = ':gln' AND ArtCodeLev = ':artCode'"
				parameters => {
					gln => "[gln]", 
					artCode => "[artCodeLev]"
				}
				target => "kortingsgroep"
			}
		]
		
		staging_directory => "/tmp/logstash/jdbc_static/import_data"
		loader_schedule => "* */2 * * *"
		jdbc_driver_library => "\trunk\Installation\sqljdbc_6.4\enu\mssql-jdbc-6.4.0.jre8.jar"
		jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
		jdbc_connection_string => "xxxxxxxxxxxxxxxxxxx"
		jdbc_user => "xxxxxxxxxxxxxxxxx"
	}
	
	mutate {
		remove_field => ["documentsigned", "documentout", "invoice"] 
	}
}
output {
	stdout { codec => rubydebug }
}

```

The crash happens right in the middle of the definition of the parameters:

```auto
block in converge_state

```

I bet it has to do with adding two parameters. There are no examples of two parameters on the internet.

---

<div class="post-metadata">

**Author:** ![JPelastic](https://avatars.discourse-cdn.com/v4/letter/j/9e8a1a/32.png) [@JPelastic](https://discuss.elastic.co/u/JPelastic)\
**Post date:** [September 7, 2018, 8:54am UTC](https://discuss.elastic.co/t/jdbc-static-filter-with-multiple-parameters-crashes/147674/2 "2018-09-07T08:54:18Z")

</div>

When I remove one of the parameters, it works, but that's not what I want.

---

<div class="post-metadata">

**Author:** ![JPelastic](https://avatars.discourse-cdn.com/v4/letter/j/9e8a1a/32.png) [@JPelastic](https://discuss.elastic.co/u/JPelastic)\
**Post date:** [September 10, 2018, 8:55am UTC](https://discuss.elastic.co/t/jdbc-static-filter-with-multiple-parameters-crashes/147674/3 "2018-09-10T08:55:33Z")

</div>

So

Two parameters is no problem, just don't add a comma!

---

<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:** [October 8, 2018, 8:55am UTC](https://discuss.elastic.co/t/jdbc-static-filter-with-multiple-parameters-crashes/147674/4 "2018-10-08T08:55:35Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.