1 2 Previous Next 24 Replies Latest reply on Dec 6, 2018 9:36 AM by rareddy

Teiid Spring Boot with IBMDB2

13_abhi Nov 27, 2018 9:59 AM

Hi All,

I have configured my spring boot application with IBMDB2 to access data using ODATA protocol.

i am able to get the metadata information using the URL, but unable to access any tables. Furnishing the errors as below, Please assist

Error Log

org.teiid.translator.jdbc.JDBCExecutionException: -204 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS c_0, FROM "TEST" AS g_0 ORDER BY c_0]

at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:127) ~[translator-jdbc-10.1.0.jar:10.1.0]

at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358) ~[teiid-engine-10.1.0.jar:10.1.0]

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]

at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216) ~[teiid-engine-10.1.0.jar:10.1.0]

at com.sun.proxy.$Proxy90.execute(Unknown Source) ~[na:na]

at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302) ~[teiid-engine-10.1.0.jar:10.1.0]

at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-10.1.0.jar:10.1.0]

at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104) [teiid-engine-10.1.0.jar:10.1.0]

at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_162]

Application Properties:

spring.datasource.test.url=

spring.datasource.test.username=

spring.datasource.test.password=

spring.datasource.test.driver-class-name=com.ibm.db2.jcc.DB2Driver

spring.datasource.test.importer.SchemaPattern=my-schema

1. Re: Teiid Spring Boot with IBMDB2

rareddy Nov 27, 2018 10:26 AM (in response to 13_abhi)

Make sure your tables in the DB2 has primary keys before you can access through the OData. Second, the above snippet does not really show the error what is the error?
Actions
2. Re: Teiid Spring Boot with IBMDB2

13_abhi Nov 27, 2018 1:03 PM (in response to rareddy)

Hi Ramesh,

I have verified all the tales and every one has primary key in it. As you told i am providing complete error trace below,

2018-11-27 14:44:40.940 WARN 16076 --- [ProcessorQueue0] org.teiid.CONNECTOR : Connector worker process failed for atomic-request=qPHcCiVyEq/5.0.0.0
org.teiid.translator.jdbc.JDBCExecutionException: -204 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS c_0, g_0."NATIONAL_GROUP_ID" AS c_1, g_0."GLOBAL_GROUP_ID" AS c_2, g_0."NATIONAL_GROUP_NAME" AS c_3, g_0."GLOBAL_GROUP_NAME" AS c_4, g_0."NATIONAL_GROUP_COUNTRY_CODE" AS c_5, g_0."GLOBAL_GROUP_COUNTRY_CODE" AS c_6 FROM "TEST" AS g_0 ORDER BY c_0]
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:127) ~[translator-jdbc-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358) ~[teiid-engine-10.1.0.jar:10.1.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216) ~[teiid-engine-10.1.0.jar:10.1.0]
at com.sun.proxy.$Proxy90.execute(Unknown Source) ~[na:na]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302) ~[teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104) [teiid-engine-10.1.0.jar:10.1.0]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_162]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61) [teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115) [teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206) [teiid-engine-10.1.0.jar:10.1.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_162]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_162]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_162]
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DCDT0.TEST, DRIVER=3.64.106
at com.ibm.db2.jcc.am.bd.a(bd.java:679) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.bd.a(bd.java:60) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.bd.a(bd.java:127) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.io.c(io.java:2706) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.io.d(io.java:2694) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.io.a(io.java:2143) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jo.a(jo.java:7353) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.ab.h(ab.java:141) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.ab.b(ab.java:41) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.p.a(p.java:32) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.qb.i(qb.java:135) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.io.gb(io.java:2112) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jo.rc(jo.java:3526) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jo.b(jo.java:4322) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jo.ec(jo.java:735) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jo.executeQuery(jo.java:708) ~[db2jcc4-10.1.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-8.5.14.jar:na]
at com.sun.proxy.$Proxy91.executeQuery(Unknown Source) ~[na:na]
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119) ~[translator-jdbc-10.1.0.jar:10.1.0]
... 18 common frames omitted
Actions
3. Re: Teiid Spring Boot with IBMDB2

rareddy Nov 27, 2018 3:30 PM (in response to 13_abhi)

Looks like an error from your DB2 JDBC driver since it did not like the SQL query syntax that Teiid sent. It may be due to not selecting the correct translator type during the build of the VDB internally. Can you add the property

logging.level.org.teiid.spring=DEBUG

to application.properties, then run it again and post the VDB generated here, I want to make sure it is selecting the correct translator. If not it may be like this error java - Why do I get SQLCODE=-204, SQLSTATE=42704 with DB2 LUW and WebSphere App Server? - Stack Overflow where case of the sql not matching up with database?
Actions
4. Re: Teiid Spring Boot with IBMDB2

