Posted: Mon Jun 15, 2009 7:19 am Post subject: Possible to executing SPs for wrapper objects (JDBC)?
Novice
Joined: 25 Nov 2008 Posts: 14
Hi.
I have the following situation. I have a table that I want to insert multiple row into before running the SP (type: AfterCreateSP).
When extracting the BO from the database with Business Object Desginer I only get a BO that can insert one row before executing the SP.
So I created a wrapper object around the "real" BO and set cardinality 'N'. Also I moved the AfterCreateSP element from the real BO to the wrapper.
When sending mesasges to the adapter I can see that it inserts all the rows into the table, but it never executed the SP.
Is it not possible to have a SP on a wrapper object at all? Perhaps someone have a better solution to solve this problem?
Also the SP takes one in parameter that is 'FIELD1' in the picture (all rows have the same value). How do I do that when the field doesn't exist on the wrapper object level.
Contains the Jdbctest_Customer business object. Application-specific information of this attribute contains the following information: SPN=UpdateAllColumns;IP=fid:CustomerName:CustomerNumber:CustomerDesc. UpdateAllColumns is the name of the stored procedure that uses all four business object attributes (fid,CustomerName,CustomerNumberandCustomerDesc) as input parameters. This stored procedure is executed after the Update operation is completed.
So the stored procedure can be invoked with arguments.
Can you try to execute the stored procedure in standalone mode(without the JDBC Adapter)? If the stored procedure runs fine, then there might be a problem in the way the adapter is calling the Stored Procedure.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum