How can I pass variable instead table name in @Query annotation in Spring boot?

Asked Dec 06 '19 at 00:29

Active Dec 06 '19 at 00:29

Viewed 164 times

I want to pass variable instead table name using @Query annotation but doesn't work..

@Modifying
 @Query(value="insert into :table (name,password) values (:name,:password)",nativeQuery=true) 
 void add  (@Param(":table") String table,@Param("name") String name,@Param("password") String password);

please, I want to pass variable instead table name what ever the way is.

asked Dec 06 '19 at 00:29

Ahmed Sakr

1

Looks like you have typo `@Param(":table")`, it should be `@Param("table")` – Sunil Dabburi Dec 06 '19 at 02:43
I changed it and also not working – Ahmed Sakr Dec 06 '19 at 10:28
You can try this: `"insert into " + table + " (name...`. Also, remove `@Param` for table – Sunil Dabburi Dec 06 '19 at 15:25
and how can i pass dynamic variable from out side the interface ? – Ahmed Sakr Dec 06 '19 at 23:35

How can I pass variable instead table name in @Query annotation in Spring boot?

0 Answers0