<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
One more note. In wildfly, the dialect can be set in
$KEYCLOAK_HOME/standalone/configuration/keycloak-server.json like:
<p>
</p>
<table style="font-size: 1em; line-height: 1.4em !important;
font-weight: normal; font-style: normal; color: black;"
width="100%" border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr id="syntaxplugin_code_and_gutter">
<td style=" line-height: 1.4em !important; padding: 0em;
vertical-align: top;">
<pre style="font-size: 1em; margin: 0 10px; margin-top: 10px; width: auto; padding: 0;"><span style="color: black; font-family: 'Consolas', 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;"> "connectionsJpa": {</span></pre>
</td>
</tr>
<tr id="syntaxplugin_code_and_gutter">
<td style=" line-height: 1.4em !important; padding: 0em;
vertical-align: top;">
<pre style="font-size: 1em; margin: 0 10px; width: auto; padding: 0;"><span style="color: black; font-family: 'Consolas', 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;"> "default": {</span></pre>
</td>
</tr>
<tr id="syntaxplugin_code_and_gutter">
<td style=" line-height: 1.4em !important; padding: 0em;
vertical-align: top;">
<pre style="font-size: 1em; margin: 0 10px; width: auto; padding: 0;"><span style="color: black; font-family: 'Consolas', 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;"> "driverDialect": "org.hibernate.dialect.SQLServer2012Dialect",</span></pre>
</td>
</tr>
<tr id="syntaxplugin_code_and_gutter">
<td style=" line-height: 1.4em !important; padding: 0em;
vertical-align: top;">
<pre style="font-size: 1em; margin: 0 10px; width: auto; padding: 0;"><span style="color: black; font-family: 'Consolas', 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;"> "dataSource": "java:jboss/datasources/KeycloakDS",</span></pre>
</td>
</tr>
<tr id="syntaxplugin_code_and_gutter">
<td style=" line-height: 1.4em !important; padding: 0em;
vertical-align: top;">
<pre style="font-size: 1em; margin: 0 10px; width: auto; padding: 0;"><span style="color: black; font-family: 'Consolas', 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;"> ...</span></pre>
</td>
</tr>
<tr id="syntaxplugin_code_and_gutter">
<td style=" line-height: 1.4em !important; padding: 0em;
vertical-align: top;">
<pre style="font-size: 1em; margin: 0 10px; width: auto; padding: 0;"><span style="color: black; font-family: 'Consolas', 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;"> }</span></pre>
</td>
</tr>
<tr id="syntaxplugin_code_and_gutter">
<td style=" line-height: 1.4em !important; padding: 0em;
vertical-align: top;">
<pre style="font-size: 1em; margin: 0 10px; margin-bottom: 10px; width: auto; padding: 0;"><span style="color: black; font-family: 'Consolas', 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;"> },
</span></pre>
</td>
</tr>
</tbody>
</table>
<br>
<br>
<div class="moz-cite-prefix">On 05/17/2016 03:31 PM, Vlasta Ramik
wrote:<br>
</div>
<blockquote cite="mid:573B1D19.3060809@redhat.com" type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
Hi Jitendra,<br>
<br>
the issue is fixed in 1.9.2.Final. <br>
<br>
see <a moz-do-not-send="true" class="moz-txt-link-freetext"
href="https://github.com/keycloak/keycloak/pull/2352/files">https://github.com/keycloak/keycloak/pull/2352/files</a><br>
<br>
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.<br>
<br>
Vlasta<br>
<br>
<div class="moz-cite-prefix">On 05/17/2016 03:25 PM, Jitendra P
Biswal wrote:<br>
</div>
<blockquote
cite="mid:922da49bb89e4ecda8a1207d49a7a77a@ind-mhp1mbx1301.mastek.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi All, <o:p></o:p></p>
<p class="MsoNormal">I am using keycloak-1.9.0.Final version
and configured it to point <b>SQL Server 2014.<o:p></o:p></b></p>
<p class="MsoNormal">I was able to create new realm and
create user under the realm<o:p></o:p></p>
<p class="MsoNormal">But, when I am click on view all users
getting error. Server log attached.<o:p></o:p></p>
<p class="MsoNormal">Anybody have any solution please help.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks & Regards,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"
style="margin-bottom:7.5pt;background:white"><a
moz-do-not-send="true" href="http://www.majesco.com/"><span
style="font-size:7.5pt;font-family:"Helvetica","sans-serif";color:#24A939;text-decoration:none"><img
id="Picture_x0020_1"
src="cid:part2.05070805.05090807@redhat.com"
alt="Description: cid:image001.jpg@01D065A7.375670A0"
height="29" width="150" border="0"></span></a><span
style="color:#282828"> </span><o:p></o:p></p>
<p class="MsoNormal" style="background:#FEFEFE"><span
style="font-size:10.0pt;color:black">Jitendra Biswal</span><span
style="font-size:10.0pt;color:#212121"> </span><span
style="font-size:10.0pt;color:black">/ </span><span
style="font-size:10.0pt;font-family:"Times New
Roman","serif";color:black">Software
Specialist</span><span
style="font-size:10.0pt;color:#545454"> </span><span
style="font-size:10.0pt;color:#212121"><br>
<br>
</span><b><span
style="font-size:10.0pt;color:black;mso-fareast-language:EN-IN">Majesco,</span></b><span
style="font-size:10.0pt;color:black;mso-fareast-language:EN-IN"> </span><span
style="font-size:10.0pt;color:black">Majesco New
Development Centre</span><span
style="font-size:10.0pt;color:black;mso-fareast-language:EN-IN">,
</span><span style="font-size:10.0pt;color:black">MBP-P–136,136A,
Mahape,</span><span
style="font-size:10.0pt;color:black;mso-fareast-language:EN-IN">
Navi Mumbai - 400 710<br>
Phone: +91 22 6150 1800 Ext 5698<br>
</span><span
style="font-size:10.0pt;color:#17365D;mso-fareast-language:EN-IN"><a
moz-do-not-send="true" href="http://www.majesco.com/"><span
style="color:#17365D"></span></a><a
moz-do-not-send="true" class="moz-txt-link-freetext"
href="http://www.majesco.com"><a class="moz-txt-link-freetext" href="http://www.majesco.com">http://www.majesco.com</a></a></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
keycloak-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/keycloak-user">https://lists.jboss.org/mailman/listinfo/keycloak-user</a></pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
keycloak-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a>
<a class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/keycloak-user">https://lists.jboss.org/mailman/listinfo/keycloak-user</a></pre>
</blockquote>
<br>
</body>
</html>