Hi,
trying to use spring jdbctemplate to query vertica tables,but getting the below error,
--------------------------------------------------------------------------------
Root Exception stack trace:
com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](4566) ERROR: Relation "TABLE_NAME" does not exist
at com.vertica.util.ServerErrorData.buildException(Unknown Source)
at com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source)
at com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)
+ 3 more (set debug level logging or '-Dmule.verbose.exceptions=true' for everything)
********************************************************************************
if i use the same query generated by the spring jdbctemplate code on any tool(DB visualizer) it executes perfectly, but on program its gives above exception.
query generated from spring jdbctemplate code is as "select * from table_name table_name_alias".
Please let me do i need to prefix with schema name? or alias name syntax issue?.
regards
sandeep gowda
