You can translate the question and the replies:

db2 jdbc connection errors

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) [
user
18-09-2020 15:24:42 -0400

1 Answer

Hi, I would refer to the similar community question [here](https://community.denodo.com/answers/question/details?questionId=9064u000000CeugAAC&title=db2+issues) for the answer.. Hope this helps!
Denodo Team
21-09-2020 07:34:33 -0400
You must sign in to add an answer. If you do not have an account, you can register here