13_abhi Nov 27, 2018 4:41 PM (in response to rareddy)

Hi,
Mentioned log level is added and attaching the error below,
Logs:

2018-11-27 22:38:43.705 INFO 11496 --- [nio-8080-exec-2] org.teiid.COMMAND_LOG                    : START USER COMMAND: startTime=2018-11-27 22:38:43.705 requestID=uUsfLbEbVHbY.0 txID=null sessionID=uUsfLbEbVHbY applicationName=JDBC principal=anonymous vdbName=spring vdbVersion=1.0.0 sql=/*+ cache(ttl:300000 scope:USER) */ SELECT g0.ID, g0.MEASURE, g0.FORBORNE_CUSTOMER_ID, g0.CREATED_BY, g0.CREATED, g0.MODIFIED_BY, g0.MODIFIED, g0.VERSION, g0.FORBORNE_AGREEMENT_ID, g0.START_DATE, g0.END_DATE, g0.COMMENT, g0.NON_STANDARD_FEATURE, g0.SPPI_TEST_RESULT FROM credit.TEST AS g0 ORDER BY g0.ID /* uUsfLbEbVHbY */
2018-11-27 22:38:43.910 WARN 11496 --- [ProcessorQueue0] org.teiid.CONNECTOR                      : Connector worker process failed for atomic-request=uUsfLbEbVHbY.0.0.0

org.teiid.translator.jdbc.JDBCExecutionException: -204 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS c_0, g_0."MEASURE" AS c_1, g_0."FORBORNE_CUSTOMER_ID" AS c_2, g_0."CREATED_BY" AS c_3, g_0."CREATED" AS c_4, g_0."MODIFIED_BY" AS c_5, g_0."MODIFIED" AS c_6, g_0."VERSION" AS c_7, g_0."FORBORNE_AGREEMENT_ID" AS c_8, g_0."START_DATE" AS c_9, g_0."END_DATE" AS c_10, g_0."COMMENT" AS c_11, g_0."NON_STANDARD_FEATURE" AS c_12, g_0."SPPI_TEST_RESULT" AS c_13 FROM "TEST" AS g_0 ORDER BY c_0]
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:127) ~[translator-jdbc-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358) ~[teiid-engine-10.1.0.jar:10.1.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216) ~[teiid-engine-10.1.0.jar:10.1.0]
at com.sun.proxy.$Proxy90.execute(Unknown Source) ~[na:na]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302) ~[teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) [teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104) [teiid-engine-10.1.0.jar:10.1.0]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_162]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61) [teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115) [teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206) [teiid-engine-10.1.0.jar:10.1.0]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_162]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_162]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_162]
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DCDT0.TEST, DRIVER=3.64.106
at com.ibm.db2.jcc.am.bd.a(bd.java:679) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.bd.a(bd.java:60) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.bd.a(bd.java:127) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.io.c(io.java:2706) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.io.d(io.java:2694) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.io.a(io.java:2143) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jo.a(jo.java:7353) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.ab.h(ab.java:141) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.ab.b(ab.java:41) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.p.a(p.java:32) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.qb.i(qb.java:135) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.io.gb(io.java:2112) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jo.rc(jo.java:3526) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jo.b(jo.java:4322) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jo.ec(jo.java:735) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jo.executeQuery(jo.java:708) ~[db2jcc4-10.1.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-8.5.14.jar:na]
at com.sun.proxy.$Proxy91.executeQuery(Unknown Source) ~[na:na]
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119) ~[translator-jdbc-10.1.0.jar:10.1.0]
... 18 common frames omitted

