ansaurus

Question

Multiple keys error when trying insert method

Answer 1

A:

You should use setGeneratedKeysColumnNames method in PreparedStatementCreatorFactory to assign names of the columns used as keys in your table.

hhbarriuso 2010-09-30 11:19:04

Answer 2

A:

I have encountered and solved this problem myself. I would suggest refactoring your approach to prepared statements. Here is what you need to do: Create a class that implements org.springframework.jdbc.core.PreparedStatementCreator. This class will handle how data is given to the prepared statement. Here is an example

private class MaterialPreparedStatementCreator implements PreparedStatementCreator {
    private MaterialBean material;

    public MaterialPreparedStatementCreator (MaterialBean material){
        this.material = material;
    }

    public PreparedStatement createPreparedStatement(Connection connection) throws SQLException {
        PreparedStatement ps = connection.prepareStatement(storeQuery, new String [] {"id"});
        ps.setString(1, material.getName()); 
                    /* add in the rest of the fields */
        return ps;
    }

}

Notice the call to connection.prepareStatement. The second parameter specifies which column you want to be used by the GeneratedKeyHolder.

Use your PreparedStatementCreator. For example:

public void createMaterial(MaterialBean material) {
    KeyHolder generatedKeyHolder = new GeneratedKeyHolder();
    this.getJdbcTemplate().update(new MaterialPreparedStatementCreator(material), generatedKeyHolder);
    material(generatedKeyHolder.getKey().longValue());
}

Chris J 2010-10-12 00:16:48

Answer 3

A:

Use the getKeys() method instead of getKey(), apparently you have more than one key specified.

In particular, as the error tells you: getKey() will Retrieve the first item from the first map, assuming that there is just one item and just one map, and that the item is a number..

Mark E 2010-10-12 00:21:40

ansaurus

tags:

views:

answers:

Multiple keys error when trying insert method

related questions