MyBatis and Kotlin

I wanted to do a little sample application in Kotlin. I’m getting tired of using JPA for all the things, so I decided to try out MyBatis. I had used MyBatis with great success years ago, before it got configuration by annotations. And it has a Spring Boot starter, so that makes things even easier. It really went well until I added a lastUpdated field in my object. And then I got this error:

Caused by: org.apache.ibatis.executor.ExecutorException: No constructor 
found in com.objectpartners.demo.domain.Game matching [java.lang.Integer, java.lang.String, java.lang.Integer, java.sql.Timestamp]

After banging my head too long on it, the fix was pretty simple: Kotlin wasn’t able to coerce the java.sql.Timestamp that the JDBC driver was handing back into a java.time.LocalDateTime, so I just needed a constructor to help. Ironically the error tells you that but my Kotlin-fu is small. So I made this:

constructor( gameId: Int,
              name:String,
              bggId :Int ,
              sqlTimestamp: Timestamp): this(gameId,name,bggId,sqlTimestamp.toLocalDateTime())

Overall, Kotlin and MyBatis work really well together. You can see my (very) simple demo on GitHub.

About the Author

Mike Hostetler profile.

Mike Hostetler

Principal Technologist

Mike has almost 20 years of experience in technology. He started in networking and Unix administration, and grew into technical support and QA testing. But he has always done some development on the side and decided a few years ago to pursue it full-time. His history of working with users gives Mike a unique perspective on writing software.

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Blog Posts
Understanding Mutual TLS Options in the Public Cloud
When delivering an API over the public internet via a cloud provider, some organizations and frameworks require mutual TLS verification as a part of the interaction for that API. Mutual TLS can be used to […]
Performance Test Liquibase Update
When doing a liquibase update to a database if you’re having performance issues, it can be hard to find out which updates are causing problems. If you need to measure the time to apply each […]
TICK Stack Monitoring for the Non-Technical
TICK – Telegraf, Influx, Chronograf, and Kapacitor – is a method of monitoring your systems and applications. In this article, I discuss in non-technical terms what the difference is between TICK and Prometheus Grafana A […]
Design Systems, Part 1 • Introduction
Business leaders need a practical guide to plan and execute Design System Initiatives. The aim of this series is to be that guide. This installment introduces terms and definitions as a primer on Design Systems.