You can translate the question and the replies:

Does denodo have a java method to return Denodo Home, or the path of an imported stored procedure?

I am writing a stored proc integration for Redis and Kafka and am putting connection parameters in a properties file. I would like to have the properties file and jar share a folder, regardless of where, but when I try to find the jar with java I am directed to denodo home / bin or to the denodo-commons-util.jar How can I lookup the location of the stored proc jar, or at least denodo home?
User
19-09-2019 14:37:19 -0400

1 Answer

Hi, I would make use of [Denodo4E](https://community.denodo.com/docs/html/browse/7.0/denodo4e/install_denodo4e/install_denodo4e#installing-denodo4e) extension to build a Custom Stored Procedure in Java using Eclipse. Then, I would deploy (using **deploy extension**) this Custom Stored Procedure directly into the Virtual DataPort Server. In cases where I want to retrieve the Custom Stored Procedure as a **jar file**, I would **export** the project as a Jar file by choosing **Export > Java > Jar file** option. Then, I would import this Jar file manually into the Virtual DataPort using the [File > Extensions Management](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/importing_extensions/importing_extensions#importing-extensions). You could have a look at the [Developing Stored Procedures](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/developing_extensions/developing_stored_procedures/developing_stored_procedures#developing-stored-procedures) section of Virtual DataPort Developer Guide for more information. Hope this helps!
Denodo Team
20-09-2019 07:37:49 -0400
You must sign in to add an answer. If you do not have an account, you can register here