Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 360100

Summary: Java compile errors in generated SQL program
Product: z_Archived Reporter: Paul Hoffman <hoffmanp>
Component: EDTAssignee: 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:
Description Flags
Test case for defect
none
Supporting library for loading db / table none

Description Paul Hoffman CLA 2011-10-06 09:59:38 EDT
Created attachment 204667 [details]
Test case for defect

Compile errors in generated Java program related to:

result set variable, not nullable.
delete from result set
rs.setRelative
rs.setAbsolute

see attached test case program.
Comment 1 Paul Hoffman CLA 2011-10-06 10:00:11 EDT
Created attachment 204668 [details]
Supporting library for loading db / table
Comment 2 Joseph Vincens CLA 2011-10-06 15:48:01 EDT
fixed
I tried to run this but the egl is not correct, if you use a result set you must have a rs.setNext() before you get the value. 
I changed to 
			open rs from ds with #sql { 
				select id, aChar, aString, aFloat, aInt, aSmallInt, aBigInt 
				from MINITBL 
				where id > ?
				order by id asc
			}  		
			using row.id forUpdate;
			if(rs.setNext())//added**************
				get row from rs ;
still didn't work, the sql error is the result set was not opened for update.
Comment 3 Joseph Vincens CLA 2011-10-06 15:49:12 EDT
see previous comment
Comment 4 Paul Hoffman CLA 2011-10-17 12:19:12 EDT
Issues described in defect are fixed and verified.