Problem:
2017-08-30 17:31:49.708 WARN 4720 — [ XNIO-2 task-20] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: S1093
2017-08-30 17:31:49.710 ERROR 4720 — [ XNIO-2 task-20] o.h.engine.jdbc.spi.SqlExceptionHelper : The index 1 is out of range.
2017-08-30 17:31:49.714 ERROR 4720 — [ XNIO-2 task-20] o.y.tor.aop.logging.LoggingAspect : Exception in org.yarisoft.tor.web.rest.PlanResource.getAllPlans() with cause = ‘org.hibernate.exception.GenericJDBCException: could not execute query’ and exception = ‘could not execute query; nested exception is org.hibernate.exception.GenericJDBCException: could not execute query’
Solution:
<hibernate.version>5.2.7.Final</hibernate.version>
In file pom.xml
.
Problem:
MS SQL nhibernate by default generate varchar fields instead nvarchar
Solution;
Convert to nvarchar field definitions.
.