# java.sql.SQLException: precision or scale out of range.

**URL:** <https://forum.servoy.com/t/java-sql-sqlexception-precision-or-scale-out-of-range/18085>\
**Category:** Classic Servoy\
**Created:** [July 25, 2014, 12:50am UTC](https://forum.servoy.com/t/java-sql-sqlexception-precision-or-scale-out-of-range/18085 "2014-07-25T00:50:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![marbeisol](https://avatars.discourse-cdn.com/v4/letter/m/ecd19e/32.png) [@marbeisol](https://forum.servoy.com/u/marbeisol)\
**Post date:** [July 25, 2014, 12:50am UTC](https://forum.servoy.com/t/java-sql-sqlexception-precision-or-scale-out-of-range/18085/1 "2014-07-25T00:50:29Z")

</div>

Hello everyone!!

I am using Servoy 7.4.1, and now I have a issue using this:  
databaseManager.createDataSourceByQuery(“myDs”, ‘myserver’,‘select usuario, nombre from user’,null,-1)  
I am getting the following message:  
Wrapped java.lang.RuntimeException: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: precision or scale out of range.

before update the version of servoy this work well, I do not know what happened.  
it does not matter, datatype that I use, or the table of database, I get the same error.

In addition when I test using databaseManager.getDataSetByQuery(‘myserver’,',‘select usuario, nombre from user’,null,-1)  
I get the data correctly.

Any ideas ?

Thanks for advance.