Binding table names to SQL query using JDBI

Question

I am issuing a simple mysql select query using JDBI. In that if I try to bind the table name, I am getting wrong SQL syntax error.

Code snippet:

@SqlQuery("select * from <table> where rowid=:rowid")
@SingleValueResult
@Mapper(ContentRecordMapper.class)
public abstract Optional<Document> getRecord(@Define("table") String table, @Bind("rowid") String rowid);

If I execute this, I am getting

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<table> where rowid='row1'' at line 1 [statement:"select * from <table> where rowid=:rowid", located:"select * from <table> where rowid=:rowid", rewritten:"/* ContentDAO.getRecord */ select * from <table> where rowid=?", arguments:{ positional:{}, named:{rowid:'row1'}, finder:[]}]

If I hard code the table name, I am getting proper results. Kindly help. Thanks

Community · Accepted Answer · 2017-05-23 12:31:22Z

2

You should annotate with @UseStringTemplate3StatementLocator. It was already discussed here.

edited May 23, 2017 at 12:31

CommunityBot

11 silver badge

answered Jan 8, 2016 at 6:47

Manikandan

3,1752 gold badges22 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Binding table names to SQL query using JDBI

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related