[TUSCANY-957] DAS generates invalid INSERT statement when no properties are set on the new DO

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Java-SCA-M2
• Component/s: Java DAS RDB
• Assignee: Brent Daniel
• Reporter: Kevin Joe Williams
• Created: 30/Nov/06 05:30
• Updated: 19/Sep/10 11:24
• Resolved: 05/Dec/06 18:33

Description

If a new DO is created but no properties are set then the DAS generates an invalid INSERT statement that looks something like this:

"insert into COMPANY( values ("

The following test case (added to /das/src/test/java/org/apache/tuscany/das/rdb/test/GeneratedId.java) illustrates this bug:

/**

• Test insert into row with generated ID and no attributes set
  */
  public void testInsert5() throws Exception { DAS das = DAS.FACTORY.createDAS(getConfig("CompanyConfig.xml"), getConnection()); Command select = das.getCommand("all companies"); DataObject root = select.executeQuery(); root.createDataObject("COMPANY"); das.applyChanges(root); // Verify insert root = select.executeQuery(); assertEquals(4, root.getList("COMPANY").size()); }