You can translate the question and the replies:

Spring throws: "java.lang.IllegalStateException: Cannot load driver class: com.denodo.vdp.jdbc.Driver" on Data Source instantiation

Hi dears, I imported Denodo JAR using maven and I configured my app to access Denodo views with the following properties and driver class name: ``` spring.datasource.denodo.url: jdbc:vdb://<ip>:<port>/<db> spring.datasource.denodo.username: ** spring.datasource.denodo.password: ** spring.datasource.denodo.driver-class-name= com.denodo.vdp.jdbc.Driver ``` However, when I run the app I get the following exception: > Failed to instantiate [javax.sql.DataSource]: Factory method 'denodoDataSource' threw exception; nested exception is java.lang.IllegalStateException: Cannot load driver class: com.denodo.vdp.jdbc.Driver I'm not sure why the app isn't able to load the Driver. Do you have any thoughts? Thanks J,
24-07-2021 07:53:05 -0400

1 Answer

Hi, In order to connect to Denodo using JDBC, you could try to import the JAR file, denodo-vdp-jdbcdriver.jar to the project build path and change the dependency in the pom.xml to system scoped dependency or using file repository in the pom.xml and refer to the location of the JAR file and then check for the list of classNames imported. Alternatively, you could also follow the below steps for connecting to Denodo Platform: * Import the denodo-vdp-jdbcdriver.jar to the project build path. * Create a bean object with VDP connection settings and use the Bean as the Data source. * You could then configure JDBC connector by referencing the bean which was previously created. Hope this helps!
Denodo Team
26-07-2021 07:10:30 -0400
You must sign in to add an answer. If you do not have an account, you can register here