I'm working on a program to incrementally upgrade our application's database schema. Our app already uses Spring, so what I'd really like to do is use JdbcTemplate to execute DDL script fragments stored as class path resources (i.e. multiple DDL statements in a single string).
Is this feasible? What JdbcTemplate call should I be using? I tried using execute(String), but Oracle barfs with an "invalid character" error when it encounters the semi-colon used to separate statements.