Mysql stored procedure array parameter from java

Question

I need to create mysql stored procedure which makes more than one insert at a time. To prevent many calls to database I need to use stored procedure. I have java.util.List<MyEntity> object of my data. MyEntity is an object which holds data which has to be inserted into table.

My question is how should I pass List object as mysql procedure parameter?

Thanks in advance.

duffymo · Accepted Answer · 2012-02-05 13:01:26Z

2

There's another way: batch the calls to the database. You don't need a stored procedure for this. Look at java.sql.PreparedStatement.addBatch.

answered Feb 5, 2012 at 13:01

duffymo

310k46 gold badges376 silver badges570 bronze badges

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

Collectives™ on Stack Overflow

Mysql stored procedure array parameter from java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related