2018-11-27 22:38:43.945 INFO 11496 --- [nio-8080-exec-2] org.teiid.COMMAND_LOG                    : ERROR USER COMMAND: endTime=2018-11-27 22:38:43.945 requestID=uUsfLbEbVHbY.0 txID=null sessionID=uUsfLbEbVHbY principal=anonymous vdbName=spring vdbVersion=1.0.0 finalRowCount=null
2018-11-27 22:38:43.947 WARN 11496 --- [nio-8080-exec-2] org.teiid.PROCESSOR                      : TEIID30020 Processing exception for request uUsfLbEbVHbY.0 'TEIID30504 credit: -204 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS c_0, g_0."MEASURE" AS c_1, g_0."FORBORNE_CUSTOMER_ID" AS c_2, g_0."CREATED_BY" AS c_3, g_0."CREATED" AS c_4, g_0."MODIFIED_BY" AS c_5, g_0."MODIFIED" AS c_6, g_0."VERSION" AS c_7, g_0."FORBORNE_AGREEMENT_ID" AS c_8, g_0."START_DATE" AS c_9, g_0."END_DATE" AS c_10, g_0."COMMENT" AS c_11, g_0."NON_STANDARD_FEATURE" AS c_12, g_0."SPPI_TEST_RESULT" AS c_13 FROM "TEST" AS g_0 ORDER BY c_0]'. Originally TeiidProcessingException 'DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DCDT0.TEST, DRIVER=3.64.106' bd.java:679. Enable more detailed logging to see the entire stacktrace.
2018-11-27 22:38:43.948 INFO 11496 --- [nio-8080-exec-2] org.teiid.COMMAND_LOG                    : END USER COMMAND: endTime=2018-11-27 22:38:43.947 requestID=uUsfLbEbVHbY.0 txID=null sessionID=uUsfLbEbVHbY principal=anonymous vdbName=spring vdbVersion=1.0.0 finalRowCount=0
2018-11-27 22:38:43.955 WARN 11496 --- [nio-8080-exec-2] org.teiid.PROCESSOR                      : TEIID16053 Unable to process odata request due to: TEIID30504 credit: -204 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS c_0, g_0."MEASURE" AS c_1, g_0."FORBORNE_CUSTOMER_ID" AS c_2, g_0."CREATED_BY" AS c_3, g_0."CREATED" AS c_4, g_0."MODIFIED_BY" AS c_5, g_0."MODIFIED" AS c_6, g_0."VERSION" AS c_7, g_0."FORBORNE_AGREEMENT_ID" AS c_8, g_0."START_DATE" AS c_9, g_0."END_DATE" AS c_10, g_0."COMMENT" AS c_11, g_0."NON_STANDARD_FEATURE" AS c_12, g_0."SPPI_TEST_RESULT" AS c_13 FROM "TEST" AS g_0 ORDER BY c_0] Increase the log level to see the entire stack trace.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Let me know where i can see vdb.xml file in my spring boot application?
Actions
5. Re: Teiid Spring Boot with IBMDB2

rareddy Nov 27, 2018 4:49 PM (in response to 13_abhi)

That is very similar to what you provided originally. Have you added the property I mentioned? If yes, I do not see any DEBUG level messages
Actions
6. Re: Teiid Spring Boot with IBMDB2

13_abhi Nov 28, 2018 1:38 AM (in response to rareddy)

yes i had added the log level to DEBUG , Can you let me know where i can see vdb.xml file in my application?

One more update
Error stated in my logs-Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DCDT0.TEST, DRIVER=3.64.106

Obervation
SQLERRMC=DCDT0.TEST
DCDT0 --->username ( which is configured in application property )
TEST ---> table name
As per the link provided earlier,(java - Why do I get SQLCODE=-204, SQLSTATE=42704 with DB2 LUW and WebSphere App Server? - Stack Overflow ), There should be a schema name there instead of username
application.properties
spring.datasource.test.url=
spring.datasource.test.username=dcdt0
spring.datasource.test.password=
spring.datasource.test.driver-class-name=com.ibm.db2.jcc.DB2Driver
spring.datasource.test.importer.SchemaPattern=CDTFDT
Actions
7. Re: Teiid Spring Boot with IBMDB2

13_abhi Nov 28, 2018 4:25 AM (in response to 13_abhi)

Also i need to tell you this configuration i have done in teiid designer in eclipse and it worked. But i need this to work in spring boot. I have tried with db2jcc4.jar & db2jcc.jar

<dependency>
<groupId>com.ibm.db2.jcc</groupId>
<artifactId>db2jcc4</artifactId>
<version>10.1</version>
</dependency>
<dependency>
<groupId>com.ibm.db2</groupId>cd
<artifactId>db2jcc_license_cu</artifactId>
<version>10.5</version>
</dependency>
Actions
8. Re: Teiid Spring Boot with IBMDB2

rareddy Nov 28, 2018 9:01 AM (in response to 13_abhi)

13_abhi wrote:

Can you let me know where i can see vdb.xml file in my application?
It will be inlined in the log that spitted out to the console.
Actions
9. Re: Teiid Spring Boot with IBMDB2

13_abhi Nov 28, 2018 12:09 PM (in response to rareddy)

Hi Team,
I am not able to rely in this post, Please assit
Actions
10. Re: Teiid Spring Boot with IBMDB2

rareddy Nov 28, 2018 12:15 PM (in response to 13_abhi)

Abilash,

I do not have the same setup with DB2 as you do a testing and tell you exactly what is happening, I am trying to guide where you can give me further information to figure out the issue. Without that I am helpless. The software is designed to log internal VDB constructs when it is run in DEBUG mode. I have changed the logging context to much wide now, see that helps.

logging.level.org.teiid=DEBUG
Actions
11. Re: Teiid Spring Boot with IBMDB2

13_abhi Nov 30, 2018 4:39 AM (in response to rareddy)

Hi Ramesh,

I have set debug level and got more error logs as below when invoking
http://localhost:8080/TABLE1

Logs:

