This should be on the wolips list, not the wonder list -- CCing over
there.
Did you compare this to the ORIGINAL model prior to opening in Entity
Modeler? It looks like it's actually the order of the arguments in
the saved file that is wrong. I would expect "returnValue" to be
first in the list (0), then "modelID" (1). Is it possible you saved
then in Entity Modeler, which maybe messed up the order, then
reopened it in EOModeler and saved and it was already wrong by that
point? Or is the EOModeler one the original version?
ms
On Aug 27, 2007, at 5:59 PM, Anil Bajaj wrote:
> We are using WO with MS SQL Server and use a few Stored Procedures
> in our application. After building our application under Eclipse/
> WOLips we noticed that the order of arguments for our Stored
> Procedure calls is different than the column #'s as specified in
> the model.
>
> The .storedProcedure file generated by WOLips Entity Modeler
> differs from the one generated by Apple's EOModeler. In the one
> generate by EOModeler, the column #'s (specified in the column name
> attribute) have leading 0's:
>
> {
> arguments = (
> {
> allowsNull = Y;
> columnName = 001;
> externalType = int;
> name = modelID;
> parameterDirection = 1;
> precision = 10;
> valueClassName = NSNumber;
> valueType = i;
> },
> {
> columnName = 000;
> externalType = int;
> name = returnValue;
> parameterDirection = 2;
> precision = 10;
> valueClassName = NSNumber;
> valueType = l;
> }
> );
> externalName = "st_Calc_Model_Trade_Area";
> name = stCalcModelTradeArea;
> }
>
>
> While the one generated by Entity Modeler, has no leading 0's:
>
> {
> arguments = (
> {
> allowsNull = Y;
> columnName = 1;
> externalType = int;
> name = modelID;
> parameterDirection = 1;
> precision = 10;
> valueClassName = NSNumber;
> valueType = i;
> },
> {
> columnName = 0;
> externalType = int;
> name = returnValue;
> parameterDirection = 2;
> precision = 10;
> valueClassName = NSNumber;
> valueType = l;
> }
> );
> externalName = "st_Calc_Model_Trade_Area";
> name = stCalcModelTradeArea;
> }
>
>
> At runtime however, it looks like EOF or the JDBC plug-in is
> expecting to see the leading 0's and without them, is getting
> confused with the order of the arguments.
>
> I was wondering if anyone else has run into this and if there is a
> fix or workaround to address this issue.
>
> Thanks...
>
> Anil Bajaj
> ----------------------------------------------------------------------
> ---
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems? Stop.
> Now Search log events and configuration files using AJAX and a
> browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Wonder-disc mailing list
> Wonder-dis..ists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/wonder-disc
This archive was generated by hypermail 2.0.0 : Tue Aug 28 2007 - 07:16:22 EDT