Exception: PreparedStatementCallback; SQL []; Generated keys not requested.


      Click here to attend Spring Framework 4.x and certification course with a discount

Changing the MySQL connector from

mysql-connector-java-5.1.15-bin.jar to

mysql-connector-java-5.1.2.jar fixed the problem that I had.

org.springframework.dao.TransientDataAccessResourceException:
PreparedStatementCallback; SQL []; Generated keys not requested.
You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate()
or Connection.prepareStatement().; nested exception is java.sql.SQLException:
Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to
Statement.executeUpdate() or Connection.prepareStatement().     
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate
(SQLStateSQLExceptionTranslator.java:107)     
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate
(AbstractFallbackSQLExceptionTranslator.java:72)     
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate
(AbstractFallbackSQLExceptionTranslator.java:80)     
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate
(AbstractFallbackSQLExceptionTranslator.java:80)     
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)     
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:843)    

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s