2018-11-29 08:40:32.163 DEBUG 11812 ---
org.teiid.AUDIT_LOG                      : [spring.1.0.0, null anonymous
USERPASSWORD null null null true]
2018-11-29 08:40:32.163 DEBUG 11812 ---
org.teiid.SECURITY                       : authenticateUser anonymous JDBC
2018-11-29 08:40:32.164 DEBUG 11812 ---
org.teiid.SECURITY                       : Logon successful, created
session: sessionid=HUQfb2uepBfb; userName=anonymous; vdbName=spring;
vdbVersion=1.0.0; createdTime=Thu Nov 29 08:40:32 CET 2018;
applicationName=JDBC; clientHostName=null; clientHardwareAddress=null;
IPAddress=null; securityDomain=teiid-security; lastPingTime=Thu Nov 29
08:40:32 CET 2018
2018-11-29 08:40:32.165 DEBUG 11812 ---
org.teiid.AUDIT_LOG                      :

2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc
                       : Successfully obtained a session.
2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc
                       : Connection Url=
2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc
                       : ApplicationName=JDBC
2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc
                       : PassthroughAuthentication=true
2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc
                       : waitForLoad=0
2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc
                       : batch-size=256
2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc
                       : VirtualDatabaseName=spring.1.0.0
2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc
                       : transportName=odata
2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc
                       : skiptoken-cache-time=300000
2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc
                       : The JDBC Driver successfully obtained a connection.
2018-11-29 08:40:32.166 DEBUG 11812 --- org.teiid.ODATA
                        : Teiid-Query: /*+ cache(ttl:300000 scope:USER) */
SELECT g1.ID FROM credit.TABLE1 AS g1 ORDER BY g1.ID /* HUQfb2uepBfb */
2018-11-29 08:40:32.166 INFO 11812 ---
org.teiid.COMMAND_LOG                    : START USER COMMAND:
startTime=2018-11-29
08:40:32.166 requestID=HUQfb2uepBfb.0 txID=null sessionID=HUQfb2uepBfb
applicationName=JDBC principal=anonymous vdbName=spring
vdbVersion=1.0.0 sql=/*+
cache(ttl:300000 scope:USER) */ SELECT g1.ID FROM credit.TABLE1 AS g1 ORDER
BY g1.ID /* HUQfb2uepBfb */
2018-11-29 08:40:32.166 DEBUG 11812 ---
org.teiid.PROCESSOR                      : Request Thread HUQfb2uepBfb.0
with state NEW
2018-11-29 08:40:32.166 DEBUG 11812 ---
org.teiid.PROCESSOR                      : HUQfb2uepBfb.0 executing
prepared /*+ cache(ttl:300000 scope:USER) */ SELECT g1.ID FROM
credit.TABLE1 AS g1 ORDER BY g1.ID /* HUQfb2uepBfb */
2018-11-29 08:40:32.172 DEBUG 11812 ---
org.teiid.PROCESSOR                      : ProcessTree for HUQfb2uepBfb.0
AccessNode(0) output=[g1.ID] SELECT g_0.ID AS c_0 FROM credit.TABLE1 AS g_0
ORDER BY c_0

