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

Vlasta Ramik vramik at redhat.com
Tue May 17 09:33:43 EDT 2016


One more note. In wildfly, the dialect can be set in 
$KEYCLOAK_HOME/standalone/configuration/keycloak-server.json like:

"connectionsJpa": {

"default": {

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

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

...

}

},



On 05/17/2016 03:31 PM, Vlasta Ramik wrote:
> 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
>
>
>
> _______________________________________________
> 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/b940e6d3/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/b940e6d3/attachment-0001.jpe 


More information about the keycloak-user mailing list