<div dir="ltr">Actually only a few RDBMS implements Boolean data type since it isn't SQL ANSI.</div><br><div class="gmail_quote">On Thu, May 21, 2015 at 2:33 PM Schneider, John DODGE CONSULTING SERVICES, LLC <<a href="mailto:John.Schneider@carrier.utc.com">John.Schneider@carrier.utc.com</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="white" lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="color:#1f497d">Thanks Marek.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">I created KEYCLOAK-1336. I’m using the free SQL Server Express 2008 R2 in my sandbox, but the same issue should exist in any MS SQL Server version as it handles Booleans differently than most other RDBMS’.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">John<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext"> Marek Posolda [mailto:<a href="mailto:mposolda@redhat.com" target="_blank">mposolda@redhat.com</a>]
<br>
<b>Sent:</b> Thursday, May 21, 2015 2:23 AM<br>
<b>To:</b> Schneider, John DODGE CONSULTING SERVICES, LLC; <a href="mailto:keycloak-user@lists.jboss.org" target="_blank">keycloak-user@lists.jboss.org</a><br>
<b>Subject:</b> [External] Re: [keycloak-user] Error upgrading MS SQL database from 1.1 Final to 1.2 Final<u></u><u></u></span></p>
</div>
</div></div></div><div bgcolor="white" lang="EN-US" link="blue" vlink="purple"><div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Hi,<br>
<br>
This looks like a bug, it seems that MS SQL server doesn't know what the 'true' is, so the SQL statement used here
<a href="https://github.com/keycloak/keycloak/blob/master/connections/jpa-liquibase/src/main/java/org/keycloak/connections/jpa/updater/liquibase/custom/JpaUpdate1_2_0_CR1.java#L20" target="_blank">
https://github.com/keycloak/keycloak/blob/master/connections/jpa-liquibase/src/main/java/org/keycloak/connections/jpa/updater/liquibase/custom/JpaUpdate1_2_0_CR1.java#L20</a> is failing
<span>:-( </span><br>
<br>
Could you create JIRA for it please? Btv. which version of MS SQL server are you using?<br>
<br>
Thanks,<br>
Marek<br>
<br>
On 20.5.2015 20:16, Schneider, John DODGE CONSULTING SERVICES, LLC wrote:<u></u><u></u></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Hi all,<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">I was excited to find out 1.2 was released and tried to upgrade my sandbox environment from 1.1 today. I already had 1.1 deployed as a Wildlfly module, and extracted the 1.2 overlay edition along with the 1.2 Wildfly adapter.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">The database update was chugging along fine for a bit, but did hit an error. It seems to be an SQL dialect problem. Because of company policies, I’m forced to use MS SQL, and am using the JDBC 41 driver deployed as a Wildfly module. I’ve
attached the relevant log output, starting from the beginning of the database update. I did take a DB backup before starting, so I can restore and replicate the update process from the beginning again.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Could you please take a look and let me know what I can do?<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
<p class="MsoNormal">John<u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><br>
<br>
<br>
<u></u><u></u></span></p>
<pre>_______________________________________________<u></u><u></u></pre>
<pre>keycloak-user mailing list<u></u><u></u></pre>
<pre><a href="mailto:keycloak-user@lists.jboss.org" target="_blank">keycloak-user@lists.jboss.org</a><u></u><u></u></pre>
<pre><a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" target="_blank">https://lists.jboss.org/mailman/listinfo/keycloak-user</a><u></u><u></u></pre>
</blockquote>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><u></u> <u></u></span></p>
</div></div>
_______________________________________________<br>
keycloak-user mailing list<br>
<a href="mailto:keycloak-user@lists.jboss.org" target="_blank">keycloak-user@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" target="_blank">https://lists.jboss.org/mailman/listinfo/keycloak-user</a></blockquote></div>