2 Replies Latest reply on Sep 16, 2013 11:27 AM by devin pinkston

    Updates on Foreign Tables

    devin pinkston Newbie

      Hello all, I am running into an error when i issue this insert command against my VDB:

      INSERT INTO test_bulk (rowID, colf, colq, rowValue) VALUES ('testRow', 'testColf', 'testColq', 'testRowValue')

       

      My translator and resource adapter deploy just fine and I can perform select statements, now I am trying to work with updates and I am hitting this error when issuing the insert command above:

       

      TEIID30492 Metadata does not allow updates on the group: test_bulk

       

      Here is my VDB where I create 3 foreign tables and mark them all as Updateable, I also use a primary key on the table "test_bulk" to see if that would help, but no luck.

       

      Is my VDB off?  It appears I am not even getting into my translator, I have been trying to throw out sysouts all over the place.

       

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

      <vdb name="newVDB" version="1">

           <model name="myModel">

              <source name="local" translator-name="xTrans" connection-jndi-name="java:/myDS"/>

              <metadata type="DDL"><![CDATA[

              CREATE FOREIGN TABLE  foods (    

                rowID varchar (20),

                colf varchar (20),

                colq varchar (20),   

                rowValue varchar (20),

            PRIMARY KEY (rowID)          

              )OPTIONS(UPDATABLE 'TRUE');    

              

               CREATE FOREIGN TABLE  sample (    

                rowID varchar (20),

                colf varchar (20),

                colq varchar (20),   

                rowValue varchar (20),

            PRIMARY KEY (rowID)          

              )OPTIONS(UPDATABLE 'TRUE');

        

               CREATE FOREIGN TABLE  test_bulk (    

                rowID varchar (20) NOT NULL,

                colf varchar (20),

                colq varchar (20),   

                rowValue varchar (20),

            PRIMARY KEY (rowID)          

              ) OPTIONS (UPDATEABLE 'TRUE');  

              

              ]]> </metadata>

          </model>

      </vdb>

       

      Thank you!