Hi All,
I have a requirement like this. I have set of applications (application is a
java object). Every application has a set of fields (Field is a java object). Every field has set of attributes. I need to store multiple fields for a specified application at one go.
I have a stored procedure with following signature.
Where FIELDS_TYP is an OBJECT defined as follows. [I removed and renamed some of the fields to make it simple]
This stored procedure can take list of field objects in single invocation.
How should invoke this stored procedure with a list of field objects from java code in single invocation using Spring 3
JDBC module. I am not using any of the ORM tools.
Note: Since I want to write a generic code, I am not supposed to use any of the database specific APIs like ARRAY from Oracle.
Please suggest me some solution.
Thanks,
Chinna