Import Garmin Calendar Into Google Calendar

Garmin Connect Calendar is a pretty neat feature where it allows you to plan your workouts days, weeks, or months ahead. However it does not come with a good sharing feature as you will have to download the calendar in order to share it with others.

This is where Google Calendar comes handy.

Continue reading “Import Garmin Calendar Into Google Calendar” »

Spring Boot + Spring JPA: Fix Hibernate Dialect Mapping Error

Hibernate with Spring JPA along with Spring Boot makes it easy for user to manage their database connection. However there are certain column type that is not mapped by default by Hibernate. For an example column type nvarchar in MSSQL could lead to an exception.

Hibernate with Spring JPA along with Spring Boot makes it easy for user to manage their database connection. However there are certain column type that is not mapped by default by Hibernate. For an example column type nvarchar in MSSQL could lead to an exception.

....
Exception [org.hibernate.MappingException: No Dialect mapping for JDBC type: -9] org.hibernate.dialect.TypeNames.get(TypeNames.java:77)
org.hibernate.dialect.TypeNames.get(TypeNames.java:100)
org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:378)
org.hibernate.loader.custom.CustomLoader$Metadata.getHibernateType(CustomLoader.java:590)
org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.performDiscovery(CustomLoader.java:516)
org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:532)
org.hibernate.loader.Loader.getResultSet(Loader.java:1962)
org.hibernate.loader.Loader.doQuery(Loader.java:802)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
org.hibernate.loader.Loader.doList(Loader.java:2542)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
org.hibernate.loader.Loader.list(Loader.java:2271)
org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
....
view raw nvarchar.error.log hosted with ❤ by GitHub

Continue reading “Spring Boot + Spring JPA: Fix Hibernate Dialect Mapping Error” »