# \[BUG\] Unsigned SMALLINT throws query Exception

**URL:** <https://forum.inductiveautomation.com/t/bug-unsigned-smallint-throws-query-exception/112815>\
**Category:** Ignition\
**Tags:** perspective, ignition81, database\
**Created:** [December 15, 2025, 5:10pm UTC](https://forum.inductiveautomation.com/t/bug-unsigned-smallint-throws-query-exception/112815 "2025-12-15T17:10:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ryan\_Deardorff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_deardorff/32/63815_2.png) [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\
**Post date:** [December 15, 2025, 5:10pm UTC](https://forum.inductiveautomation.com/t/bug-unsigned-smallint-throws-query-exception/112815/1 "2025-12-15T17:10:58Z")

</div>

I have an unsigned SMALLINT column in my MySQL database. Querying via Ignition doesn’t work because it’s using `java.lang.Short` which only supports the range for a signed value.

> Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Value '42222' is outside of valid range for type java.lang.Short

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [December 15, 2025, 5:25pm UTC](https://forum.inductiveautomation.com/t/bug-unsigned-smallint-throws-query-exception/112815/2 "2025-12-15T17:25:31Z")

</div>

Hm. _Unsigned_ smallint appears to be a vendor extension we/Java didn't anticipate, especially since Java doesn't have native unsigned types.

We might be able to do something about it, but it won't be any time soon...

Just change the type to INT?

---

<div class="post-metadata">

**Author:** ![Ryan\_Deardorff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_deardorff/32/63815_2.png) [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\
**Post date:** [December 15, 2025, 5:29pm UTC](https://forum.inductiveautomation.com/t/bug-unsigned-smallint-throws-query-exception/112815/3 "2025-12-15T17:29:33Z")

</div>

It’s not really a problem for my current use case. Our acceptable values won’t actually be over 32,000 so I can just validate against that instead of changing the type.