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

Popular posts from this blog

javascript - Create a stacked percentage column -

Optimising Firebase database by automatically overwriting data -

javascript - Angular UI-Grid customTemplate directive causing rows to load slowly/? -