Hi,
Thanks in advance.
I’m building an app in Bubble.io but looking for superior data access and came across Chris’s walkthrough to connect Bubble.io to Boundless.
I’ve tried starting afresh but keep getting the same list of errors (see below - numerous calls not found)
Regards,
Paul
Backendless Version (3.x / 6.x, Online / Managed / Pro )
Cloud99 Trial
Client SDK (REST / Android / Objective-C / Swift / JS )
Bubble.io API
Application ID
E1DA68B9-121D-46B7-FF36-322DC0764700
Expected Behavior
Please describe the expected behavior of the issue, starting from the first action.
1.API Creation on Bubble.io / Pugins/API Connector
2.Populate API creation tools as per Chris’s walk through -
3.Bubble.io Database and Scalable Codeless Backend For Your App
Actual Behavior
On In initialising the following errors are produced on Bubble.io -
Raw response for the API
Status code 500
Backendless encountered an error while handling the request. An internal trouble ticket with ID 67076509-921B-5826-FF14-1730A35C2100 has been created and we will be investigating the issue.
org.hibernate.exception.SQLGrammarException: could not extract ResultSet
javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1542)
at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1581)
at com.backendless.datamodel.application.dao.UserDao.lambda$findDefault$3(UserDao.java:69)
at com.backendless.datamodel.dao.JpaContext.executeAppSync(JpaContext.java:138)
at com.backendless.datamodel.dao.JpaContext.executeAppSync(JpaContext.java:100)
at com.backendless.datamodel.application.dao.UserDao.findDefault(UserDao.java:68)
at com.backendless.datamodel.application.dao.UserDao.findDefaultUserId(UserDao.java:88)
at com.backendless.old.security.authorization.AuthorizationUserManager.setDefaultUserId(AuthorizationUserManager.java:151)
at com.backendless.old.security.authorization.AuthorizationUserManager.resumeSession(AuthorizationUserManager.java:109)
at com.backendless.gamification.AbstractGamificationInterceptor.invoke(AbstractGamificationInterceptor.java:39)
at com.backendless.old.security.Authorization.resumeSession(Authorization.java:101)
at com.backendless.old.security.ResumeSessionAction.call(ResumeSessionAction.java:50)
at com.backendless.old.security.OriginAction.call(OriginAction.java:48)
at com.backendless.old.security.ApplicationExistenceAndUseAction.call(ApplicationExistenceAndUseAction.java:38)
at com.backendless.old.security.ConsiderApiCallAction.call(ConsiderApiCallAction.java:29)
at com.backendless.TimeOutAction.call(TimeOutAction.java:28)
at com.backendless.old.security.SuperScalingAction.lambda$call$0(SuperScalingAction.java:26)
at com.backendless.services.billing.superscaling.SuperScalingManager.applyWithPolicies(SuperScalingManager.java:59)
at com.backendless.old.security.SuperScalingAction.call(SuperScalingAction.java:26)
at com.backendless.ApiCallLimitAction.call(ApiCallLimitAction.java:26)
at com.backendless.ApiCallAction.call(ApiCallAction.java:15)
at com.backendless.StaticHttpResponseHeadersAction.call(StaticHttpResponseHeadersAction.java:22)
at com.backendless.StackOverflowHandlerAction.call(StackOverflowHandlerAction.java:21)
at com.backendless.CloseEntityManagerAction.call(CloseEntityManagerAction.java:36)
at com.backendless.CurrentRequestsNumberAction.call(CurrentRequestsNumberAction.java:31)
at com.backendless.ContextInitAction.call(ContextInitAction.java:21)
at play.core.j.JavaAction.$anonfun$apply$8(JavaAction.scala:175)
at scala.concurrent.Future$.$anonfun$apply$1(Future.scala:659)
at scala.util.Success.$anonfun$map$1(Try.scala:255)
at scala.util.Success.map(Try.scala:213)
at scala.concurrent.Future.$anonfun$map$1(Future.scala:292)
at scala.concurrent.impl.Promise.liftedTree1$1(Promise.scala:33)
at scala.concurrent.impl.Promise.$anonfun$transform$1(Promise.scala:33)
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:64)
at play.core.j.HttpExecutionContext.$anonfun$execute$1(HttpExecutionContext.scala:64)
at play.api.libs.streams.Execution$trampoline$.execute(Execution.scala:70)
at play.core.j.HttpExecutionContext.execute(HttpExecutionContext.scala:59)
at scala.concurrent.impl.CallbackRunnable.executeWithValue(Promise.scala:72)
at scala.concurrent.impl.Promise$KeptPromise$Kept.onComplete(Promise.scala:372)
at scala.concurrent.impl.Promise$KeptPromise$Kept.onComplete$(Promise.scala:371)
at scala.concurrent.impl.Promise$KeptPromise$Successful.onComplete(Promise.scala:379)
at scala.concurrent.impl.Promise.transform(Promise.scala:33)
at scala.concurrent.impl.Promise.transform$(Promise.scala:31)
at scala.concurrent.impl.Promise$KeptPromise$Successful.transform(Promise.scala:379)
at scala.concurrent.Future.map(Future.scala:292)
at scala.concurrent.Future.map$(Future.scala:292)
at scala.concurrent.impl.Promise$KeptPromise$Successful.map(Promise.scala:379)
at scala.concurrent.Future$.apply(Future.scala:659)
at play.core.j.JavaAction.apply(JavaAction.scala:176)
at play.api.mvc.Action.$anonfun$apply$4(Action.scala:82)
at scala.concurrent.Future.$anonfun$flatMap$1(Future.scala:307)
at scala.concurrent.impl.Promise.$anonfun$transformWith$1(Promise.scala:41)
at scala.concurrent.impl.CallbackRunnable.run(Promise.scala:64)
at akka.dispatch.BatchingExecutor$AbstractBatch.processBatch(BatchingExecutor.scala:56)
at akka.dispatch.BatchingExecutor$BlockableBatch.$anonfun$run$1(BatchingExecutor.scala:93)
at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23)
at scala.concurrent.BlockContext$.withBlockContext(BlockContext.scala:85)
at akka.dispatch.BatchingExecutor$BlockableBatch.run(BatchingExecutor.scala:93)
at akka.dispatch.TaskInvocation.run(AbstractDispatcher.scala:48)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2311)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2064)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2026)
at org.hibernate.loader.Loader.doQuery(Loader.java:951)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:352)
at org.hibernate.loader.Loader.doList(Loader.java:2857)
at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2701)
at org.hibernate.loader.Loader.list(Loader.java:2663)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1412)
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1565)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
… 61 more
Caused by: java.sql.SQLSyntaxErrorException: Unknown database ‘E1DA68B9-121D-46B7-FF36-322DC0764700’
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
… 75 more
Please provide a description of what actually happens, working from the same starting point.
Be descriptive: “it doesn’t work” does not describe what the behavior actually is – instead, say “the request returns a 400 error with message XXX”. Copy and paste your logs, and include any URLs.
Reproducible Test Case
Screen shot of API setup on Bubble.io
Please provide a simple code that could be run in a new clean app and reproduce the issue.
If the issue is more complex or requires configuration, please provide a link to a project on Github that reproduces the issue.