Jbpm The "variant" data type is not supported.

[maniac787]

Hello, please I need help about this.

I am testing Jbpm 7 with sql server 2014, but when I start the demo I see this log.

Caused by: org.hibernate.exception.JDBCConnectionException: Unable to build DatabaseInformation

        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115)

        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)

        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)

        at org.hibernate.tool.schema.internal.Helper.buildDatabaseInformation(Helper.java:138)

        at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:92)

        at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:176)

        at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)

        at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:459)

        at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:465)

        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:880)

        ... 26 more

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The "variant" data type is not supported.

        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)

[abhijithumbe]

Can you let us know what operation you are trying to perform ?  Are you trying to list the DB details like productversion,..etc ? Share steps you are following.

[maniac787]

Thanks, I solved the problem, the inconvenience was that I did not configure the jpa file

[andy-li]

the jpa file is located in which directory and how i  configure that file,pls,the same issue i had meet

[andy-li]

please help me,give me the reference about the jpa file setting.