2018-11-29 08:40:32.173 DEBUG 11812 ---
org.teiid.TXN_LOG                        : before
getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@5c92166b
(HUQfb2uepBfb)
2018-11-29 08:40:32.173 DEBUG 11812 ---
org.teiid.TXN_LOG                        : after
getOrCreateTransactionContext : HUQfb2uepBfb NONE ID:NONE
2018-11-29 08:40:32.173 DEBUG 11812 ---
org.teiid.BUFFER_MGR                     : Creating TupleBuffer: 3
batch size 256 of type PROCESSOR
2018-11-29 08:40:32.173 DEBUG 11812 ---
org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Create State
2018-11-29 08:40:32.174 DEBUG 11812 ---
org.teiid.BUFFER_MGR                     : HUQfb2uepBfb.0.0.1 Blocking on
source query HUQfb2uepBfb.0.0.1
2018-11-29 08:40:32.174 DEBUG 11812 ---
org.teiid.BUFFER_MGR                     : HUQfb2uepBfb.0 Blocking on
source request(s).
2018-11-29 08:40:32.174 DEBUG 11812 ---
org.teiid.PROCESSOR                      : Request Thread HUQfb2uepBfb.0 -
processor blocked
2018-11-29 08:40:32.174 DEBUG 11812 ---
org.teiid.PROCESSOR                      : Running task for parent thread
http-nio-8080-exec-3
2018-11-29 08:40:32.175 DEBUG 11812 ---
org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Processing
NEW request: SELECT g_0.ID AS c_0 FROM credit.TABLE1 AS g_0 ORDER BY c_0
2018-11-29 08:40:32.175 DEBUG 11812 ---
org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Obtained
execution
2018-11-29 08:40:32.175 DEBUG 11812 ---
org.teiid.COMMAND_LOG                    : START DATA SRC COMMAND:
startTime=2018-11-29
08:40:32.175 requestID=HUQfb2uepBfb.0 sourceCommandID=0 executionID=1
txID=null modelName=credit translatorName=db2 sessionID=HUQfb2uepBfb
principal=anonymous sql=SELECT g_0.ID AS c_0 FROM credit.TABLE1 AS g_0
ORDER BY c_0
2018-11-29 08:40:32.175 DEBUG 11812 ---
org.teiid.CONNECTOR                      : Source-specific command: SELECT
g_0."ID" AS c_0 FROM "TABLE1" AS g_0 ORDER BY c_0
2018-11-29 08:40:32.176 DEBUG 11812 ---
org.teiid.COMMAND_LOG                    : SOURCE SRC COMMAND:
endTime=2018-11-29
08:40:32.176 requestID=HUQfb2uepBfb.0 sourceCommandID=0 executionID=1
txID=null modelName=credit translatorName=db2 sessionID=HUQfb2uepBfb
principal=anonymous sourceCommand=[SELECT g_0."ID" AS c_0 FROM "TABLE1" AS
g_0 ORDER BY c_0]
2018-11-29 08:40:32.179 DEBUG 11812 ---
org.teiid.COMMAND_LOG                    : ERROR SRC COMMAND:
endTime=2018-11-29
08:40:32.179 requestID=HUQfb2uepBfb.0 sourceCommandID=0 executionID=1
txID=null modelName=credit translatorName=db2 sessionID=HUQfb2uepBfb
principal=anonymous
2018-11-29 08:40:32.180 WARN 11812 ---
org.teiid.CONNECTOR                      : Connector worker process failed
for atomic-request=HUQfb2uepBfb.0.0.1

org.teiid.translator.jdbc.JDBCExecutionException: -204
TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []
SQL: SELECT g_0."ID" AS c_0 FROM "TABLE1" AS g_0 ORDER BY c_0]
at
org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:127)
~[translator-jdbc-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358)
~[teiid-engine-10.1.0.jar:10.1.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_162]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_162]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_162]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
at
org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216)
~[teiid-engine-10.1.0.jar:10.1.0]
at com.sun.proxy.$Proxy90.execute(Unknown Source) ~[na:na]
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
teiid-engine-10.1.0.jar:10.1.0
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104)
teiid-engine-10.1.0.jar:10.1.0
at java.util.concurrent.FutureTask.run(FutureTask.java:266) na:1.8.0_162
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61)
teiid-engine-10.1.0.jar:10.1.0
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
teiid-engine-10.1.0.jar:10.1.0
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
teiid-engine-10.1.0.jar:10.1.0
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
teiid-engine-10.1.0.jar:10.1.0
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
na:1.8.0_162
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
na:1.8.0_162
at java.lang.Thread.run(Thread.java:748) na:1.8.0_162
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
SQLCODE=-204, SQLSTATE=42704, SQLERRMC=ABCD.TABLE1, DRIVER=4.11.77
at com.ibm.db2.jcc.am.gd.a(gd.java:676) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.gd.a(gd.java:60) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.gd.a(gd.java:127) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jn.c(jn.java:2561) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jn.d(jn.java:2549) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jn.a(jn.java:2025) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.a(kn.java:6836) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.cb.g(cb.java:140) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.cb.a(cb.java:40) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.q.a(q.java:32) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.rb.i(rb.java:135) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jn.ib(jn.java:1996) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.sc(kn.java:3058) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.b(kn.java:3841) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.fc(kn.java:702) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.executeQuery(kn.java:672) ~[db2jcc4-10.1.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_162]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_162]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_162]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
at
org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
~[tomcat-jdbc-8.5.14.jar:na]
at com.sun.proxy.$Proxy91.executeQuery(Unknown Source) ~[na:na]
at
org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119)
~[translator-jdbc-10.1.0.jar:10.1.0]
... 18 common frames omitted

