"connectionsJpa": {

        "default": {

            "driverDialect": "org.hibernate.dialect.SQLServer2012Dialect",

            "dataSource": "java:jboss/datasources/KeycloakDS",

            ...

        }

    },

Hi Jitendra,

the issue is fixed in 1.9.2.Final.

see https://github.com/keycloak/keycloak/pull/2352/files

The cause is that Hibernate doesn't detect correct dialect for MSSQL2014, which is causing some incorrectly generated SQL queries. In 1.9.2.Final is auto-detected dialect overridden.

Vlasta

On 05/17/2016 03:25 PM, Jitendra P Biswal wrote:

Hi All,

I am using keycloak-1.9.0.Final version and configured it to point SQL Server 2014.

I was able to create new realm and  create user under the realm

But, when I am click on view all users getting error. Server log attached.

Anybody have any solution please help.

 

 

 

Thanks & Regards,

 

 

Jitendra Biswal / Software Specialist

Majesco, Majesco New Development Centre, MBP-P–136,136A, Mahape, Navi Mumbai - 400 710
Phone: +91 22 6150 1800 Ext 5698
http://www.majesco.com

 

_______________________________________________
keycloak-user mailing list
keycloak-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user

_______________________________________________
keycloak-user mailing list
keycloak-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user