| scripted datasource fetch metod exception [message #1768141] | 
Fri, 14 July 2017 00:05   | 
 
Eclipse User  | 
 | 
 | 
   | 
 
Hi i am new to birt i tried but fecth method returns null values  
 
in java class i return List<JSONObjects> 
 
open method  
 
importPackage(Packages.com.Jsontopdf); 
var myDataSet ; 
myDataSet=new JsonParse(); 
var myData ; 
myData= myDataSet.getJsonArray(); 
myIterator = myData.iterator(); 
 
fetch method 
if(myIterator.hasNext()){ 
var node ; 
node= myIterator.next(); 
 
 					 row["Requirement"] =node.getString("Requirement"); 
	                 row["Description"] = node.getString("Description"); 
	                 row["Remarks"] = node.getString("Remarks"); 
	                 row["WhocanSign"] = node.getString("WhocanSign"); 
	                 row["Format"] = node.getString("Format"); 
	                 row["Source"] =node.getString("Source"); 
	                 row["Required"] = node.getString("Required"); 
	                 row["UsedforBranch"] = node.getString("UsedforBranch"); 
	               
	                  
 
return true; 
}  
 
else return false 
 
close method 
myDataSet = null; 
myArrayList = null; 
myIterator = null; 
node = null; 
 my dataset preview result are empty 
in my design the given below exception occures  
 
- org.eclipse.birt.report.engine.api.EngineException: Data Set script method "Fetch" returned null; expected a Boolean value. at  
	 org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:249) at  
	 org.eclipse.birt.report.engine.script.internal.ScriptExecutor.addException(ScriptExecutor.java:238) at  
	 org.eclipse.birt.report.engine.script.internal.ScriptDataSetScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:165) at  
	 org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fetch(ScriptDataSetRuntime.java:103) at org.eclipse.birt.data.engine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor 
	 $CustomDataSet.fetch(PreparedScriptDSQuery.java:260) at org.eclipse.birt.data.engine.executor.dscache.DataSetToCache.fetchFromDataSet(DataSetToCache.java:243) at  
	 org.eclipse.birt.data.engine.executor.dscache.DataSetToCache.fetch(DataSetToCache.java:171) at org.eclipse.birt.data.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:218) at  
	 org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetch(RowResultSet.java:145) at org.eclipse.birt.data.engine.executor.cache.RowResultSet.doNext(RowResultSet.java:118) at  
	 org.eclipse.birt.data.engine.executor.cache.RowResultSet.next(RowResultSet.java:96) at  
	 org.eclipse.birt.data.engine.executor.cache.ExpandableRowResultSet.next(ExpandableRowResultSet.java:63) at  
	 org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populateData(SmartCacheHelper.java:316) at  
	 org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.java:285) at  
	 org.eclipse.birt.data.engine.executor.cache.SmartCacheHelper.getResultSetCache(SmartCacheHelper.java:246) at  
	 org.eclipse.birt.data.engine.executor.cache.SmartCache.<init>(SmartCache.java:73) at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.populateOdiResultSet(PassUtil.java: 
	 132) at org.eclipse.birt.data.engine.executor.transform.pass.PassUtil.pass(PassUtil.java:62) at 
 |  
 |  
  | 
 | 
Powered by 
FUDForum. Page generated in 0.02617 seconds