java - Spring @Query Remove Quote -
want use table name in spring query, when execute got following error:
"could not extract resultset; sql [n/a]; nested exception org.hibernate.exception.sqlgrammarexception: not extract resultset"
because spring add automatically quote " when param string param ..
@query(value = "desc :name", nativequery = true) list<repositorycolumn> getcolumnfromrepository(@param("name") string name); in other case want "desc table_name" , not "desc 'table_name'"
any idea?
select * information_schema.columns table_name = :name try same way. instead of * can choose necessary columns
Comments
Post a Comment