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 !!