Connect and discuss with the Denodo team and data management professionals and enthusiasts
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,
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!
