Problem when wanting to mapping values from MySQL query to Object in JAVA but MySQL Query returns NULL
If Application is written in spring boot with JDBCTemplate and mapping to Object, the exception will occur.
org.springframework.beans.TypeMismatchException
can be solved by use IFNULL
SELECT IFNULL(emp_id,0) FROM emp WHERE 1=0;
Output
0
Reference:
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
https://www.w3schools.com/sql/func_mysql_ifnull.asp
For further actions, you may consider blocking this person and/or reporting abuse
Timeless DEV post...
The most used technology by developers is not Javascript.
It's not Python or HTML.
It hardly even gets mentioned in interviews or listed as a pre-requisite for jobs.
I'm talking about Git and version control of course.
Wojtek Krzywiec -
Ethan -
NaveenKumar Namachivayam ⚡ -
nabbisen -
Once suspended, goffity will not be able to comment or publish posts until their suspension is removed.
Once unsuspended, goffity will be able to comment and publish posts again.
Once unpublished, all posts by goffity will become hidden and only accessible to themselves.
If goffity is not suspended, they can still re-publish their posts from their dashboard.
Once unpublished, this post will become invisible to the public and only accessible to Goffity Corleone.
They can still re-publish the post if they are not suspended.
Thanks for keeping DEV Community safe. Here is what you can do to flag goffity:
Unflagging goffity will restore default visibility to their posts.
Top comments (0)