Exception while executing the alter to add column using namedjdbctemplate

Asked Nov 07 '14 at 07:37

Active Jun 11 '16 at 19:59

Viewed 510 times

I have a alter query

ALTER TABLE Table_name  ADD(coumn1  DOUBLE,coumn2  DOUBLE);

I am using

this.namedParameterJdbcTemplate.execute(alterTableSQL, namedValues, new PreparedStatementCallback<Boolean>() {
    @Override
    public Boolean doInPreparedStatement(PreparedStatement ps) throws SQLException, DataAccessException {
        return ps.execute();
    }
});

While executing the statement, it is throwing me the following exception.

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [ALTER TABLE <sample>  ADD (
 coumn1  DOUBLE,
 coumn2  DOUBLE
);]; nested exception is org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "ALTER TABLE TEMPLATE_1  ADD ([*]
 coumn1  DOUBLE,
 coumn2  DOUBLE
); "; expected "identifier"; SQL statement:
ALTER TABLE template_1  ADD (
 coumn1  DOUBLE,
 coumn2  DOUBLE
); [42001-160]

How should I proceed on this?

edited Jun 11 '16 at 19:59

Gangaraju

4,406
9
45
77

asked Nov 07 '14 at 07:37

vamsi

1,219
1
9
15

1

Could you add the java code where you are constructing the query string? – Mithun Nov 07 '14 at 08:58
Are you using MySQL or H2? Your question is tagged 'mysql' but your exception stacktrace mentions H2. – Luke Woodward Nov 08 '14 at 13:08
For my test cases I am using H2. – vamsi Nov 17 '14 at 09:27

Exception while executing the alter to add column using namedjdbctemplate

0 Answers0