[keycloak-user] SQL exception on password recovery

Marek Posolda mposolda at redhat.com
Thu May 28 01:46:10 EDT 2015


It seems that you're trying to add user, which already exists in DB. Can 
it be the case?

If you want to update user, which already exists, you can instead use 
something like:

UserModel user = session.userStorage().getUserByUsername("krenfro", realm);
user.setFirstName("anything");
...


Marek

On 27.5.2015 23:08, Kyle Renfro wrote:
> I've deleted the db and started over.  In my custom federation 
> provider, I changed the method I was using to add the user to the 
> keycloak database from:
>      UserModel addUser(RealmModel realm, String id, String username, 
> boolean addDefaultRoles);
> to:
>      UserModel addUser(RealmModel realm, String username);
>
> Reference: 
> https://github.com/keycloak/keycloak/blob/1a433093339e40ec0272c827f8d4327fa7dbcae2/model/api/src/main/java/org/keycloak/models/UserProvider.java
>
> This didn't make a significant difference, but the error message is a 
> bit different:
> 15:43:53,989 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] 
> (default task-96) SQL Error: 1062, SQLState: 23000
> 15:43:53,989 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] 
> (default task-96) Duplicate entry 
> '872ff877-eea2-4d37-942e-e066690b136b-krenfro' for key 
> 'UK_RU8TT6T700S9V50BU18WS5HA6'
> ...
>
> The UK_RU8TT6T700S9V50BU18WS5HA6 key is only defined in the 
> USER_ENTITY table.
>
> mysql> show indexes from USER_ENTITY;
> +-------------+------------+------------------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
> | Table       | Non_unique | Key_name     | Seq_in_index | Column_name 
>      | Collation | Cardinality | Sub_part | Packed | Null | Index_type 
> | Comment | Index_comment |
> +-------------+------------+------------------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
> | USER_ENTITY |          0 | PRIMARY      |            1 | ID         
>       | A         |     885 |     NULL | NULL   |      | BTREE      | 
>   |               |
> | USER_ENTITY |          0 | UK_DYKN684SL8UP1CRFEI6ECKHD7 |           
>  1 | REALM_ID       | A         |        NULL |     NULL | NULL   | 
> YES  | BTREE      |         |               |
> | USER_ENTITY |          0 | UK_DYKN684SL8UP1CRFEI6ECKHD7 |           
>  2 | EMAIL_CONSTRAINT | A         |        NULL |     NULL | NULL   | 
> YES  | BTREE      |         |               |
> | USER_ENTITY |          0 | UK_RU8TT6T700S9V50BU18WS5HA6 |           
>  1 | REALM_ID       | A         |        NULL |     NULL | NULL   | 
> YES  | BTREE      |         |               |
> | USER_ENTITY |          0 | UK_RU8TT6T700S9V50BU18WS5HA6 |           
>  2 | USERNAME       | A         |        NULL |     NULL | NULL   | 
> YES  | BTREE      |         |               |
> +-------------+------------+------------------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
>
> The 872ff877-eea2-4d37-942e-e066690b136b is the realm_id in the 
> 'krenfro' record.
>
> thanks,
> Kyle
>
> On Wed, May 27, 2015 at 9:31 AM, Kyle Renfro <krenfro at real-comp.com 
> <mailto:krenfro at real-comp.com>> wrote:
>
>     Keycloak 1.2.0-Final
>
>     I am evaluating Keycloak, and so far I am very impressed.  I have
>     made good progress implementing a custom federation provider.  I
>     have full and periodic syncing implemented and all is working
>     except password recovery using an e-mail address.  Password
>     recovery with a username works.  I'm not sure if my custom
>     provider is getting in the way.
>
>     From the logs:
>     ...
>     Caused by:
>     com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
>     Duplicate entry '1' for key 'PRIMARY'
>
>     Here is the the record from the keycloak SQL database I am
>     attempting pw recovery on:
>
>     *mysql> select * from USER_ENTITY where id = 1;*
>     +----+-----------------------+-----------------------+----------------+---------+--------------------------------------+------------+-------------+--------------------------------------+------+----------+
>     | ID | EMAIL                 | EMAIL_CONSTRAINT      |
>     EMAIL_VERIFIED | ENABLED | FEDERATION_LINK  | FIRST_NAME |
>     LAST_NAME   | REALM_ID                     | TOTP | USERNAME |
>     +----+-----------------------+-----------------------+----------------+---------+--------------------------------------+------------+-------------+--------------------------------------+------+----------+
>     | 1  | krenfro at real-comp.com <mailto:krenfro at real-comp.com> |
>     krenfro at real-comp.com <mailto:krenfro at real-comp.com> |            
>      |       | 7675cab9-ad38-420c-aa1f-df7a869c50bb | NULL     | Kyle
>     Renfro | 893a55ff-7aac-448f-b7b6-704a26997dfe |      | krenfro  |
>     +----+-----------------------+-----------------------+----------------+---------+--------------------------------------+------------+-------------+--------------------------------------+------+----------+
>     1 row in set, 1 warning (0.00 sec)
>
>
>     There is a SQL warning, not sure if it is related:
>     *mysql> show warnings;*
>     +---------+------+--------------------------------------------------------------------------+
>     | Level   | Code | Message    |
>     +---------+------+--------------------------------------------------------------------------+
>     | Warning | 1292 | Truncated incorrect DOUBLE value:
>     '7cd31fee-2398-46cc-92d9-58eae6b32fb2' |
>     +---------+------+--------------------------------------------------------------------------+
>     1 row in set (0.00 sec)
>
>
>     If deleting the db and starting from scratch is recommended, that
>     is fine.
>
>     Thanks in advance!
>     Kyle
>
>
>
>
>     *Here is full stack trace and keycloak logs:*
>     09:14:13,886 WARN
>      [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default
>     task-109) SQL Error: 1062, SQLState: 23000
>     09:14:13,887 ERROR
>     [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default
>     task-109) Duplicate entry '1' for key 'PRIMARY'
>     09:14:13,887 INFO
>      [org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl]
>     (default task-109) HHH000010: On release of batch it still
>     contained JDBC statements
>     09:14:13,888 ERROR [io.undertow.request] (default task-109)
>     UT005023: Exception handling request to
>     /auth/realms/test/login-actions/password-reset:
>     java.lang.RuntimeException: request path:
>     /auth/realms/test/login-actions/password-reset
>     at
>     org.keycloak.services.filters.KeycloakSessionServletFilter.doFilter(KeycloakSessionServletFilter.java:54)
>     [keycloak-services-1.2.0.Final.jar:1.2.0.Final]
>     at
>     io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
>     at
>     io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
>     [undertow-core-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
>     [undertow-core-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45)
>     [undertow-core-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:63)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)
>     [undertow-core-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)
>     [undertow-core-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
>     [undertow-core-1.1.0.Final.jar:1.1.0.Final]
>     at
>     org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
>     at
>     io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
>     [undertow-core-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
>     [undertow-core-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:247)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:76)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:166)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.server.Connectors.executeRootHandler(Connectors.java:197)
>     [undertow-core-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:759)
>     [undertow-core-1.1.0.Final.jar:1.1.0.Final]
>     at
>     java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
>     [rt.jar:1.7.0_80]
>     at
>     java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
>     [rt.jar:1.7.0_80]
>     at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_80]
>     Caused by: org.jboss.resteasy.spi.UnhandledException:
>     org.keycloak.models.ModelDuplicateException:
>     javax.persistence.PersistenceException:
>     org.hibernate.exception.ConstraintViolationException: could not
>     execute statement
>     at
>     org.jboss.resteasy.core.ExceptionHandler.handleApplicationException(ExceptionHandler.java:76)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at
>     org.jboss.resteasy.core.ExceptionHandler.handleException(ExceptionHandler.java:212)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at
>     org.jboss.resteasy.core.SynchronousDispatcher.writeException(SynchronousDispatcher.java:149)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at
>     org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:372)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at
>     org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at
>     org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at
>     org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at
>     org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
>     [jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final]
>     at
>     io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     org.keycloak.services.filters.ClientConnectionFilter.doFilter(ClientConnectionFilter.java:41)
>     [keycloak-services-1.2.0.Final.jar:1.2.0.Final]
>     at
>     io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)
>     [undertow-servlet-1.1.0.Final.jar:1.1.0.Final]
>     at
>     org.keycloak.services.filters.KeycloakSessionServletFilter.doFilter(KeycloakSessionServletFilter.java:40)
>     [keycloak-services-1.2.0.Final.jar:1.2.0.Final]
>     ... 28 more
>     Caused by: org.keycloak.models.ModelDuplicateException:
>     javax.persistence.PersistenceException:
>     org.hibernate.exception.ConstraintViolationException: could not
>     execute statement
>     at
>     org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:40)
>     [keycloak-connections-jpa-1.2.0.Final.jar:1.2.0.Final]
>     at
>     org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:34)
>     [keycloak-connections-jpa-1.2.0.Final.jar:1.2.0.Final]
>     at com.sun.proxy.$Proxy52.flush(Unknown Source)
>     at
>     org.keycloak.models.jpa.JpaUserProvider.addUser(JpaUserProvider.java:57)
>     [keycloak-model-jpa-1.2.0.Final.jar:1.2.0.Final]
>     at
>     org.keycloak.models.cache.DefaultCacheUserProvider.addUser(DefaultCacheUserProvider.java:254)
>     [keycloak-invalidation-cache-model-1.2.0.Final.jar:1.2.0.Final]
>     at
>     com.realcomp.keycloak.UserServiceFederationProvider.importUser(UserServiceFederationProvider.java:249)
>     at
>     com.realcomp.keycloak.UserServiceFederationProvider.getUserByUsername(UserServiceFederationProvider.java:276)
>     at
>     org.keycloak.models.UserFederationManager.getUserByUsername(UserFederationManager.java:155)
>     [keycloak-model-api-1.2.0.Final.jar:1.2.0.Final]
>     at
>     org.keycloak.services.resources.LoginActionsService.sendPasswordReset(LoginActionsService.java:908)
>     [keycloak-services-1.2.0.Final.jar:1.2.0.Final]
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     [rt.jar:1.7.0_80]
>     at
>     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>     [rt.jar:1.7.0_80]
>     at
>     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>     [rt.jar:1.7.0_80]
>     at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_80]
>     at
>     org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at
>     org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at
>     org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at
>     org.jboss.resteasy.core.ResourceLocatorInvoker.invokeOnTargetObject(ResourceLocatorInvoker.java:140)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at
>     org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:103)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     at
>     org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
>     [resteasy-jaxrs-3.0.10.Final.jar:]
>     ... 39 more
>     Caused by: javax.persistence.PersistenceException:
>     org.hibernate.exception.ConstraintViolationException: could not
>     execute statement
>     at
>     org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
>     [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
>     [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1683)
>     [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1338)
>     [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     [rt.jar:1.7.0_80]
>     at
>     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>     [rt.jar:1.7.0_80]
>     at
>     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>     [rt.jar:1.7.0_80]
>     at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_80]
>     at
>     org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:32)
>     [keycloak-connections-jpa-1.2.0.Final.jar:1.2.0.Final]
>     ... 56 more
>     Caused by: org.hibernate.exception.ConstraintViolationException:
>     could not execute statement
>     at
>     org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:72)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     at
>     org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1335)
>     [hibernate-entitymanager-4.3.7.Final.jar:4.3.7.Final]
>     ... 61 more
>     Caused by:
>     com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
>     Duplicate entry '1' for key 'PRIMARY'
>     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>     Method) [rt.jar:1.7.0_80]
>     at
>     sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
>     [rt.jar:1.7.0_80]
>     at
>     sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>     [rt.jar:1.7.0_80]
>     at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
>     [rt.jar:1.7.0_80]
>     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
>     at com.mysql.jdbc.Util.getInstance(Util.java:386)
>     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
>     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
>     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
>     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
>     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2624)
>     at
>     com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2127)
>     at
>     com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2427)
>     at
>     com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2345)
>     at
>     com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2330)
>     at
>     org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
>     at
>     org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:208)
>     [hibernate-core-4.3.7.Final.jar:4.3.7.Final]
>     ... 71 more
>
>
>
>
>
>
> _______________________________________________
> 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/20150528/da700de7/attachment-0001.html 


More information about the keycloak-user mailing list