com.vertica.support.exceptions.SyntaxErrorException: [Vertica][VJDBC](4566)

sandeepgowdasandeepgowda Registered User

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

 

Comments

  • sandeepgowdasandeepgowda Registered User

    Adding more info

     

    query generated from  spring jdbctemplate code  is as "from table_name table_name_alias".

     

    is "select *" need to be prefixed?

     

    regards

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file