# JDBC plugin not supports unsigned int?

**URL:** <https://discuss.elastic.co/t/jdbc-plugin-not-supports-unsigned-int/62123>\
**Category:** Logstash\
**Created:** [October 4, 2016, 3:37am UTC](https://discuss.elastic.co/t/jdbc-plugin-not-supports-unsigned-int/62123 "2016-10-04T03:37:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rayen\_Yang](https://avatars.discourse-cdn.com/v4/letter/r/db5fbb/32.png) [@Rayen\_Yang](https://discuss.elastic.co/u/Rayen_Yang)\
**Post date:** [October 4, 2016, 3:37am UTC](https://discuss.elastic.co/t/jdbc-plugin-not-supports-unsigned-int/62123/1 "2016-10-04T03:37:12Z")

</div>

I have a table which has a **_unsigned int_** column in MySQL.Its a pity that exception occurred when I used Logstash to read this table:

_**e[33mException when executing JDBC query {:exception=\>#\<Sequel::DatabaseError: J**_  
_ **ava::ComMysqlJdbcExceptionsJdbc4::MySQLDataException: '2.926689519E9' in column** _  
_ **'2' is outside valid range for the datatype INTEGER.\>, :level=\>:warn}e** _

my lostash config:

input{  
jdbc{jdbc\_driver\_library=\>"mysql-connector-java-5.1.37.jar"  
jdbc\_driver\_class=\>"com.mysql.jdbc.Driver"  
jdbc\_connection\_string=\>"jdbc:mysql://localhost:3306/mydb  
jdbc\_user=\>"root"  
jdbc\_password=\>"1234"  
schedule=\>"\* \* \* \* \*"  
jdbc\_paging\_enabled=\>true  
jdbc\_page\_size=\>1000  
statement=\>"SELECT \* from mytable where record\_id\>:sql\_last\_value order by record\_id desc"  
use\_column\_value=\>true  
tracking\_column=\>"record\_id"  
}  
}  
output{  
elasticsearch{

```
    }

```

}

---

<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, 4:35am UTC](https://discuss.elastic.co/t/jdbc-plugin-not-supports-unsigned-int/62123/2 "2017-07-06T04:35:58Z")

</div>