Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 360100 - Java compile errors in generated SQL program
Summary: Java compile errors in generated SQL program
Status: CLOSED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: EDT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-06 09:59 EDT by Paul Hoffman CLA
Modified: 2017-02-23 14:16 EST (History)
1 user (show)

See Also:

Attachments
Test case for defect (2.92 KB, application/octet-stream)
2011-10-06 09:59 EDT, Paul Hoffman CLA 		no flags Details
Supporting library for loading db / table (3.53 KB, application/octet-stream)
2011-10-06 10:00 EDT, Paul Hoffman CLA 		no flags Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.