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!