[keycloak-user] RealmEntity still not converted to UUID

[Marek Posolda]

Hi Dean,

which version of MS-SQL are you using? For me latest keycloak master 
works with MS-SQL 2012, but I have to manually change dialect. The 
default dialect org.hibernate.dialect.SQLServerDialect , which is 
autodetected by Hibernate doesn't work correctly due to columns with 
boolean types, I have to change it to use 
org.hibernate.dialect.SQLServer2008Dialect . Could you try in your 
environment?

You can either:
-- Add system property 
-Dhibernate.dialect=org.hibernate.dialect.SQLServer2008Dialect when 
starting server (In latest keycloak master, system properties could 
override what's set in persistence.xml)
-- Add this property to persistence.xml

If you have MS-SQL 2005, you can also try 
org.hibernate.dialect.SQLServer2005Dialect.

Good luck,
Marek

On 19.2.2014 09:30, Marek Posolda wrote:
> Thanks for looking into databases. Right now, Keycloak should work on 
> MySQL, PostgreSQL, Oracle and Sybase. Still looking on MS-SQL and IBM 
> DB2 and I've created separate issue KEYCLOAK-303 
> <https://issues.jboss.org/browse/KEYCLOAK-303> for it, as it seems 
> that MS-SQL issue is not related to ID generation. I will reply once I 
> have luck with MS-SQL, so you can test in your environment.
>
> Thanks,
> Marek
>
> On 18.2.2014 21:59, Bill Burke wrote:
>> RealmEntity's ID is set manually and uses the same code as
>> JpaIdGenerator.  I think Marek is looking into MSSQL.
>>
>> On 2/18/2014 3:49 PM, Dean Peterson wrote:
>>> Hello,
>>>
>>> I realize you are still in development for the alpha2 release.  Thank
>>> you for making the change to UUID rather than Identity String columns.
>>>    I noticed I can now deploy to a Postgresql database but I still fail
>>> on MSSQL because the RealmEntity class has not been converted to use the
>>> new identity mechanism.  I am sure this would have been updated before
>>> alpha2 was released but I wanted to bring some attention to it just in case.
>>>
>>> Thanks,
>>>
>>> Dean
>>>
>>>
>>> _______________________________________________
>>> 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/20140219/fe8848e9/attachment.html