Tiny int of MySQL to Integer in Java

Question

I have an tiny int column in MySQL. I want to convert it into int type of java.

So if I mention the column in my hibernate entity as

@Column(name="Columname")
private int something;

Will it cause an error as tiny int needs boolean type or will it get cast into int?

This code will be changed in production Db hence I cannot check it to see if it breaks.

Test it on your own, local database. If it works fine, then only think about applying the change to production. You won't ask us for every little thing, won't you? — JB Nizet
– JB Nizet, Commented Jul 9, 2014 at 8:54
It works on local. I just hope there aren't any use cases I am missing . Thanks though. — Mayank_Thapliyal
– Mayank_Thapliyal, Commented Jul 9, 2014 at 9:06
Should be no problem, explicitly mentioned int - BIT(1) compatibility: dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-mappings.html — Joop Eggen
– Joop Eggen, Commented Jul 9, 2014 at 9:09
Can you please write in answer section so that I canmark it as correct answer?:) — Mayank_Thapliyal
– Mayank_Thapliyal, Commented Jul 9, 2014 at 9:17

PVR · Accepted Answer · 2016-09-27 13:30:32Z

4

JDBC driver maps databse type to java. So in case of mysql TINYINT will be converted to java.lang.Boolean or java.lang.Integer.

Refer this link which explains : Java, JDBC and MySQL Types

answered Sep 27, 2016 at 13:30

PVR

9159 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Here is an updated link to what @PVR was probably referring to

Vishal_Kotecha · Accepted Answer · 2014-07-09 09:01:30Z

4

Go for the datatype Byte. it worked for me!

answered Jul 9, 2014 at 9:01

Vishal_Kotecha

4906 silver badges21 bronze badges