You can translate the question and the replies:

Java SpringBoot application - Could not obtain connection to query metadata : com.denodo.connect.hibernate.dialect.DenodoDialect does not support ddl operations

Hello, Am using Spring Boot 2.3.4 and spring-boot-starter-data-jpa in order to connect to denodo 8.0 My application.yml is as follows spring: jpa: open-in-view: false show-sql: true generate-ddl: false hibernate.ddl-auto: none properties: hibernate: dialect: com.denodo.connect.hibernate.dialect.DenodoDialect jdbc.lob.non_contextual_creation: true datasource: url: jdbc:vdb://XXX.YYY.ZZZ.fr:9999/my_database driver-class-name: com.denodo.vdp.jdbc.Driver When i launch my springboot application, i keep getting this errors. 00:34:58.918 [] INFO org.hibernate.dialect.Dialect - HHH000400: Using dialect: com.denodo.connect.hibernate.dialect.DenodoDialect 00:34:59.031 [] WARN o.h.e.j.e.i.JdbcEnvironmentInitiator - HHH000342: Could not obtain connection to query metadata : com.denodo.connect.hibernate.dialect.DenodoDialect does not support ddl operations 00:34:59.031 [] INFO org.hibernate.dialect.Dialect - HHH000400: Using dialect: com.denodo.connect.hibernate.dialect.DenodoDialect 00:34:59.552 [] INFO o.h.e.t.j.p.i.JtaPlatformInitiator - HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform] 00:34:59.576 [] INFO o.s.o.j.LocalContainerEntityManagerFactoryBean - Initialized JPA EntityManagerFactory for persistence unit 'default' 00:35:01.546 [] INFO o.s.b.w.e.tomcat.TomcatWebServer - Tomcat started on port(s): 8001 (http) with context path '' Tomcat seems to have started but the connection to denodo seems to no have been established. Could someone help me.

1 Answer

Hi, As mentioned in the limitations of [**Denodo Hibernate Dialect - User Manual**](https://community.denodo.com/docs/html/document/denodoconnects/8.0/Denodo%20Hibernate%20Dialect%20-%20User%20Manual#h.azkv3fjcdjx8), the Denodo Hibernate Dialect does not support DDL operations. If I come across this error, I would set the log level as **DEBUG** in my client application for debugging the issue which is causing the error. Also, you could debug the issue by **[Setting the log level](https://community.denodo.com/docs/html/browse/8.0/vdp/vql/stored_procedures/predefined_stored_procedures/logcontroller#logcontroller)** in Virtual DataPort to DEBUG/TRACE and check the log files located under the directory "**<DENODO_HOME>\logs\vdp**". Depending on the ORM framework you are using, you can try using an alternative to Hibernate. If the issue persists and you are a user with valid support access, you can open a Support case in **[Denodo Support Site](https://support.denodo.com/)** and our Support Team will help you. Hope this helps!
Denodo Team
01-02-2021 07:04:36 -0500
You must sign in to add an answer. If you do not have an account, you can register here