2018-11-29 08:40:32.183 DEBUG 11812 ---
org.teiid.PROCESSOR                      : Request Thread HUQfb2uepBfb.0
with state PROCESSING
2018-11-29 08:40:32.184 DEBUG 11812 ---
org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Remove State
2018-11-29 08:40:32.185 DEBUG 11812 ---
org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Processing
Close : SELECT g_0.ID AS c_0 FROM credit.TABLE1 AS g_0 ORDER BY c_0
2018-11-29 08:40:32.185 DEBUG 11812 ---
org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Closed
execution
2018-11-29 08:40:32.185 DEBUG 11812 ---
org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Closed
connection
2018-11-29 08:40:32.185 DEBUG 11812 ---
org.teiid.COMMAND_LOG                    : END SRC COMMAND: endTime=2018-11-29
08:40:32.185 requestID=HUQfb2uepBfb.0 sourceCommandID=0 executionID=1
txID=null modelName=credit translatorName=db2 sessionID=HUQfb2uepBfb
principal=anonymous finalRowCount=0 cpuTime(ns)=15600100
2018-11-29 08:40:32.189 DEBUG 11812 ---
org.teiid.PROCESSOR                      : QueryProcessor: closing processor
2018-11-29 08:40:32.189 INFO 11812 ---
org.teiid.COMMAND_LOG                    : ERROR USER COMMAND:
endTime=2018-11-29
08:40:32.189 requestID=HUQfb2uepBfb.0 txID=null sessionID=HUQfb2uepBfb
principal=anonymous vdbName=spring vdbVersion=1.0.0 finalRowCount=null
2018-11-29 08:40:32.192 WARN 11812 ---
org.teiid.PROCESSOR                      : TEIID30020 Processing exception
for request HUQfb2uepBfb.0 'TEIID30504 credit: -204 TEIID11008:TEIID11004
Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS
c_0 FROM "TABLE1" AS g_0 ORDER BY c_0]'. Originally
TeiidProcessingException 'DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704,
SQLERRMC=ABCD.TABLE1, DRIVER=4.11.77' gd.java:676.

org.teiid.core.TeiidProcessingException: TEIID30504 credit: -204
TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []
SQL: SELECT g_0."ID" AS c_0 FROM "TABLE1" AS g_0 ORDER BY c_0]
at
org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:397)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:157)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:398)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:480)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:350)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276)
~[teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:340)
teiid-engine-10.1.0.jar:10.1.0
at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:255)
teiid-engine-10.1.0.jar:10.1.0
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_162]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_162]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_162]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
at
org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:213)
teiid-runtime-10.1.0.jar:10.1.0
at java.util.concurrent.FutureTask.run(FutureTask.java:266) na:1.8.0_162
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
teiid-engine-10.1.0.jar:10.1.0
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:264)
teiid-engine-10.1.0.jar:10.1.0
at
org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:211)
teiid-runtime-10.1.0.jar:10.1.0
at com.sun.proxy.$Proxy79.executeRequest(Unknown Source) na:na
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:709)
teiid-client-10.1.0.jar:10.1.0
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:551)
teiid-client-10.1.0.jar:10.1.0
at
org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:313)
teiid-client-10.1.0.jar:10.1.0
at
org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:72)
teiid-client-10.1.0.jar:10.1.0
at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:246)
teiid-olingo-10.1.0.jar:10.1.0
at
org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:350)
teiid-olingo-10.1.0.jar:10.1.0
at
org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:168)
teiid-olingo-10.1.0.jar:10.1.0
at
org.apache.olingo.server.core.requests.DataRequest$EntityRequest.execute(DataRequest.java:332)
odata-server-core-ext-4.4.0.jar:4.4.0
at
org.apache.olingo.server.core.requests.DataRequest.execute(DataRequest.java:255)
odata-server-core-ext-4.4.0.jar:4.4.0
at
org.apache.olingo.server.core.ServiceDispatcher.internalExecute(ServiceDispatcher.java:160)
odata-server-core-ext-4.4.0.jar:4.4.0
at
org.apache.olingo.server.core.ServiceDispatcher.execute(ServiceDispatcher.java:98)
odata-server-core-ext-4.4.0.jar:4.4.0
at
org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:67)
odata-server-core-ext-4.4.0.jar:4.4.0
at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:39)
teiid-olingo-10.1.0.jar:10.1.0
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
tomcat-embed-websocket-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.teiid.spring.odata.SpringODataFilter.internalDoFilter(SpringODataFilter.java:93)
spring-odata-1.0.0.jar:na
at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:96)
teiid-olingo-10.1.0.jar:10.1.0
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
com.nordea.security.spring.NordeaTokenAuthorizationFilter.doFilterInternal(NordeaTokenAuthorizationFilter.java:77)
springsecurity-1.1.4.jar:na
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
tomcat-embed-core-8.5.14.jar:8.5.14
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
na:1.8.0_162
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
na:1.8.0_162
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
tomcat-embed-core-8.5.14.jar:8.5.14
at java.lang.Thread.run(Thread.java:748) na:1.8.0_162
Caused by: org.teiid.translator.jdbc.JDBCExecutionException: -204
TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []
SQL: SELECT g_0."ID" AS c_0 FROM "TABLE1" AS g_0 ORDER BY c_0]
at
org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:127)
~[translator-jdbc-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358)
~[teiid-engine-10.1.0.jar:10.1.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_162]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_162]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_162]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
at
org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216)
~[teiid-engine-10.1.0.jar:10.1.0]
at com.sun.proxy.$Proxy90.execute(Unknown Source) ~[na:na]
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104)
~[teiid-engine-10.1.0.jar:10.1.0]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) na:1.8.0_162
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
teiid-engine-10.1.0.jar:10.1.0
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
~[teiid-engine-10.1.0.jar:10.1.0]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
na:1.8.0_162
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
na:1.8.0_162
... 1 common frames omitted
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
SQLCODE=-204, SQLSTATE=42704, SQLERRMC=ABCD.TABLE1, DRIVER=4.11.77
at com.ibm.db2.jcc.am.gd.a(gd.java:676) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.gd.a(gd.java:60) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.gd.a(gd.java:127) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jn.c(jn.java:2561) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jn.d(jn.java:2549) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jn.a(jn.java:2025) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.a(kn.java:6836) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.cb.g(cb.java:140) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.cb.a(cb.java:40) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.q.a(q.java:32) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.rb.i(rb.java:135) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jn.ib(jn.java:1996) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.sc(kn.java:3058) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.b(kn.java:3841) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.fc(kn.java:702) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.executeQuery(kn.java:672) ~[db2jcc4-10.1.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_162]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_162]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_162]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
at
org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
~[tomcat-jdbc-8.5.14.jar:na]
at com.sun.proxy.$Proxy91.executeQuery(Unknown Source) ~[na:na]
at
org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119)
~[translator-jdbc-10.1.0.jar:10.1.0]
... 18 common frames omitted

