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

Object Partners profile.
Leave a Reply

Your email address will not be published.

Related Blog Posts
Natively Compiled Java on Google App Engine
Google App Engine is a platform-as-a-service product that is marketed as a way to get your applications into the cloud without necessarily knowing all of the infrastructure bits and pieces to do so. Google App […]
Building Better Data Visualization Experiences: Part 2 of 2
If you don't have a Ph.D. in data science, the raw data might be difficult to comprehend. This is where data visualization comes in.
Unleashing Feature Flags onto Kafka Consumers
Feature flags are a tool to strategically enable or disable functionality at runtime. They are often used to drive different user experiences but can also be useful in real-time data systems. In this post, we’ll […]
A security model for developers
Software security is more important than ever, but developing secure applications is more confusing than ever. TLS, mTLS, RBAC, SAML, OAUTH, OWASP, GDPR, SASL, RSA, JWT, cookie, attack vector, DDoS, firewall, VPN, security groups, exploit, […]