send list of values to DB2 from java

[praveenkrishnan81]

Hi,

In our project, we are trying to do a bulk insertion of records into the DB2 system.
We have decided to write a stored proc to accomplish the same. Is there any way to pass on a list of values to do the insert.
A better explanation of the scenario would be the following example.

Let us assume i have a emp table in DB2 with structure as follows.
{
Emp_id,
Emp_name,
Emp_dept_id
}

In Java, i have list of Employee java objects. This needs to be inserted into te DB2 table

 

[Diancecht]

This should be carried out in the Java forum, this one is just for J2EE questions.

Anyway, I think you have to iterate through all your objects to collect the data and then

1.- Insert data on each iteration
2.- Gather all data and pass it to your stored procedure.

Cheers,
Dian

 

[praveenkrishnan81]

I think, i was not clear with the problem. I am trying to find out ways of sending an array to the DB2 stored proc. I searched in various forums, but lots of them tell that it is not possible to send array to DB2 Stored proc.

 

[Diancecht]

I don't think you can:

http://www.thescripts.com/forum/thread184910.html

Cheers,
Dian