You can translate the question and the replies:

Create Wrapper through Store procedre

Hi Team,, I am trying to create a wrapper through Java Store procedure and below is the code. String query2 = " CREATE OR REPLACE WRAPPER JDBC test_select " + " FOLDER = '/data sources' "+ " DATASOURCENAME=denodo_5_5_copy " + " SQLSENTENCE='DESC VQL VIEW bookbalancescontractlevel (''dropElements'' = ''no'', ''replaceExistingElements'' = ''yes'', ''includeDependencies'' = ''no'')' " + " OUTPUTSCHEMA ( " + " + result = 'result' :'java.lang.String' (sourcetypename='VARCHAR', sourcetypeid='12', sourcetypedecimals='0', sourcetypesize='65536') ESCAPE NOT NULL " + " NOT SORTABLE NOT UPDATEABLE " + " ); " + " CREATE OR REPLACE TABLE test_select I18N us_est ( " + " result:text (sourcetypedecimals = '0', sourcetypesize = '65536', sourcetypeid = '12') " + " ) FOLDER = '/data sources'; " + " ALTER TABLE test_select " + " CACHE OFF " + " TIMETOLIVEINCACHE DEFAULT " + " ADD SEARCHMETHOD test_select( " + " I18N us_est " + " CONSTRAINTS ( " + " ADD result NOS ZERO () " + " ) " + " OUTPUTLIST (result " + " ) " + " WRAPPER (jdbc test_select) " + " ) " ; executeUpdate(query2); But when i am executing the SP it's showing "Exception parsing query near ''. Could you please look into this and help me out ASAP. Thanks !!
user
01-02-2019 01:54:09 -0500

1 Answer

Hi, In Denodo Platform, the** executeUpdate** method executes only **INSERT**,** UPDATE** or **DELETE** query. At the moment, it is not possible to execute the **CREATE** query in the Denodo Platform 5.5. You can refer to the Denodo’s Javadoc located in <DENODO_HOME>/docs/vdp/api/index.html for more information. Hope this helps!
Denodo Team
01-02-2019 06:43:40 -0500
You must sign in to add an answer. If you do not have an account, you can register here