ldap post

[prashanthi1]

Hi,

I created a virtual table from Ldap source table, and I am able to do a odata GET call. When I try to make POST on the same table. It is giving the below errors :

{

    "error": {

        "code": "ServerErrorException",

        "message": {

            "lang": "en-US",

            "value": "TEIID30492 TEIID30061 Insert is not allowed on the view LdapView.\"user\".  A procedure may be needed to handle the Insert since: The query defining an updatable view has no valid target for INSERTs."

        }

    }

}

My virtual table is a simple (select * from table) statement.

Do i need to do any changes in my model to make successful post?

"A procedure may be needed"  - is the procedure an update procedure?

Thanks in advance,

Prashanthi.

[shawkins]

Is the ldap source table marked as updatable?

> "A procedure may be needed"  - is the procedure an update procedure?

Yes, it means that an instead of insert trigger with a procedure could be needed.  But given you have a simple transformation, it should be that the source table is not marked as updatable.

[prashanthi1]

Hi Steven,

Thanks for your reply.

I have checked the "Supports Update" checkbox to true and i still get the error.

-Prashanthi.

[shawkins]

> I have checked the "Supports Update" checkbox to true and i still get the error.

If supports update is true on both the view and the source table, and you have a simple transformation, then it should work as expected.  The exception still makes it seem as if the source table is not updatable.

You could turn up the server log level and see if there is any relevant information in the logs.  Or provide a reproducing vdb.

[prashanthi1]

Hi Steven,

I am unable to attach a vdb here. it gives option to attach image or video.

-Prashanthi

[shawkins]

You can also open an issue.  What happens if over JDBC you directly issue your insert against the view?

[prashanthi1]

I get the same error even if i try to insert from JDBC.

I read from this document - .Teiid Designer User Guide  that for insert in to ldap we need to make some additional changes. but i am not getting it write in my table.

Please let me know if i need to make any additional changes other than what is mentioned in this document. I would open also open an issue for this.

-Prashanthi.

[shawkins]

As long as the view and the source table are marked as updatable, then you should be getting past this error.

[prashanthi1]

Hi Steven,

I have opened and issue fro this - [TEIID-3740] ldap post - JBoss Issue Tracker

Thanks,

Prashanthi.