Bugzilla – Full Text Bug Listing
| Summary: | Default add, get, replace fail for SQL record with column annotations | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | z_Archived | Reporter: | Paul Hoffman <hoffmanp> | ||||||||
| Component: | EDT | Assignee: | Project Inbox <edt.javagen-inbox> | ||||||||
| Status: | CLOSED FIXED | QA Contact: | |||||||||
| Severity: | normal | ||||||||||
| Priority: | P3 | CC: | jvincens | ||||||||
| Version: | unspecified | ||||||||||
| Target Milestone: | --- | ||||||||||
| Hardware: | PC | ||||||||||
| OS: | Windows XP | ||||||||||
| Whiteboard: | |||||||||||
| Attachments: |
|
||||||||||
Created attachment 204898 [details]
Library to load database for test case
fixed Reopened. Testcase reattached. Initial add throws following exception: add row Failure: Exception = Syntax error: Encountered "?" at line 1, column 5.: [sqlstate:42X01][sqlcode:30,000] Created attachment 205365 [details]
test case.
Error message in last commend came from another statement. Test case error. Closed and verified with altered test case. |
Created attachment 204897 [details] Test case for defect First of all the default SQL statement displayed when you hit cntl-1 for add and replace is incorrect. The default insert statement generated for an add should omit all columns with the annotations @GeneratedValue or @Column { insertable=false }. The for update of clause in the update statement generated for a replace statement should omit all columns the annotation @Column { updateable=false }. Once these issues are corrected please run sample test and correct any exceptions. See sample test program below.