I verified we are using java 1.8 on a denodo 7.0 installation. I have downlaoded v10.5fp11_linuxx64_dsdriver from ibm and loaded onto the vdp server drivers directory. I can now connect to my db2/udb luw instance. I can create a view just fine. but executing it throws this exception....QUERY [VIRTUAL] [ERROR]
QUERY [JDBC WRAPPER] [ERROR]
QUERY [JDBC ROUTE] [ERROR] Received exception with message ‘DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=LIMIT;;FETCH FIRST <n> ROWS ONLY, DRIVER=3.69.78’
I tried both drivers {db2jcc.jar and db2jcc4.jar) so not sure if I need another driver. the documentation also indicated to check tje java version and its ...
[ec2-user@ip-10-224-185-35 ~]$ java -version
openjdk version "1.8.0_252"
OpenJDK Runtime Environment (build 1.8.0_252-b09)
OpenJDK 64-Bit Server VM (build 25.252-b09, mixed mode)
[