You can translate the question and the replies:

Adding Denodo embedded Derby 10 DB as a datasource

Hi, I'm trying to add the embedded Derby database as a datasource in Denodo 8 (on the same machine) but I get "Connection Refused". I'm using the following settings: Database adapter: Derby 10 Driver class path: derby-10 Driver class: org.apache.derby.jdbc.ClientDriver Database URI: jdbc:derby://localhost:1527/cache Transaction isolation: Database default Authentication: Use login and password Login: ***** Password: ***** I get the following message when I click Test connection: Unable to establish connection: java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused (Connection refused) Any ideas what might be wrong?
user
20-01-2023 10:38:09 -0500
code

3 Answers

Hi, I encountered the same error while connecting to Derby 10 database as a datasource. To overcome this, you could navigate to "Administration > Server Configuration > Embedded Derby server configuration" and turn on "**Enable Remote Access**". Or, you could execute the following property in the VQL Shell, `set 'com.denodo.vdb.cache.jdbc.derbyCacheRemoteAccess'='ON'` Once done, you’ll be able to successfully connect to Derby 10 database. If you require further assistance and if you are a valid support user, you could create a support case on Denodo Support Site so that our team will assist you. Hope this helps!
Denodo Team
23-01-2023 03:20:48 -0500
code
That works. Thanks.
user
23-01-2023 04:25:49 -0500
Hi, I am glad that it worked for you!
Denodo Team
23-01-2023 04:43:45 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here