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

    auto incremented

    gtduc

      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?

        • 1. Re: auto incremented
          rareddy

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

          • 2. Re: auto incremented
            shawkins

            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

            • 3. Re: auto incremented
              gtduc

              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

              • 4. Re: auto incremented
                shawkins

                Can you post your vdb/query?

                • 5. Re: auto incremented
                  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

                  • 6. Re: auto incremented
                    gtduc

                    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