Connecting to Denodo Server using JDBC
Hi Rapidminer commnunity!
I'm trying to connect Rapidminer Studio to a Denodo server as a database adding a new JDBC driver. When clicking on the "Test Connection" button I'm getting the error "attempt to add a Permission to a readonly Permissions object" and I can't continue. Do you know what could be the reason for the error and if there is any way to fix it or debug it?
Thank you for your help!
Find more posts tagged with
This looks like a permission issue, do you have full read/write access? From the error msg it looks like you only have read permissions?
Hi,
RapidMiner Studio 7.3.1 contains a workaround for this and should therefore work.
If anyone is interested, the root cause for this is a bug in Java itself which Denodo runs into when using an unconventional way to communicate with the database.
Regards,
Marco
This is the log obtained:
WARNING: Error: Failed to load table data: java.sql.SQLException: attempt to add a Permission to a readonly Permissions object
com.rapidminer.repository.RepositoryException: Failed to load table data: java.sql.SQLException: attempt to add a Permission to a readonly Permissions object
at com.rapidminer.extension.jdbc.repository.db.DBConnectionFolder.ensureLoaded(DBConnectionFolder.java:242)
at com.rapidminer.extension.jdbc.repository.db.DBConnectionFolder.getSubfolders(DBConnectionFolder.java:147)
at com.rapidminer.repository.gui.RepositoryTreeModel$3.run(RepositoryTreeModel.java:407)
Caused by: java.sql.SQLException: attempt to add a Permission to a readonly Permissions object
at com.denodo.vdb.jdbcdriver.dao.DAOVDBProxy.connect(DAOVDBProxy.java:184)
at com.denodo.vdb.jdbcdriver.VDBJDBCConnection.getConnection(VDBJDBCConnection.java:124)
at com.denodo.vdb.jdbcdriver.VDBJDBCDriver.connect(VDBJDBCDriver.java:197)
at com.rapidminer.extension.jdbc.tools.jdbc.DriverAdapter.connect(DriverAdapter.java:40)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.rapidminer.extension.jdbc.tools.jdbc.DatabaseHandler.connect(DatabaseHandler.java:273)
at com.rapidminer.extension.jdbc.tools.jdbc.DatabaseHandler.getConnectedDatabaseHandler(DatabaseHandler.java:209)
at com.rapidminer.extension.jdbc.repository.db.DBConnectionFolder.ensureLoaded(DBConnectionFolder.java:235)
... 2 more
Do you think this could be caused by the security restrictions explained http://docs.rapidminer.com/developers/security/ ? In that case how can we solve the issue or certify the Denodo's JDBC driver so it can be used with RapidMiner?
Thanks!