You can translate the question and the replies:

Executing multiple queries separated by semicolon through python

Hi, Is there any way of executing multiple queries separated by semicolon through jdbc connection via python? Thanks, Aashutosh
user
07-06-2022 04:47:51 -0400
code

1 Answer

Hi, I would connect to Denodo from Python using JDBC driver using the **jaydebeapi** library that is compatible with the Python version and by following the steps mentioned in the Knowledge Base article [How to connect to Denodo from Python - a starter for Data Scientists.](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Denodo%20from%20Python%20-%20a%20starter%20for%20Data%20Scientists?category=Consumers) Please note that when you execute multiple queries separated by semicolon in Denodo, batch queries will run but no data will be returned. You can have a look at the section [Access Through JDBC](https://community.denodo.com/docs/html/browse/latest/en/vdp/developer/access_through_jdbc/access_through_jdbc#access-through-jdbc) of the Virtual DataPort Developer Guide for more information. Hope this helps!
Denodo Team
08-06-2022 00:13:05 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here