Description Chris Houben 2011-11-14 06:13:24 EST

Build Identifier: 20110916-0149 (nighly build)

I turned off javascript generation for my libraries, to use SQL statements in them.
But I have to init my SQLDataSource in every function, otherwise I get in debug:
A null value was used.
java.lang.NullPointerException
	at libraries.customerLib.getCustomerList(customerLib.java:64)
	at server.progtest.main(progtest.java:39)
	at org.eclipse.edt.javart.resources.RunUnitBase.start(RunUnitBase.java:244)
	at server.progtest.main(progtest.java:22)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.eclipse.edt.javart.ide.MainProgramLauncher.main(MainProgramLauncher.java:68)

In Programs, this is not an issue.

Reproducible: Always

Steps to Reproduce:
code example that gives error:
library customerLib
	
//	//connUrl string = "jdbc:derby:NewDerby;create=true;";

	myCustomers CUSTOMER[]{};
	myCustomer CUSTOMER;
	rs SQLResultSet?;
	ds SQLDataSource?{@resource{bindingkey = "NewDerby"}};
	
	function getCustomerList() returns(CUSTOMER[]);
	//connUrl string = "jdbc:derby:NewDerby;create=true;";
	
		open rs from ds with #sql{select * from egl.customer order by customer_id};
		
		while (rs.setNext())
			get myCustomer from rs;
			myCustomers.appendElement(myCustomer);			
		end
		return(myCustomers);
	end	
end

code example that runs OK:
library customerLib
	
//	//connUrl string = "jdbc:derby:NewDerby;create=true;";

	myCustomers CUSTOMER[]{};
	myCustomer CUSTOMER;
	rs SQLResultSet?;
	
	
	function getCustomerList() returns(CUSTOMER[]);
	//connUrl string = "jdbc:derby:NewDerby;create=true;";
		ds SQLDataSource?{@resource{bindingkey = "NewDerby"}};
		open rs from ds with #sql{select * from egl.customer order by customer_id};
		
		while (rs.setNext())
			get myCustomer from rs;
			myCustomers.appendElement(myCustomer);			
		end
		return(myCustomers);
	end	
end