6 Replies Latest reply on Aug 14, 2012 11:16 PM by gtduc

    auto incremented

    gtduc
    gtduc Aug 6, 2012 9:47 PM

      I create a table with AutoIncrement ID with MySQL, I also set auto incremented = true for that field in model, but when i try to insert data, i receive

      "Remote org.teiid.api.exception.query.QueryPlannerException: Required parameter 'CHANGING.Id' has no value was set or is an invalid parameter."

       

      Could you please help me?

      • 776 Views
      • Tags:
        • 1. Re: auto incremented
          rareddy
          rareddy Aug 7, 2012 10:22 AM (in response to gtduc)

          I am thinking this may be a regression. You can workaround by providing a default value for the column.

            • Actions
          • 2. Re: auto incremented
            shawkins
            shawkins Aug 7, 2012 11:01 AM (in response to rareddy)

            A default value isn't appropriate if you want to auto populate the incremented value. 

             

            What version are you on and are you perfoming the insert through a view?

             

            Steve

              • Actions
            • 3. Re: auto incremented
              gtduc
              gtduc Aug 7, 2012 11:57 PM (in response to shawkins)

              Steve,

               

              I'm working on MySQL 5.1, I also implement INSERT for view, I try to insert data with/without ID field, the result still the same. Ofcause that insert clause is tested ok with PHPAdmin

                • Actions
              • 4. Re: auto incremented
                shawkins
                shawkins Aug 8, 2012 7:33 AM (in response to gtduc)

                Can you post your vdb/query?

                  • Actions
                • 5. Re: auto incremented
                  shawkins
                  shawkins Aug 13, 2012 1:39 PM (in response to shawkins)

                  I could not reproduce this on 8.1 either directly against a source table with an auto_increment column or against an inherenetly updatable view with an auto_increment column.  If this sill occurring for you, then we'll need the Teiid version and a more complete description of the scenario (a vdb/query) to help reproduce.

                   

                  Steve

                    • Actions
                  • 6. Re: auto incremented
                    gtduc
                    gtduc Aug 14, 2012 11:16 PM (in response to shawkins)

                    I'm sorry for delay feedback, because of project deadline.

                    I use Teiid 7.7 with jboss 5.1.0.

                    I try to create a simple application with 1 table, this bug still happen

                      • Actions