Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 363484 - getting table content - error
Summary: getting table content - error
Status: CLOSED DUPLICATE of bug 363498
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: EDT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows 7
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-11-10 10:42 EST by Chris Houben CLA
Modified: 2017-02-23 14:15 EST (History)
1 user (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Houben CLA 2011-11-10 10:42:16 EST
Build Identifier: 20110916-0149 (nighly build)

// basic library
library customerLib
	
	connUrl string = "jdbc:derby:C:\\Users\\ASIST\\Desktop\\EGLDerbyR7\\EGLDerbyR7;create=true";
	ds SQLDataSource = new SQLDataSource(connUrl);
	function functionName()
		
		cUSTOMER CUSTOMER?;
		
		get cUSTOMER from ds
			with
				#sql{
					select
						*
					from
						CUSTOMER t1
			--		where
			--			* = ?
					order by
						CUSTOMER.CUSTOMER_ID asc
				};
	end

record CUSTOMER type Entity{@table{name = "CUSTOMER"}}
    CUSTOMER_ID int{@id};
    FIRST_NAME string?;
    LAST_NAME string?;
    PASSWORD string?;
    PHONE string?;
    EMAIL_ADDRESS string?;
    STREET string?;
    APARTMENT string?;
    CITY string?;
    STATE string?;
    POSTALCODE string?;
    DIRECTIONS string?;
end

error on the get statement:

IWN.JavascriptGen.9998.e 14/282 Exception occurred: No such method genStatementBody(org.eclipse.edt.mof.eglx.persistence.sql.impl.SqlGetByKeyStatementImpl, 
 org.eclipse.edt.gen.javascript.Context, org.eclipse.edt.mof.codegen.api.TabbedWriter, ) for any template for Class org.eclipse.edt.mof.eglx.persistence.sql.impl.SqlGetByKeyStatementImpl

Reproducible: Sometimes
Comment 1 Joseph Vincens CLA 2011-11-10 11:33:30 EST
The problem is the library is being generated for javascript and JS gen does not support SQL.
To eliminate the problem you will need to turn off the JavaScript generator for the library, package, or project. Select the library, package, or project right click and select properties. Under EGL Compiler check Override generation settings and uncheck the JavaScript generator save, then rebuild the project.

We already have a general bug open for JavaScript generation validation.

*** This bug has been marked as a duplicate of bug 363498 ***