<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">I figured it out myself. No need to reply.<div class=""><br class=""></div><div class=""><br class="">
<br class=""><div><blockquote type="cite" class=""><div class="">On Jan 11, 2016, at 6:36 PM, Scott Rossillo <<a href="mailto:srossillo@smartling.com" class="">srossillo@smartling.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">I published the full code if that’s easier to look at.</div><div class=""><br class=""></div><div class="">Project: <a href="https://github.com/Smartling/keycloak-user-migration-provider" class="">https://github.com/Smartling/keycloak-user-migration-provider</a></div><div class=""><br class=""></div><div class="">Federation Provider: <a href="https://github.com/Smartling/keycloak-user-migration-provider/blob/master/user-migration-federation-provider/src/main/java/com/smartling/keycloak/provider/RemoteUserFederationProvider.java" class="">https://github.com/Smartling/keycloak-user-migration-provider/blob/master/user-migration-federation-provider/src/main/java/com/smartling/keycloak/provider/RemoteUserFederationProvider.java</a></div><div class=""><br class=""></div><div class="">Any help would be greatly appreciated with the exception below.</div><div class=""><br class=""></div><div class="">Best,</div><div class="">Scott</div><a href="http://www.sigstr.com/" style="font-family: gesta, Arial, Helvetica, sans-serif; font-size: 14px; widows: 1; box-sizing: border-box; color: rgb(0, 124, 194); text-decoration: none; outline: 0px !important;" class=""><img alt="Powered by Sigstr" border="0" src="https://app.sigstr.com/uc/55e5d41c6533390d03580000/watermark" style="box-sizing: border-box; border: 0px; vertical-align: top; max-width: 100%; height: auto; width: inherit; color: rgb(99, 99, 99); font-family: Helvetica; font-size: 11px;" class=""></a><br class="">
<br class=""><div class=""><blockquote type="cite" class=""><div class="">On Jan 11, 2016, at 12:39 PM, Scott Rossillo <<a href="mailto:srossillo@smartling.com" class="">srossillo@smartling.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">Hey,<br class=""><br class="">I’m trying to publish an example of how to do on demand user migration using a federation provider. It’s a modified version of what we use on an older Keycloak version. The error I’m getting (with H2, Keycloak 1.7.0 out-of-the-box) is below.<br class=""><br class="">At the time the exception is thrown, Kecyloak hasn’t attempted to validate credentials yet.<br class=""><br class="">It has only called these methods:<br class="">- UserModel getUserByUsername(RealmModel realm, String username);<br class="">- public boolean isValid(RealmModel realm, UserModel local);<br class=""><br class="">After calling session.users().addUser() am I supposed to release something?<br class=""><br class="">Thanks,<br class="">Scott<br class=""><br class="">-------<br class=""><br class="">Methods:<br class=""><br class="">@Override<br class="">public UserModel getUserByUsername(RealmModel realm, String username) { {<br class=""><br class=""> String username = rawUsername.toLowerCase().trim();<br class=""> FederatedUserModel remoteUser = federatedUserService.getUserDetails(username);<br class=""> LOG.infof("Creating user model for: %s", username);<br class=""> UserModel userModel = session.users().addUser(realm, username);<br class=""><br class=""> if (!username.equals(remoteUser.getEmail())) {<br class=""> throw new IllegalStateException(String.format("Local and remote users differ: [%s != %s]", username, remoteUser.getUsername()));<br class=""> }<br class=""><br class=""> userModel.setFederationLink(model.getId());<br class=""> userModel.setEnabled(remoteUser.isEnabled());<br class=""> userModel.setEmail(username);<br class=""> userModel.setEmailVerified(remoteUser.isEmailVerified());<br class=""> userModel.setFirstName(remoteUser.getFirstName());<br class=""> userModel.setLastName(remoteUser.getLastName());<br class=""><br class=""> if (remoteUser.getAttributes() != null) {<br class=""> Map<String, List<String>> attributes = remoteUser.getAttributes();<br class=""> for (String attributeName : attributes.keySet())<br class=""> userModel.setAttribute(attributeName, attributes.get(attributeName));<br class=""> }<br class=""><br class=""> if (remoteUser.getRoles() != null) {<br class=""> for (String role : remoteUser.getRoles()) {<br class=""> RoleModel roleModel = realm.getRole(role);<br class=""> if (roleModel != null) {<br class=""> userModel.grantRole(roleModel);<br class=""> LOG.infof("Granted user %s, role %s", username, role);<br class=""> }<br class=""> }<br class=""> }<br class=""><br class=""> return userModel;<br class="">}<br class=""><br class="">@Override<br class="">public boolean isValid(RealmModel realm, UserModel local)<br class="">{<br class=""> Response response = federatedUserService.validateUserExists(local.getUsername());<br class=""> return HttpStatus.SC_ACCEPTED == response.getStatus();<br class="">}<br class=""><br class="">Exception:<br class=""><br class="">2:13:51,497 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-88) SQL Error: 50200, SQLState: HYT00<br class="">12:13:51,498 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-88) Timeout trying to lock table "USER_ENTITY"; SQL statement:<br class="">select userentity0_.ID as ID1_46_, userentity0_.CREATED_TIMESTAMP as CREATED_2_46_, userentity0_.EMAIL as EMAIL3_46_, userentity0_.EMAIL_CONSTRAINT as EMAIL_CO4_46_, userentity0_.EMAIL_VERIFIED as EMAIL_VE5_46_, userentity0_.ENABLED as ENABLED6_46_, userentity0_.FEDERATION_LINK as FEDERATI7_46_, userentity0_.FIRST_NAME as FIRST_NA8_46_, userentity0_.LAST_NAME as LAST_NAM9_46_, userentity0_.REALM_ID as REALM_I10_46_, userentity0_.SERVICE_ACCOUNT_CLIENT_LINK as SERVICE11_46_, userentity0_.TOTP as TOTP12_46_, userentity0_.USERNAME as USERNAM13_46_ from USER_ENTITY userentity0_ where userentity0_.ID=? and userentity0_.REALM_ID=? [50200-173]<br class="">12:13:51,499 ERROR [org.keycloak.authentication.AuthenticationProcessor] (default task-88) failed authentication: javax.persistence.PessimisticLockException: could not extract ResultSet<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.jpa.spi.AbstractEntityManagerImpl.wrapLockException(AbstractEntityManagerImpl.java:1831)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1720)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:458)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.models.jpa.JpaUserProvider.getUserById(JpaUserProvider.java:260)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.models.cache.infinispan.DefaultCacheUserProvider.getUserById(DefaultCacheUserProvider.java:122)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.models.UserFederationManager.deleteInvalidUser(UserFederationManager.java:112)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.models.UserFederationManager.validateUser(UserFederationManager.java:100)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.models.UserFederationManager.validCredentials(UserFederationManager.java:409)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.authentication.authenticators.browser.AbstractUsernameFormAuthenticator.validatePassword(AbstractUsernameFormAuthenticator.java:152)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.authentication.authenticators.browser.AbstractUsernameFormAuthenticator.validateUserAndPassword(AbstractUsernameFormAuthenticator.java:128)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.authentication.authenticators.browser.UsernamePasswordForm.validateForm(UsernamePasswordForm.java:41)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.authentication.authenticators.browser.UsernamePasswordForm.action(UsernamePasswordForm.java:34)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.authentication.DefaultAuthenticationFlow.processAction(DefaultAuthenticationFlow.java:65)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.authentication.DefaultAuthenticationFlow.processAction(DefaultAuthenticationFlow.java:57)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.authentication.AuthenticationProcessor.authenticationAction(AuthenticationProcessor.java:744)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.services.resources.LoginActionsService.processFlow(LoginActionsService.java:299)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.services.resources.LoginActionsService.processAuthentication(LoginActionsService.java:280)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.services.resources.LoginActionsService.authenticateForm(LoginActionsService.java:326)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at java.lang.reflect.Method.invoke(Method.java:606)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.jboss.resteasy.core.ResourceLocatorInvoker.invokeOnTargetObject(ResourceLocatorInvoker.java:140)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:103)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:86)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:130)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.keycloak.services.filters.KeycloakSessionServletFilter.doFilter(KeycloakSessionServletFilter.java:61)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:60)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:132)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:85)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:72)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:282)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:261)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:80)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:172)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.server.Connectors.executeRootHandler(Connectors.java:199)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:774)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at java.lang.Thread.run(Thread.java:745)<br class="">Caused by: org.hibernate.PessimisticLockException: could not extract ResultSet<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.dialect.H2Dialect$2.convert(H2Dialect.java:342)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.loader.Loader.doQuery(Loader.java:910)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.loader.Loader.doList(Loader.java:2554)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.loader.Loader.doList(Loader.java:2540)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.loader.Loader.list(Loader.java:2365)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>... 62 more<br class="">Caused by: org.h2.jdbc.JdbcSQLException: Timeout trying to lock table "USER_ENTITY"; SQL statement:<br class="">select userentity0_.ID as ID1_46_, userentity0_.CREATED_TIMESTAMP as CREATED_2_46_, userentity0_.EMAIL as EMAIL3_46_, userentity0_.EMAIL_CONSTRAINT as EMAIL_CO4_46_, userentity0_.EMAIL_VERIFIED as EMAIL_VE5_46_, userentity0_.ENABLED as ENABLED6_46_, userentity0_.FEDERATION_LINK as FEDERATI7_46_, userentity0_.FIRST_NAME as FIRST_NA8_46_, userentity0_.LAST_NAME as LAST_NAM9_46_, userentity0_.REALM_ID as REALM_I10_46_, userentity0_.SERVICE_ACCOUNT_CLIENT_LINK as SERVICE11_46_, userentity0_.TOTP as TOTP12_46_, userentity0_.USERNAME as USERNAM13_46_ from USER_ENTITY userentity0_ where userentity0_.ID=? and userentity0_.REALM_ID=? [50200-173]<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.message.DbException.getJdbcSQLException(DbException.java:331)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.message.DbException.get(DbException.java:171)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.message.DbException.get(DbException.java:148)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.table.RegularTable.doLock(RegularTable.java:521)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.table.RegularTable.lock(RegularTable.java:455)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.table.TableFilter.lock(TableFilter.java:145)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.command.dml.Select.queryWithoutCache(Select.java:611)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.command.dml.Query.query(Query.java:314)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.command.dml.Query.query(Query.java:284)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.command.dml.Query.query(Query.java:36)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.command.CommandContainer.query(CommandContainer.java:91)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.command.Command.executeQuery(Command.java:195)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:106)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:504)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)<br class=""><span class="Apple-tab-span" style="white-space:pre"> </span>... 78 more<br class=""><br class=""><br class=""><br class=""></div></div></blockquote></div><br class=""></div></div></blockquote></div><br class=""></div></body></html>