You can translate the question and the replies:

How to obtain the input parameters of the custom stored procedure in the overridden initalize() method?

We want to execute some refresh vql command and get back the response through jdbc connection. Is it possible to obtain the input parameters in the initalize() method like we do in the doCall() And how do we extract and return the response of said vql after execution in initalize() Thank you
user
26-04-2021 10:02:44 -0400

1 Answer

Hi, The initialize() method initializes the Stored Procedure which accepts an input parameter **environment** and does not return anything. The environment object allows the stored procedure to communicate with the Virtual DataPort server to execute queries. ``` /** * This method is invoked when stored procedure is initialized * * @param environment object that allows communicate with VDP server */ public void initialize(DatabaseEnvironment environment) { super.initialize(environment); this.environment = environment; // TODO Complete with your own code } ``` For **[creating Custom Stored Procedure](https://community.denodo.com/docs/html/browse/8.0/en//vdp/developer/developing_extensions/developing_stored_procedures/developing_stored_procedures#developing-stored-procedures)**, use the Denodo4E plugin for Eclipse which provides tools for creating, debugging and deploying Denodo extensions, including Custom Functions and Custom Wrappers in the Denodo Platform. For detailed information, you can take a look at the **[Stored procedure (Denodo Virtual DataPort 8.0 API)](https://community.denodo.com/docs/html/browse/8.0/en/vdp/javadoc/com/denodo/vdb/engine/storedprocedure/StoredProcedure.html#initialize-com.denodo.vdb.engine.storedprocedure.DatabaseEnvironment-)** documentation and **[How to debug Denodo custom extensions with Eclipse](https://community.denodo.com/kb/view/document/How%20to%20debug%20Denodo%20custom%20extensions%20with%20Eclipse?category=Custom+Elements)** Knowledge Base Article Hope this helps!
Denodo Team
28-04-2021 07:57:50 -0400
You must sign in to add an answer. If you do not have an account, you can register here