[keycloak-user] SQL Server 2014 DB throws error at time of user hetch

[Vlasta Ramik]

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,
>
> Description: cid:image001.jpg at 01D065A7.375670A0 <http://www.majesco.com/>
>
> 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 <http://www.majesco.com/>
>
>
>
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-user/attachments/20160517/252ed4e7/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 19294 bytes
Desc: not available
Url : http://lists.jboss.org/pipermail/keycloak-user/attachments/20160517/252ed4e7/attachment-0001.jpe