Error in MyBatis while setting parameters

Question

I get this error when running select in MyBatis with PostgreSQL:

### The error may exist in data/mapper.xml
### The error may involve Transaccion.selectDeFraude-Inline
### The error occurred while setting parameters
### SQL: SELECT transaction_id, card_number, transaction_date, fraud FROM transactions.? ORDER BY card_number, transaction_date ASC;
### Cause: org.postgresql.util.PSQLException: ERROR: error de sintaxis en o cerca de «$1»

I get the error here, in the mapper.xml:

<select id="selectDeFraude" parameterType="String" resultMap="result">
    SELECT transaction_id, card_number, transaction_date, fraud FROM transactions.#{tabla} ORDER BY card_number, transaction_date ASC;
</select>

This is the method that calls the select:

public List<Transaccion> selectDeFraude(String tabla){

    SqlSession session = sqlSessionFactory.openSession();

    try {
        List<Transaccion> list = session.selectList("Transaccion.selectDeFraude", tabla);
        return list;
    } finally {
        session.close();
    }
}

If I replace #{tabla} with the name of the table it works just fine. None of the mapper methods work but all of them work if I replace the #{something} with the appropriate value.

There is a semicolon at the end of the SQL statement. The error may be caused by this semicolon, you can remove it and try again. — karfkars
– karfkars, Commented Feb 27, 2017 at 13:29

Kristijan Iliev · Accepted Answer · 2017-06-15 10:31:15Z

5

It's not exactly the answer to the question but I got it working now. When mapping a table name with myBatis you should use ${table_name} instead of #{table_name}, and it should be an attribute of the object you passed as an argument.

I changed my code to look like this:

<select id="selectDeFraude" parameterType="Transaccion" resultMap="result">
    SELECT transaction_id, card_number, transaction_date, fraud FROM transactions.${tabla} ORDER BY card_number, transaction_date ASC;
</select>

And I added the property tabla to it and know is working just fine.

edited Jun 15, 2017 at 10:31

Kristijan Iliev

5,01710 gold badges32 silver badges52 bronze badges

answered May 3, 2012 at 23:50

Topo

5,0109 gold badges51 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Error in MyBatis while setting parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related