2018-11-29 08:40:32.197 DEBUG 11812 ---
org.teiid.PROCESSOR                      : Removing tuplesource for the
request HUQfb2uepBfb.0
2018-11-29 08:40:32.197 DEBUG 11812 ---
org.teiid.BUFFER_MGR                     : Removing TupleBuffer: 3
2018-11-29 08:40:32.197 DEBUG 11812 ---
org.teiid.PROCESSOR                      : HUQfb2uepBfb.0 Finished
Processing
2018-11-29 08:40:32.197 DEBUG 11812 ---
org.teiid.PROCESSOR                      :
org.teiid.core.TeiidProcessingException: TEIID30504 credit: -204
TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []
SQL: SELECT g_0."ID" AS c_0 FROM "TABLE1" AS g_0 ORDER BY c_0] Sending
error to client HUQfb2uepBfb.0
2018-11-29 08:40:32.198 INFO 11812 ---
org.teiid.COMMAND_LOG                    : END USER COMMAND: endTime=2018-11-29
08:40:32.198 requestID=HUQfb2uepBfb.0 txID=null sessionID=HUQfb2uepBfb
principal=anonymous vdbName=spring vdbVersion=1.0.0 finalRowCount=0
2018-11-29 08:40:32.200 WARN 11812 --- org.teiid.ODATA
                        : TEIID16052 Unable to process odata request due
to: TEIID30504 credit: -204 TEIID11008:TEIID11004 Error executing
statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS c_0 FROM
"TABLE1" AS g_0 ORDER BY c_0]

