DV REST.war has wrong bindings for composite primary keys

Solution Verified - Updated -

Issue

  • REST war file created by Teiid Designer has wrong bindings for composite primary keys.
  • It replaced the string input field with the timestamp input field and vice-versa. pk_timestampfield_in should be timestamp, and it is accepting string only, pk_stringfield_in should be string, and it is accepting timestamp only
  • JSON response shows value entered in pk_timestampfield_in field returned in the pk_stringfield_in field and vice-versa

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.1
  • Red Hat JBoss Developer Studio (JBDS) 8.1
  • Teiid Designer plugin for JBDS 9.0.2
  • Created REST war file via:
1. create a simple virtual table with a composite primary key
2. right click on the canvas -> modeling -> generate REST virtual procedures -> choose the virtual table
3. preview the results. it will ask the input values with correct field names
4. add the model to the vdb file and deploy it
5. right click on the vdb file -> modeling -> generate rest war
6. deploy the rest war

access it on the browser:
<host>:<port>/<context-root-of-rest-war>

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content