Hi Deba,
What's missing from the error message, in your opinion?
*Invalid SQL*: select
`content_management`.`edu_course_content`.`course_id`,
`content_management`.`edu_course_content`.`edu_custom_course_id`,
`content_management`.`edu_course_content`.`edu_content_id` from
`content_management`.`edu_course_content` where
(`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
(`content_management`.`edu_course_content`.`course_id` = ? or
`content_management`.`edu_course_content`.`edu_custom_course_id` = ?))
*Possible reasons include: *
* Your regular expressions are case sensitive.*
* Your regular expressions use constant literals (e.g. 'Hello'),
but the above SQL string uses bind variable placeholders (e.g. ?).*
* Your regular expressions did not quote special characters (e.g.
\?).*
* Your regular expressions' whitespace doesn't match the input
SQL's whitespace.*
The query that was executed above simply wasn't matched by your file
(assuming you're using the
https://www.jooq.org/doc/latest/manual/sql-execution/mock-file-database).
How could the error message be improved to indicate this?
Lukas
On Tue, Jun 22, 2021 at 3:17 AM Debapriya Patra <[email protected]>
wrote:
> Hello,
>
> I am writing unit tests for my DAO class methods by keeping the mock data
> in a .txt file. The interesting part with Jooq is, it has a common error
> which does not really say what is going wrong with your mock data setup.
>
>
> Can someone help me understand how I can debug this issue in a better way?
> Moreover I wanted to see the clear error message due to which the tests are
> breaking.
>
> Here is a sample error log.
>
>
> 18:12:50.170 [Test worker] DEBUG org.jooq.tools.LoggerListener - Executing
> query : select
> `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
> (`content_management`.`edu_course_content`.`course_id` = ? or
> `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))
> 18:12:50.172 [Test worker] DEBUG org.jooq.tools.LoggerListener - -> with
> bind values : select
> `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in
> ('a32ba478-90d9-4c7c-85e9-2899bddab41f',
> 'a32ba478-90d9-4c7c-85e9-2899bddab42f') and
> (`content_management`.`edu_course_content`.`course_id` =
> '132ba478-90d9-4c7c-85e9-2899bddab41f' or
> `content_management`.`edu_course_content`.`edu_custom_course_id` =
> '132ba478-90d9-4c7c-85e9-2899bddab41f'))
> 18:12:50.197 [Test worker] DEBUG org.jooq.tools.LoggerListener -
> Exception
> org.jooq.exception.DataAccessException: SQL [select
> `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
> (`content_management`.`edu_course_content`.`course_id` = ? or
> `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))];
> Invalid SQL: select `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
> (`content_management`.`edu_course_content`.`course_id` = ? or
> `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))
> Possible reasons include:
> Your regular expressions are case sensitive.
> Your regular expressions use constant literals (e.g. 'Hello'), but the
> above SQL string uses bind variable placeholders (e.g. ?).
> Your regular expressions did not quote special characters (e.g. \?).
> Your regular expressions' whitespace doesn't match the input SQL's
> whitespace.
> at org.jooq_3.14.8.MYSQL.debug(Unknown Source)
> at org.jooq.impl.Tools.translate(Tools.java:2903)
> at
> org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:757)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:389)
> at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:333)
> at
> org.jooq.impl.AbstractResultQuery.fetchInto(AbstractResultQuery.java:1550)
> at org.jooq.impl.SelectImpl.fetchInto(SelectImpl.java:3936)
> at
> com.chegg.edu.content.mgmt.service.dao.EduCourseContentRepository.getCourseContentsByContentIds(EduCourseContentRepository.java:92)
> at
> com.chegg.edu.content.mgmt.service.dao.EduCourseContentRepositoryTest.testGetCourseContentsByContentIds(EduCourseContentRepositoryTest.java:98)
> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> at
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.base/java.lang.reflect.Method.invoke(Method.java:566)
> at
> org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:688)
> at
> org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
> at
> org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
> at
> org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)
> at
> org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)
> at
> org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)
> at
> org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)
> at
> org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)
> at
> org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
> at
> org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
> at
> org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
> at
> org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
> at
> org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)
> at
> org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)
> at
> org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:210)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:206)
> at
> org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:131)
> at
> org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:65)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)
> at
> org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)
> at java.base/java.util.ArrayList.forEach(ArrayList.java:1540)
> at
> org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)
> at
> org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)
> at java.base/java.util.ArrayList.forEach(ArrayList.java:1540)
> at
> org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)
> at
> org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)
> at
> org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32)
> at
> org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
> at
> org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)
> at
> org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:248)
> at
> org.junit.platform.launcher.core.DefaultLauncher.lambda$execute$5(DefaultLauncher.java:211)
> at
> org.junit.platform.launcher.core.DefaultLauncher.withInterceptedStreams(DefaultLauncher.java:226)
> at
> org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:199)
> at
> org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:132)
> at
> org.gradle.api.internal.tasks.testing.junitplatform.JUnitPlatformTestClassProcessor$CollectAllTestClassesExecutor.processAllTestClasses(JUnitPlatformTestClassProcessor.java:99)
> at
> org.gradle.api.internal.tasks.testing.junitplatform.JUnitPlatformTestClassProcessor$CollectAllTestClassesExecutor.access$000(JUnitPlatformTestClassProcessor.java:79)
> at
> org.gradle.api.internal.tasks.testing.junitplatform.JUnitPlatformTestClassProcessor.stop(JUnitPlatformTestClassProcessor.java:75)
> at
> org.gradle.api.internal.tasks.testing.SuiteTestClassProcessor.stop(SuiteTestClassProcessor.java:61)
> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> at
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.base/java.lang.reflect.Method.invoke(Method.java:566)
> at
> org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:36)
> at
> org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24)
> at
> org.gradle.internal.dispatch.ContextClassLoaderDispatch.dispatch(ContextClassLoaderDispatch.java:33)
> at
> org.gradle.internal.dispatch.ProxyDispatchAdapter$DispatchingInvocationHandler.invoke(ProxyDispatchAdapter.java:94)
> at com.sun.proxy.$Proxy5.stop(Unknown Source)
> at
> org.gradle.api.internal.tasks.testing.worker.TestWorker.stop(TestWorker.java:133)
> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> at
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.base/java.lang.reflect.Method.invoke(Method.java:566)
> at
> org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:36)
> at
> org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24)
> at
> org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:182)
> at
> org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:164)
> at
> org.gradle.internal.remote.internal.hub.MessageHub$Handler.run(MessageHub.java:414)
> at
> org.gradle.internal.concurrent.ExecutorPolicy$CatchAndRecordFailures.onExecute(ExecutorPolicy.java:64)
> at
> org.gradle.internal.concurrent.ManagedExecutorImpl$1.run(ManagedExecutorImpl.java: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
> org.gradle.internal.concurrent.ThreadFactoryImpl$ManagedThreadRunnable.run(ThreadFactoryImpl.java:56)
> at java.base/java.lang.Thread.run(Thread.java:834)
> Caused by: java.sql.SQLException: Invalid SQL: select
> `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
> (`content_management`.`edu_course_content`.`course_id` = ? or
> `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))
> Possible reasons include:
> Your regular expressions are case sensitive.
> Your regular expressions use constant literals (e.g. 'Hello'), but the
> above SQL string uses bind variable placeholders (e.g. ?).
> Your regular expressions did not quote special characters (e.g. \?).
> Your regular expressions' whitespace doesn't match the input SQL's
> whitespace.
> at org.jooq.tools.jdbc.MockFileDatabase.execute(MockFileDatabase.java:396)
> at org.jooq.tools.jdbc.MockStatement.execute0(MockStatement.java:192)
> at org.jooq.tools.jdbc.MockStatement.execute(MockStatement.java:273)
> at org.jooq.tools.jdbc.MockStatement.execute(MockStatement.java:268)
> at
> org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:214)
> at
> org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:4201)
> at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:279)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:375)
> ... 93 common frames omitted
>
> SQL [select `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
> (`content_management`.`edu_course_content`.`course_id` = ? or
> `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))];
> Invalid SQL: select `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
> (`content_management`.`edu_course_content`.`course_id` = ? or
> `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))
> Possible reasons include:
> Your regular expressions are case sensitive.
> Your regular expressions use constant literals (e.g. 'Hello'), but the
> above SQL string uses bind variable placeholders (e.g. ?).
> Your regular expressions did not quote special characters (e.g. \?).
> Your regular expressions' whitespace doesn't match the input SQL's
> whitespace.
> org.jooq.exception.DataAccessException: SQL [select
> `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
> (`content_management`.`edu_course_content`.`course_id` = ? or
> `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))];
> Invalid SQL: select `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
> (`content_management`.`edu_course_content`.`course_id` = ? or
> `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))
> Possible reasons include:
> Your regular expressions are case sensitive.
> Your regular expressions use constant literals (e.g. 'Hello'), but the
> above SQL string uses bind variable placeholders (e.g. ?).
> Your regular expressions did not quote special characters (e.g. \?).
> Your regular expressions' whitespace doesn't match the input SQL's
> whitespace.
> at org.jooq_3.14.8.MYSQL.debug(Unknown Source)
> at org.jooq.impl.Tools.translate(Tools.java:2903)
> at
> org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:757)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:389)
> at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:333)
> at
> org.jooq.impl.AbstractResultQuery.fetchInto(AbstractResultQuery.java:1550)
> at org.jooq.impl.SelectImpl.fetchInto(SelectImpl.java:3936)
> at
> com.chegg.edu.content.mgmt.service.dao.EduCourseContentRepository.getCourseContentsByContentIds(EduCourseContentRepository.java:92)
> at
> com.chegg.edu.content.mgmt.service.dao.EduCourseContentRepositoryTest.testGetCourseContentsByContentIds(EduCourseContentRepositoryTest.java:98)
> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> at
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.base/java.lang.reflect.Method.invoke(Method.java:566)
> at
> org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:688)
> at
> org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
> at
> org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
> at
> org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)
> at
> org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)
> at
> org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)
> at
> org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)
> at
> org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)
> at
> org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
> at
> org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
> at
> org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
> at
> org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
> at
> org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)
> at
> org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)
> at
> org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:210)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:206)
> at
> org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:131)
> at
> org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:65)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)
> at
> org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)
> at java.base/java.util.ArrayList.forEach(ArrayList.java:1540)
> at
> org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)
> at
> org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)
> at java.base/java.util.ArrayList.forEach(ArrayList.java:1540)
> at
> org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:143)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:129)
> at
> org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:127)
> at
> org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:126)
> at
> org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:84)
> at
> org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32)
> at
> org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
> at
> org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)
> at
> org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:248)
> at
> org.junit.platform.launcher.core.DefaultLauncher.lambda$execute$5(DefaultLauncher.java:211)
> at
> org.junit.platform.launcher.core.DefaultLauncher.withInterceptedStreams(DefaultLauncher.java:226)
> at
> org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:199)
> at
> org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:132)
> at
> org.gradle.api.internal.tasks.testing.junitplatform.JUnitPlatformTestClassProcessor$CollectAllTestClassesExecutor.processAllTestClasses(JUnitPlatformTestClassProcessor.java:99)
> at
> org.gradle.api.internal.tasks.testing.junitplatform.JUnitPlatformTestClassProcessor$CollectAllTestClassesExecutor.access$000(JUnitPlatformTestClassProcessor.java:79)
> at
> org.gradle.api.internal.tasks.testing.junitplatform.JUnitPlatformTestClassProcessor.stop(JUnitPlatformTestClassProcessor.java:75)
> at
> org.gradle.api.internal.tasks.testing.SuiteTestClassProcessor.stop(SuiteTestClassProcessor.java:61)
> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> at
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.base/java.lang.reflect.Method.invoke(Method.java:566)
> at
> org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:36)
> at
> org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24)
> at
> org.gradle.internal.dispatch.ContextClassLoaderDispatch.dispatch(ContextClassLoaderDispatch.java:33)
> at
> org.gradle.internal.dispatch.ProxyDispatchAdapter$DispatchingInvocationHandler.invoke(ProxyDispatchAdapter.java:94)
> at com.sun.proxy.$Proxy5.stop(Unknown Source)
> at
> org.gradle.api.internal.tasks.testing.worker.TestWorker.stop(TestWorker.java:133)
> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> at
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.base/java.lang.reflect.Method.invoke(Method.java:566)
> at
> org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:36)
> at
> org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24)
> at
> org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:182)
> at
> org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:164)
> at
> org.gradle.internal.remote.internal.hub.MessageHub$Handler.run(MessageHub.java:414)
> at
> org.gradle.internal.concurrent.ExecutorPolicy$CatchAndRecordFailures.onExecute(ExecutorPolicy.java:64)
> at
> org.gradle.internal.concurrent.ManagedExecutorImpl$1.run(ManagedExecutorImpl.java: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
> org.gradle.internal.concurrent.ThreadFactoryImpl$ManagedThreadRunnable.run(ThreadFactoryImpl.java:56)
> at java.base/java.lang.Thread.run(Thread.java:834)
> Caused by: java.sql.SQLException: Invalid SQL: select
> `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
> (`content_management`.`edu_course_content`.`course_id` = ? or
> `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))
> Possible reasons include:
> Your regular expressions are case sensitive.
> Your regular expressions use constant literals (e.g. 'Hello'), but the
> above SQL string uses bind variable placeholders (e.g. ?).
> Your regular expressions did not quote special characters (e.g. \?).
> Your regular expressions' whitespace doesn't match the input SQL's
> whitespace.
> at org.jooq.tools.jdbc.MockFileDatabase.execute(MockFileDatabase.java:396)
> at org.jooq.tools.jdbc.MockStatement.execute0(MockStatement.java:192)
> at org.jooq.tools.jdbc.MockStatement.execute(MockStatement.java:273)
> at org.jooq.tools.jdbc.MockStatement.execute(MockStatement.java:268)
> at
> org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:214)
> at
> org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:4201)
> at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:279)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:375)
> ... 93 more
>
>
> EduCourseContentRepositoryTest > testGetCourseContentsByContentIds() FAILED
> org.jooq.exception.DataAccessException: SQL [select
> `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
> (`content_management`.`edu_course_content`.`course_id` = ? or
> `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))];
> Invalid SQL: select `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
> (`content_management`.`edu_course_content`.`course_id` = ? or
> `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))
> Possible reasons include:
> Your regular expressions are case sensitive.
> Your regular expressions use constant literals (e.g. 'Hello'), but
> the above SQL string uses bind variable placeholders (e.g. ?).
> Your regular expressions did not quote special characters (e.g. \?).
> Your regular expressions' whitespace doesn't match the input SQL's
> whitespace.
> at org.jooq_3.14.8.MYSQL.debug(Unknown Source)
> at org.jooq.impl.Tools.translate(Tools.java:2903)
> at
> org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:757)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:389)
> at
> org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:333)
> at
> org.jooq.impl.AbstractResultQuery.fetchInto(AbstractResultQuery.java:1550)
> at org.jooq.impl.SelectImpl.fetchInto(SelectImpl.java:3936)
> at
> com.chegg.edu.content.mgmt.service.dao.EduCourseContentRepository.getCourseContentsByContentIds(EduCourseContentRepository.java:92)
> at
> com.chegg.edu.content.mgmt.service.dao.EduCourseContentRepositoryTest.testGetCourseContentsByContentIds(EduCourseContentRepositoryTest.java:98)
> Caused by:
> java.sql.SQLException: Invalid SQL: select
> `content_management`.`edu_course_content`.`course_id`,
> `content_management`.`edu_course_content`.`edu_custom_course_id`,
> `content_management`.`edu_course_content`.`edu_content_id` from
> `content_management`.`edu_course_content` where
> (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and
> (`content_management`.`edu_course_content`.`course_id` = ? or
> `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))
> Possible reasons include:
> Your regular expressions are case sensitive.
> Your regular expressions use constant literals (e.g. 'Hello'),
> but the above SQL string uses bind variable placeholders (e.g. ?).
> Your regular expressions did not quote special characters (e.g.
> \?).
> Your regular expressions' whitespace doesn't match the input
> SQL's whitespace.
> at
> org.jooq.tools.jdbc.MockFileDatabase.execute(MockFileDatabase.java:396)
> at
> org.jooq.tools.jdbc.MockStatement.execute0(MockStatement.java:192)
> at
> org.jooq.tools.jdbc.MockStatement.execute(MockStatement.java:273)
> at
> org.jooq.tools.jdbc.MockStatement.execute(MockStatement.java:268)
> at
> org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:214)
> at
> org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:4201)
> at
> org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:279)
> at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:375)
> ... 5 more
> --------------------------------------------------------------------
> | Results: FAILURE (1 tests, 0 successes, 1 failures, 0 skipped) |
> --------------------------------------------------------------------
>
> Thanks,
> Deba
>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/jooq-user/f14ed478-d572-4c91-92be-ae0f1fb520a6n%40googlegroups.com
> <https://groups.google.com/d/msgid/jooq-user/f14ed478-d572-4c91-92be-ae0f1fb520a6n%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/CAB4ELO4sz6i-fKnqMySF5FbqV%2BUjSqh1URoKpVx0Nr%2BbCg-uXA%40mail.gmail.com.
