Hi,
Is there a way to spit more details about the cause of the error while
running unit test cases for the DAO classes ?
I have the select query and data in a file and when i am running the Mock
unit test case, its breaking with the below exception.
20:54:30.301 [Test worker] DEBUG org.jooq.tools.jdbc.MockFileDatabase -
Loaded SQL : select "latest_deck_version"."id",
"latest_deck_version"."deleted", "latest_deck_version"."foreign_id",
"latest_deck_version"."deck_type", "latest_deck_version"."title",
"latest_deck_version"."confidential", "latest_deck_version"."certified",
"latest_deck_version"."deck_id", "latest_deck_version"."original_created",
"latest_deck_version"."original_updated", "latest_deck_version"."created",
"latest_deck_version"."updated", "latest_deck_version"."num_cards",
"latest_deck_version"."num_images", "latest_deck_version"."edition" from
"public"."latest_deck_version"(cast('{"efb2d576-f2d3-4a8e-9715-dc95fdd14701","816d681e-18ca-4b61-938c-401b22c714f5"}'
as uuid[]))
20:54:30.418 [Test worker] DEBUG org.jooq.tools.jdbc.MockFileDatabase -
Loaded Result :
+------------------------------------+-------+----------+---------+---------+------------+---------+------------------------------------+-------------------+-------------------+-------------------+-------------------+---------+----------+--------------------------------+
20:54:30.419 [Test worker] DEBUG org.jooq.tools.jdbc.MockFileDatabase -
: |id
|deleted|foreign_id|deck_type|title |confidential|certified|deck_id
|original_created |original_updated |created
|updated |num_cards|num_images|edition
|
20:54:30.419 [Test worker] DEBUG org.jooq.tools.jdbc.MockFileDatabase -
:
+------------------------------------+-------+----------+---------+---------+------------+---------+------------------------------------+-------------------+-------------------+-------------------+-------------------+---------+----------+--------------------------------+
20:54:30.419 [Test worker] DEBUG org.jooq.tools.jdbc.MockFileDatabase -
: |efb2d576-f2d3-4a8e-9715-dc95fdd14701|false |null
|FINAL |titleTest|false |true
|efb1d576-f2d3-4a8e-9715-dc95fdd14701|2018-10-19 17:44:50|2018-10-19
17:44:50|2018-10-19 17:44:50|2018-10-19 17:44:50|4 |0
|012a631c94215f2ad86cb66d0e7d3043|
20:54:30.419 [Test worker] DEBUG org.jooq.tools.jdbc.MockFileDatabase -
: |816d681e-18ca-4b61-938c-401b22c714f5|true |null
|FINAL |titleDemo|true |true
|efb6d576-f2d3-4a8e-9715-dc95fdd14701|2018-10-19 17:44:50|2018-10-19
17:44:50|2018-10-19 17:44:50|2018-10-19 17:44:50|7 |0
|03a3724203d4f758dc0a567cb58dab17|
20:54:30.419 [Test worker] DEBUG org.jooq.tools.jdbc.MockFileDatabase -
:
+------------------------------------+-------+----------+---------+---------+------------+---------+------------------------------------+-------------------+-------------------+-------------------+-------------------+---------+----------+--------------------------------+
20:54:30.633 [Test worker] INFO org.jooq.Constants -
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@
@@@@@@@@@@@@@@@@ @@ @@ @@@@@@@@@@
@@@@@@@@@@ @@@@ @@ @@ @@@@@@@@@@
@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@ @@ @@ @@@@ @@@@@@@@@@
@@@@@@@@@@ @@ @@ @@@@ @@@@@@@@@@
@@@@@@@@@@ @@ @ @ @@@@@@@@@@
@@@@@@@@@@ @@ @@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Thank you for using jOOQ 3.11.8
20:54:30.656 [Test worker] DEBUG org.jooq.tools.LoggerListener - Executing
query : select "latest_deck_version"."id",
"latest_deck_version"."deleted", "latest_deck_version"."foreign_id",
"latest_deck_version"."deck_type", "latest_deck_version"."title",
"latest_deck_version"."confidential", "latest_deck_version"."certified",
"latest_deck_version"."deck_id", "latest_deck_version"."original_created",
"latest_deck_version"."original_updated", "latest_deck_version"."created",
"latest_deck_version"."updated", "latest_deck_version"."num_cards",
"latest_deck_version"."num_images", "latest_deck_version"."edition" from
"public"."latest_deck_version"(?::uuid[])
20:54:30.663 [Test worker] DEBUG org.jooq.tools.LoggerListener - -> with
bind values : select "latest_deck_version"."id",
"latest_deck_version"."deleted", "latest_deck_version"."foreign_id",
"latest_deck_version"."deck_type", "latest_deck_version"."title",
"latest_deck_version"."confidential", "latest_deck_version"."certified",
"latest_deck_version"."deck_id", "latest_deck_version"."original_created",
"latest_deck_version"."original_updated", "latest_deck_version"."created",
"latest_deck_version"."updated", "latest_deck_version"."num_cards",
"latest_deck_version"."num_images", "latest_deck_version"."edition" from
"public"."latest_deck_version"(cast('{"efb2d576-f2d3-4a8e-9715-dc95fdd14701","816d681e-18ca-4b61-938c-401b22c714f5"}'
as uuid[]))
20:54:30.697 [Test worker] DEBUG org.jooq.tools.LoggerListener - Exception
org.jooq.exception.DataAccessException: SQL [select
"latest_deck_version"."id", "latest_deck_version"."deleted",
"latest_deck_version"."foreign_id", "latest_deck_version"."deck_type",
"latest_deck_version"."title", "latest_deck_version"."confidential",
"latest_deck_version"."certified", "latest_deck_version"."deck_id",
"latest_deck_version"."original_created",
"latest_deck_version"."original_updated", "latest_deck_version"."created",
"latest_deck_version"."updated", "latest_deck_version"."num_cards",
"latest_deck_version"."num_images", "latest_deck_version"."edition" from
"public"."latest_deck_version"(?::uuid[])]; Invalid SQL: select
"latest_deck_version"."id", "latest_deck_version"."deleted",
"latest_deck_version"."foreign_id", "latest_deck_version"."deck_type",
"latest_deck_version"."title", "latest_deck_version"."confidential",
"latest_deck_version"."certified", "latest_deck_version"."deck_id",
"latest_deck_version"."original_created",
"latest_deck_version"."original_updated", "latest_deck_version"."created",
"latest_deck_version"."updated", "latest_deck_version"."num_cards",
"latest_deck_version"."num_images", "latest_deck_version"."edition" from
"public"."latest_deck_version"(?::uuid[])
at org.jooq_3.11.8.POSTGRES_10.debug(Unknown Source)
at org.jooq.impl.Tools.translate(Tools.java:2384)
at
org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:822)
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:364)
at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:393)
at org.jooq.impl.AbstractResultQuery.fetchLazy(AbstractResultQuery.java:380)
at
org.jooq.impl.AbstractResultQuery.fetchResultSet(AbstractResultQuery.java:329)
at org.jooq.impl.SelectImpl.fetchResultSet(SelectImpl.java:2705)
at
com.chegg.deck.service.dao.DeckRepository.getDecksWithoutCardByIds(DeckRepository.java:103)
at
com.chegg.deck.service.dao.DeckWithoutCardsByIdsTest.testGetDecksWithoutCardByIds(DeckWithoutCardsByIdsTest.java:38)
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:564)
at
org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:515)
at
org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:115)
at
org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:170)
at
org.junit.jupiter.engine.execution.ThrowableCollector.execute(ThrowableCollector.java:40)
at
org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:166)
at
org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:113)
at
org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:58)
at
org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:105)
at
org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:72)
at
org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:95)
at
org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:71)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1378)
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:110)
at
org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:72)
at
org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:95)
at
org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:71)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1378)
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:110)
at
org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:72)
at
org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:95)
at
org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:71)
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:170)
at
org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:154)
at
org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:90)
at
org.gradle.api.internal.tasks.testing.junitplatform.JUnitPlatformTestClassProcessor$CollectAllTestClassesExecutor.processAllTestClasses(JUnitPlatformTestClassProcessor.java:92)
at
org.gradle.api.internal.tasks.testing.junitplatform.JUnitPlatformTestClassProcessor$CollectAllTestClassesExecutor.access$100(JUnitPlatformTestClassProcessor.java:77)
at
org.gradle.api.internal.tasks.testing.junitplatform.JUnitPlatformTestClassProcessor.stop(JUnitPlatformTestClassProcessor.java:73)
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:564)
at
org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:35)
at
org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24)
at
org.gradle.internal.dispatch.ContextClassLoaderDispatch.dispatch(ContextClassLoaderDispatch.java:32)
at
org.gradle.internal.dispatch.ProxyDispatchAdapter$DispatchingInvocationHandler.invoke(ProxyDispatchAdapter.java:93)
at com.sun.proxy.$Proxy2.stop(Unknown Source)
at
org.gradle.api.internal.tasks.testing.worker.TestWorker.stop(TestWorker.java:131)
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:564)
at
org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:35)
at
org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24)
at
org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:155)
at
org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:137)
at
org.gradle.internal.remote.internal.hub.MessageHub$Handler.run(MessageHub.java:404)
at
org.gradle.internal.concurrent.ExecutorPolicy$CatchAndRecordFailures.onExecute(ExecutorPolicy.java:63)
at
org.gradle.internal.concurrent.ManagedExecutorImpl$1.run(ManagedExecutorImpl.java:46)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1135)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at
org.gradle.internal.concurrent.ThreadFactoryImpl$ManagedThreadRunnable.run(ThreadFactoryImpl.java:55)
at java.base/java.lang.Thread.run(Thread.java:844)
Caused by: java.sql.SQLException: Invalid SQL: select
"latest_deck_version"."id", "latest_deck_version"."deleted",
"latest_deck_version"."foreign_id", "latest_deck_version"."deck_type",
"latest_deck_version"."title", "latest_deck_version"."confidential",
"latest_deck_version"."certified", "latest_deck_version"."deck_id",
"latest_deck_version"."original_created",
"latest_deck_version"."original_updated", "latest_deck_version"."created",
"latest_deck_version"."updated", "latest_deck_version"."num_cards",
"latest_deck_version"."num_images", "latest_deck_version"."edition" from
"public"."latest_deck_version"(?::uuid[])
at org.jooq.tools.jdbc.MockFileDatabase.execute(MockFileDatabase.java:364)
at org.jooq.tools.jdbc.MockStatement.execute0(MockStatement.java:187)
at org.jooq.tools.jdbc.MockStatement.execute(MockStatement.java:250)
at org.jooq.tools.jdbc.MockStatement.execute(MockStatement.java:245)
at
org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:209)
at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:3494)
at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:268)
at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:350)
... 68 common frames omitted
I am not able to figure out what really the cause of this error.
Basically in my experience, any error it just throw java.sql.SQLException:
Invalid SQL.
I am not able to figure out what really the cause of this error. Can
someone help me understand what could be the issue or is there a way i can
get more info from JOOQ about the error ?
I am attaching my Mock data file which i am using to test my DAO method.
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/097bb76b-098e-411e-b639-1d6b455fe223%40googlegroups.com.
#getDecksWithoutCardByIds
select "latest_deck_version"."id", "latest_deck_version"."deleted",
"latest_deck_version"."foreign_id", "latest_deck_version"."deck_type",
"latest_deck_version"."title", "latest_deck_version"."confidential",
"latest_deck_version"."certified", "latest_deck_version"."deck_id",
"latest_deck_version"."original_created",
"latest_deck_version"."original_updated", "latest_deck_version"."created",
"latest_deck_version"."updated", "latest_deck_version"."num_cards",
"latest_deck_version"."num_images", "latest_deck_version"."edition" from
"public"."latest_deck_version"(cast('{"efb2d576-f2d3-4a8e-9715-dc95fdd14701","816d681e-18ca-4b61-938c-401b22c714f5"}'
as uuid[]));
> id deleted foreign_id deck_type
> title confidential certified deck_id
> original_created original_updated created updated
> num_cards num_images edition
> -------------------------------------- --------- ---------- -----------
> ----------- ------------- ---------- --------------------------------------
> --------------------- -------------------- ---------------------
> -------------------- ----------- ------------
> ----------------------------------
> efb2d576-f2d3-4a8e-9715-dc95fdd14701 false null FINAL
> titleTest false true efb1d576-f2d3-4a8e-9715-dc95fdd14701
> 2018-10-19 17:44:50 2018-10-19 17:44:50 2018-10-19 17:44:50 2018-10-19
> 17:44:50 4 0 012a631c94215f2ad86cb66d0e7d3043
> 816d681e-18ca-4b61-938c-401b22c714f5 true null FINAL
> titleDemo true true efb6d576-f2d3-4a8e-9715-dc95fdd14701
> 2018-10-19 17:44:50 2018-10-19 17:44:50 2018-10-19 17:44:50 2018-10-19
> 17:44:50 7 0 03a3724203d4f758dc0a567cb58dab17
@ rows: 2