org.teiid.core.TeiidProcessingException: TEIID30504 credit: -204
TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []
SQL: SELECT g_0."ID" AS c_0 FROM "TABLE1" AS g_0 ORDER BY c_0]
at
org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:397)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:157)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:398)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:480)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:350)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276)
~[teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:340)
~[teiid-engine-10.1.0.jar:10.1.0]
at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:255)
~[teiid-engine-10.1.0.jar:10.1.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_162]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_162]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_162]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
at
org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:213)
~[teiid-runtime-10.1.0.jar:10.1.0]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_162]
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:264)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:211)
~[teiid-runtime-10.1.0.jar:10.1.0]
at com.sun.proxy.$Proxy79.executeRequest(Unknown Source) ~[na:na]
at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:709)
~[teiid-client-10.1.0.jar:10.1.0]
at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:551)
~[teiid-client-10.1.0.jar:10.1.0]
at
org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:313)
~[teiid-client-10.1.0.jar:10.1.0]
at
org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:72)
~[teiid-client-10.1.0.jar:10.1.0]
at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:246)
~[teiid-olingo-10.1.0.jar:10.1.0]
at
org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:350)
~[teiid-olingo-10.1.0.jar:10.1.0]
at
org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:168)
~[teiid-olingo-10.1.0.jar:10.1.0]
at
org.apache.olingo.server.core.requests.DataRequest$EntityRequest.execute(DataRequest.java:332)
~[odata-server-core-ext-4.4.0.jar:4.4.0]
at
org.apache.olingo.server.core.requests.DataRequest.execute(DataRequest.java:255)
~[odata-server-core-ext-4.4.0.jar:4.4.0]
at
org.apache.olingo.server.core.ServiceDispatcher.internalExecute(ServiceDispatcher.java:160)
~[odata-server-core-ext-4.4.0.jar:4.4.0]
at
org.apache.olingo.server.core.ServiceDispatcher.execute(ServiceDispatcher.java:98)
~[odata-server-core-ext-4.4.0.jar:4.4.0]
at
org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:67)
~[odata-server-core-ext-4.4.0.jar:4.4.0]
at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:39)
~[teiid-olingo-10.1.0.jar:10.1.0]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
~[tomcat-embed-core-8.5.14.jar:8.5.14]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
tomcat-embed-websocket-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.teiid.spring.odata.SpringODataFilter.internalDoFilter(SpringODataFilter.java:93)
spring-odata-1.0.0.jar:na
at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:96)
teiid-olingo-10.1.0.jar:10.1.0
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
com.nordea.security.spring.NordeaTokenAuthorizationFilter.doFilterInternal(NordeaTokenAuthorizationFilter.java:77)
springsecurity-1.1.4.jar:na
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
tomcat-embed-core-8.5.14.jar:8.5.14
at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
tomcat-embed-core-8.5.14.jar:8.5.14
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
na:1.8.0_162
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
na:1.8.0_162
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
tomcat-embed-core-8.5.14.jar:8.5.14
at java.lang.Thread.run(Thread.java:748) na:1.8.0_162
Caused by: org.teiid.translator.jdbc.JDBCExecutionException: -204
TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []
SQL: SELECT g_0."ID" AS c_0 t
org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:127)
~[translator-jdbc-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358)
~[teiid-engine-10.1.0.jar:10.1.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_162]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_162]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_162]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
at
org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216)
~[teiid-engine-10.1.0.jar:10.1.0]
at com.sun.proxy.$Proxy90.execute(Unknown Source) ~[na:na]
at
org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104)
~[teiid-engine-10.1.0.jar:10.1.0]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_162]
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
~[teiid-engine-10.1.0.jar:10.1.0]
at
org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
~[teiid-engine-10.1.0.jar:10.1.0]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
na:1.8.0_162
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
na:1.8.0_162
... 1 common frames omitted
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:
SQLCODE=-204, SQLSTATE=42704, SQLERRMC=ABCD.TABLE1, DRIVER=4.11.77
at com.ibm.db2.jcc.am.gd.a(gd.java:676) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.gd.a(gd.java:60) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.gd.a(gd.java:127) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jn.c(jn.java:2561) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jn.d(jn.java:2549) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jn.a(jn.java:2025) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.a(kn.java:6836) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.cb.g(cb.java:140) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.cb.a(cb.java:40) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.q.a(q.java:32) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.t4.rb.i(rb.java:135) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.jn.ib(jn.java:1996) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.sc(kn.java:3058) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.b(kn.java:3841) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.fc(kn.java:702) ~[db2jcc4-10.1.jar:na]
at com.ibm.db2.jcc.am.kn.executeQuery(kn.java:672) ~[db2jcc4-10.1.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_162]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_162]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_162]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]
at
org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
~[tomcat-jdbc-8.5.14.jar:na]
at com.sun.proxy.$Proxy91.executeQuery(Unknown Source) ~[na:na]
at
org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119)
~[translator-jdbc-10.1.0.jar:10.1.0]
... 18 common frames omitted

2018-11-29 08:40:32.205 DEBUG 11812 --- org.teiid.jdbc
                       : Statement closed successfully.
2018-11-29 08:40:32.206 DEBUG 11812 ---
org.teiid.SECURITY                       : closeSession HUQfb2uepBfb
2018-11-29 08:40:32.206 DEBUG 11812 ---
org.teiid.AUDIT_LOG                      :
2018-11-29 08:40:32.206 DEBUG 11812 ---
org.teiid.TXN_LOG                        : before
cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@5c92166b
(HUQfb2uepBfb,false)
2018-11-29 08:40:32.206 DEBUG 11812 ---
org.teiid.TXN_LOG                        : after cancelTransactions : null
2018-11-29 08:40:32.206 DEBUG 11812 --- org.teiid.jdbc
                       : Connection successfully closed.
Actions
12. Re: Teiid Spring Boot with IBMDB2

rareddy Nov 30, 2018 11:47 AM (in response to 13_abhi)

I am asking for the log from when you start the application, not when you issue the query. Also please attach the log, do not post into the forum, as it makes hard to scroll through since it is so long.
Actions
13. Re: Teiid Spring Boot with IBMDB2

13_abhi Dec 3, 2018 7:06 AM (in response to rareddy)
PFA-error logs while starting application

Error_AppStart.txt.zip 8.6 KB
Actions
14. Re: Teiid Spring Boot with IBMDB2

rareddy Dec 3, 2018 12:55 PM (in response to 13_abhi)
Add these properties to your "application.properties" file and restart

spring.datasource.test.importer.UseQualifiedName=true spring.datasource.test.importer.UseFullSchemaName=false

Hopefully, that should fix that.
Actions

1 2 Previous Next

Go to original post