mysql create procedure with spring framework in java

Question

I understood how to call a stored procedure with spring. is there a way to create a procedure from within java using spring, executing it and delete it afterwards, or have this procedures to be created before using the mysql-console?

bpgergo · Accepted Answer · 2011-11-10 11:39:09Z

1

It is possible to run DDL statements from JDBC (which is under the hood when you use Spring).

See an example here of dropping and creating a table: http://dev.mysql.com/doc/refman/5.0/es/connector-j-usagenotes-basic.html#connector-j-usagenotes-last-insert-id

stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
                            java.sql.ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate("DROP TABLE IF EXISTS autoIncTutorial");
stmt.executeUpdate(
        "CREATE TABLE autoIncTutorial ("
        + "priKey INT NOT NULL AUTO_INCREMENT, "
        + "dataField VARCHAR(64), PRIMARY KEY (priKey))");

answered Nov 10, 2011 at 11:39

bpgergo

16.1k5 gold badges48 silver badges70 bronze badges

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

1 Comment

zuloo Over a year ago

thank you, I was aware of this and was wondering if spring implemented something similar...

Collectives™ on Stack Overflow

mysql create procedure with spring framework in java

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related