<style>
/* Changing the layout to use less space for mobiles */
@media screen and (max-device-width: 480px), screen and (-webkit-min-device-pixel-ratio: 2) {
#email-body { min-width: 30em !important; }
#email-page { padding: 8px !important; }
#email-banner { padding: 8px 8px 0 8px !important; }
#email-avatar { margin: 1px 8px 8px 0 !important; padding: 0 !important; }
#email-fields { padding: 0 8px 8px 8px !important; }
#email-gutter { width: 0 !important; }
}
</style>
<div id="email-body">
<table id="email-wrap" align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#f0f0f0;color:#000000;width:100%;">
<tr valign="top">
<td id="email-page" style="padding:16px !important;">
<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#ffffff;border:1px solid #bbbbbb;color:#000000;width:100%;">
<tr valign="top">
<td bgcolor="#3b4d64" style="background-color:#3b4d64;color:#ffffff;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;line-height:1;"><img src="https://issues.jboss.org/s/en_US-g3yjjf/733/58/_/jira-logo-scaled.png" alt="" style="vertical-align:top;" /></td>
</tr><tr valign="top">
<td id="email-banner" style="padding:32px 32px 0 32px;">
<table align="left" border="0" cellpadding="0" cellspacing="0" width="100%" style="width:100%;">
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;padding:0;">
<img id="email-avatar" src="https://community.jboss.org/people/mr.bee/avatar/16.png" alt="" height="48" width="48" border="0" align="left" style="padding:0;margin: 0 16px 16px 0;" />
<div id="email-action" style="padding: 0 0 8px 0;font-size:12px;line-height:18px;">
<a class="user-hover" rel="mr.bee" id="email_mr.bee" href="https://issues.jboss.org/secure/ViewProfile.jspa?name=mr.bee" style="color:#003366;">Nabeel Ahmed</a>
created <img src="https://issues.jboss.org/images/icons/bug.gif" height="16" width="16" border="0" align="absmiddle" alt="Bug"> <a style='color:#003366;text-decoration:none;' href='https://issues.jboss.org/browse/TEIID-2076'>TEIID-2076</a>
</div>
<div id="email-summary" style="font-size:16px;line-height:20px;padding:2px 0 16px 0;">
<a style='color:#003366;text-decoration:none;' href='https://issues.jboss.org/browse/TEIID-2076'><strong>TEIID30376 The specified change set [...] against an inherently updatable view does not map to a key preserving group</strong></a>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="top">
<td id="email-fields" style="padding:0 32px 32px 32px;">
<table border="0" cellpadding="0" cellspacing="0" style="padding:0;text-align:left;width:100%;" width="100%">
<tr valign="top">
<td id="email-gutter" style="width:64px;white-space:nowrap;"></td>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Issue Type:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<img src="https://issues.jboss.org/images/icons/bug.gif" height="16" width="16" border="0" align="absmiddle" alt="Bug"> Bug
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Affects Versions:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
8.1 </td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Assignee:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a class="user-hover" rel="shawkins" id="email_shawkins" href="https://issues.jboss.org/secure/ViewProfile.jspa?name=shawkins" style="color:#003366;">Steven Hawkins</a>
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Created:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
18/Jun/12 5:37 AM
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Description:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<p style='margin-top:0;margin-bottom:10px;'>Every table and their columns are updatable.<br/>
And primary keys are properly defined. <br/>
Customer table has primary key of type string, and most of other tables have primary keys autoincreament.</p>
<p style='margin-top:0;margin-bottom:10px;'>Problem: Unable to create, Update and delete.</p>
<p style='margin-top:0;margin-bottom:10px;'>Error:<br/>
Internal Exception: org.teiid.jdbc.TeiidSQLException: TEIID30492 Remote org.teiid.api.exception.query.QueryValidatorException: TEIID30492 TEIID30376 The specified change set <span class="error">[CustomerID, Address, City, CompanyName, ContactName, ContactTitle, Country, Fax, Phone, PostalCode, Region]</span> against an inherently updatable view does not map to a key preserving group.</p>
<p style='margin-top:0;margin-bottom:10px;'>Error Code: 0</p>
<p style='margin-top:0;margin-bottom:10px;'>Call: INSERT INTO "Customers" ("CustomerID", "Address", "City", "CompanyName", "ContactName", "ContactTitle", "Country", "Fax", "Phone", "PostalCode", "Region") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</p>
<p style='margin-top:0;margin-bottom:10px;'> bind => <span class="error">[ID1339585889015, null, null, Company1339585889015, null, null, null, null, null, null, null]</span></p>
<p style='margin-top:0;margin-bottom:10px;'>Query: InsertObjectQuery({Customers ID1339585889015})</p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1494) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:838) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:906) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:592) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:253) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:193) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.insertObject(DatasourceCallQueryMechanism.java:342) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:162) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.queries.StatementQueryMechanism.insertObject(StatementQueryMechanism.java:177) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.insertObjectForWrite(DatabaseQueryMechanism.java:472) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.queries.InsertObjectQuery.executeCommit(InsertObjectQuery.java:80) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.queries.InsertObjectQuery.executeCommitWithChangeSet(InsertObjectQuery.java:90) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:287) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:58) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:844) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:743) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:108) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:85) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2871) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1516) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1498) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1449) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.CommitManager.commitNewObjectsForClassWithChangeSet(CommitManager.java:224) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:123) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3799) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1415) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:636) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1505) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:267) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1143) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:84) <span class="error">[eclipselink-2.3.2.jar:2.3.2.v20111125-r10461]</span></p>
<p style='margin-top:0;margin-bottom:10px;'> ... 42 more</p>
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Environment:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
Windows 7, Jboss 7.1.1, Teiid-8.1.alpha1 and HsqlDb
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Fix Versions:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
8.1 </td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Project:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a style="color:#003366;" href="https://issues.jboss.org/browse/TEIID">Teiid</a>
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Priority:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<img src="https://issues.jboss.org/images/icons/priority_blocker.gif" height="16" width="16" border="0" align="absmiddle" alt="Blocker"> Blocker
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Reporter:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a class="user-hover" rel="mr.bee" id="email_mr.bee" href="https://issues.jboss.org/secure/ViewProfile.jspa?name=mr.bee" style="color:#003366;">Nabeel Ahmed</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td><!-- End #email-page -->
</tr>
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:10px;line-height:14px;padding: 0 16px 16px 16px;text-align:center;">
This message is automatically generated by JIRA.<br />
If you think it was sent incorrectly, please contact your <a style='color:#003366;' href='https://issues.jboss.org/secure/ContactAdministrators!default.jspa'>JIRA administrators</a>.<br />
For more information on JIRA, see: <a style='color:#003366;' href='http://www.atlassian.com/software/jira'>http://www.atlassian.com/software/jira</a>
</td>
</tr>
</table><!-- End #email-wrap -->
</div><!-- End #email-body -->