# Jdbcstreaming exception

**URL:** <https://discuss.elastic.co/t/jdbcstreaming-exception/146456>\
**Category:** Logstash\
**Created:** [August 29, 2018, 2:34am UTC](https://discuss.elastic.co/t/jdbcstreaming-exception/146456 "2018-08-29T02:34:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![seungtae](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/seungtae/32/71413_2.png) [@seungtae](https://discuss.elastic.co/u/seungtae)\
**Post date:** [August 29, 2018, 2:34am UTC](https://discuss.elastic.co/t/jdbcstreaming-exception/146456/1 "2018-08-29T02:34:06Z")

</div>

Hi everyone.

I have an issue with jdbc\_streaming filter.

My config like..

```
jdbc_streaming {
		jdbc_driver_library => "/usr/share/logstash/vendor/jar/jdbc/ojdbc6.jar"
		jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
		jdbc_connection_string => "..."	

		jdbc_user => " ****"
		jdbc_password => " ****"

		statement => "SELECT CID FROM TB_REN016_002 WHERE CID = 10011000001"
					
		target => "matchingCid"	
	}

```

but, the result come,

> [WARN] 2018-08-29 11:17:35.368 [Ruby-0-Thread-19@[main]\>worker11: /usr/share/logstash/logstash-core/lib/logstash/pipeline.rb:384] jdbcstreaming - Exception when executing JDBC query {:exception=\>#\<Sequel::DatabaseError: Java::JavaSql::SQLRecoverableException: No more data to read from socket\>}  
> {  
> "headers" =\> {  
> "request\_method" =\> "POST",  
> "request\_path" =\> "/",  
> "http\_connection" =\> "Keep-Alive",  
> "content\_length" =\> "580",  
> "http\_version" =\> "HTTP/1.1",  
> "content\_type" =\> "application/vnd.onem2m-ntfy+xml;charset=UTF-8",  
> "request\_uri" =\> "/",  
> "http\_x\_m2m\_origin" =\> "00000168702c1ffffe4a2570",  
> "http\_accept" =\> "application/xml",  
> "https" =\> "https",  
> "http\_x\_m2m\_ri" =\> "685b0e25-799d-464a-999b-c5b66d725c95",  
> "http\_host" =\> "218.145.52.139:12443"  
> },  
> "thingPlug\_time" =\> [  
> [0] "2018-08-29T11:17:02+09:00"  
> ],  
> "message" =\> "\<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?\>\<m2m:cin xmlns:m2m="[http://www.onem2m.org/xml/protocols\](http://www.onem2m.org/xml/protocols%5C)" xmlns:xsi="[http://www.w3.org/2001/XMLSchema-instance\"\>\<ty\>4\</ty\>\<ri\>CI00000000003603939500\</ri\>\<rn\>CI00000000003603939500\</rn\>\<pi\>CT00000000000000235746\</pi\>\<ct\>2018-08-29T11:17:02+09:00\</ct\>\<lt\>2018-08-29T11:17:02+09:00\</lt\>\<sr\>/0240771000000168/v1\_0/remoteCSE-00000168702c1ffffe4a2570/container-LoRa//subscription-rems\</sr\>\<et\>2018-08-30T11:17:02+09:00\</et\>\<st\>12215\</st\>\<cr\>RC00000000000000242315\</cr\>\<cnf\>LoRa/Sensor\</cnf\>\<cs\>10\</cs\>\<con\>1401010039\</con\>\</m2m:cin\>"](http://www.w3.org/2001/XMLSchema-instance%5C%22%3E%3Cty%3E4%3C/ty%3E%3Cri%3ECI00000000003603939500%3C/ri%3E%3Crn%3ECI00000000003603939500%3C/rn%3E%3Cpi%3ECT00000000000000235746%3C/pi%3E%3Cct%3E2018-08-29T11:17:02+09:00%3C/ct%3E%3Clt%3E2018-08-29T11:17:02+09:00%3C/lt%3E%3Csr%3E/0240771000000168/v1_0/remoteCSE-00000168702c1ffffe4a2570/container-LoRa//subscription-rems%3C/sr%3E%3Cet%3E2018-08-30T11:17:02+09:00%3C/et%3E%3Cst%3E12215%3C/st%3E%3Ccr%3ERC00000000000000242315%3C/cr%3E%3Ccnf%3ELoRa/Sensor%3C/cnf%3E%3Ccs%3E10%3C/cs%3E%3Ccon%3E1401010039%3C/con%3E%3C/m2m:cin%3E%22),  
> "tags" =\> [  
> [0] "\_jdbcstreamingfailure",  
> [1] "\_jdbcstreamingdefaultsused"  
> ],  
> "parsed\_sr" =\> [  
> [0] "/0240771000000168/v1\_0/remoteCSE-00000168702c1ffffe4a2570/container-LoRa//subscription-rems"  
> ],  
> "host" =\> "211.234.246.200",  
> "matchingCid" =\> [  
> [0] {}  
> ],  
> "data\_info" =\> {  
> "flag" =\> "0"  
> },  
> "@timestamp" =\> 2018-08-29T02:17:35.255Z,  
> "parsed\_con" =\> [  
> [0] "1401010039"  
> ]  
> }

it's end.. What can I do?

---

<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:** [September 26, 2018, 2:38am UTC](https://discuss.elastic.co/t/jdbcstreaming-exception/146456/2 "2018-09-26T02:38:45Z")

</div>

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