0 Replies Latest reply: Jun 25, 2013 6:57 AM by VNemo RSS

    Create-Item stored procedure return error for hte parameter

    VNemo Community Member

      Hi,

       

      I'm getting the following error when I create an item with the data services:

       

      INFO: [Data Services] [DEBUG] SQL Assembler jdbc exception on operation=create-item error=com.microsoft.sqlserver.jdbc.SQLServerException: The value is not set for the parameter number 1.

          at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.ja va:190

       

      Configuration settings are:

       

            <source>flex.data.assemblers.SQLAssembler</source>

            <scope>application</scope>

            <metadata>

              <identity property="TO_ID" undefined-value="0" />

            </metadata>

       

              <create-item>

                <procedure name="spMob_TakeOff_Details_Header_Insert">

                  <procedure-param property-value="#ID#" type="OUT"/>

                  <procedure-param property-value="#Session_ID#" />

                  <procedure-param property-value="#Notes#" />

                </procedure>

              </create-item>

       

      ID always has value equal to 0, and this procedure always falls.

      Could anyone help or explain to fix this?

      Could this be bug of JDBC (https://bugs.eclipse.org/bugs/show_bug.cgi?id=385627)?