Re: JavaLoader and CFJasperReport

[Mark Mandel]

This sounds like a job for....

https://github.com/markmandel/JavaLoader/wiki/Switching-the-ThreadContextClassLoader

Mark

On Mon, Jan 21, 2013 at 7:44 PM, Raffaele Castagno <raffaele...@gmail.com> wrote:

Hi everyone,

I'm trying to adapt CFJasperReport (https://github.com/denuno/cfjasperreport) to run under both Railo and ColdFusion,

and I tried to use javaLoader to isolate jasper from the cf classloader, to avoid conflicts with the jasper embedded in ColdFusion.

I instantiate the loader this way:

variables.loader = createObject("component", "javaloader.JavaLoader").init(loadPaths=libpaths);

where libpaths is the list of all jar dependencies,

and use it to create all needed jasper objects.

Problem is: apparently, under Railo everything works as expected, but in CF I get this strange error:

Class "net.sf.jasperreports.engine.query.JRJdbcQueryExecuterFactory" should be compatible with "net.sf.jasperreports.engine.query.JRQueryExecuterFactory"

As far as I can tell, it seems that the Jasper instance runs on the original ClassLoader, and tries to use an incompatible JRJdbcQueryExecuterFactory,

but I can't understand why.

At the bottom of this post, the source of my customtag.

Please tell me if you need more informations.

Thanks

Raffaele

<cfcomponent name="jasperreport">

<!--- Meta data --->

<cfset this.metadata.attributetype="fixed" />

<cfset this.metadata.attributes={

action= {required=false,type="string",default="runReport"},

jrxml= {required=false,type="string",default=""},

exporttype= {required=false,type="string",default="pdf"},

exportfile= {required=false,type="string",default=""},

dsn= {required=false,type="string",default=""},

datasource= {required=false,type="string",default=""},

query= {required=false,type="Object"},

params= {required=false,type="struct"},

sqlstring= {required=false,type="string",default=""},

datafile= {required=false,type="any",default=""},

resultsVar= {required=false,type="string",default="report"},

resourcebundle = {required=false,type="string",default=""},

datasourcexpath= {required=false,type="string",default=""},

filename= {required=false,type="string",default="report"},

forceDownload= {required=false,type="boolean",default="false"}

} />

<cffunction name="init" output="no" returntype="void" hint="invoked after tag is constructed">

<cfargument name="hasEndTag" type="boolean" required="yes" />

<cfargument name="parent" type="component" required="no" hint="the parent cfc custom tag, if there is one" />

<cfset var libs = "" />

<cfset variables.hasEndTag = arguments.hasEndTag />

<cfset var libpaths = []>

<CFDIRECTORY NAME="depend"

 DIRECTORY="#ExpandPath('jars')#" 

 FILTER="*.jar">

 

<cfloop query="depend">

<!--- add the javaloader dynamic proxy library to javaloader --->

<cfset ArrayAppend(libpaths, expandPath("jars/#name#"))>

</cfloop>

<!---

<cfdump var="#libpaths#">

<cfabort>

--->

<cfscript>

ArrayAppend(libpaths, expandPath("/javaloader/support/cfcdynamicproxy/lib/cfcdynamicproxy.jar"));

//we HAVE to load the ColdFusion class path to use the dynamic proxy, as it uses ColdFusion's classes

variables.loader = createObject("component", "javaloader.JavaLoader").init(loadPaths=libpaths);

//variables.loader = createObject("component", "javaloader.JavaLoader").init(loadPaths=libpaths, parentClassLoader=true);

//cur = variables.loader.create("java.lang.Thread").currentThread();

//save = cur.getContextClassLoader();

//newLoader = variables.loader.create("net.sf.jasperreports.engine.JasperCompileManager").getClass().getClassLoader();

//cur.setContextClassLoader(newLoader);

</cfscript>

<!---

<cfdump var="#variables.loader.getClassLoadPaths()#">

<cfdump var="#variables.loader#">

<cfabort>

--->

</cffunction>

<!---

<cffunction name="throw">

<cfargument name="message" />

<cfargument name="error" />

<cfif structKeyExists(arguments,"error")>

<!--- <cfset request.debug(error) /> --->

<cftry>

<cfthrow type="cfjasperreport.error" message="#message#" detail="#error.stacktrace#" />

<cfcatch>

<cfthrow type="cfjasperreport.error" message="#message#" detail="#error.toString()#" />

</cfcatch>

</cftry>

</cfif>

<cfthrow type="cfjasperreport.error" message="#message#" />

</cffunction>

 --->

<cffunction name="onStartTag" output="yes" returntype="boolean">

<cfargument name="attributes" type="struct" />

<cfargument name="caller" type="struct" />

<cfscript>

var report = "";

var runFunk = this[attributes.action];

if(attributes.dsn neq "") {

attributes.datasource = attributes.dsn;

}

var results = runFunk(argumentCollection=attributes);

if(attributes.action == "runReport") {

if(attributes.exportfile gt "") {

reportToFile(results,attributes.exportfile);

} else {

download("#attributes.filename#.#attributes.exporttype#",results,attributes.forceDownload);

}

}

caller[attributes.resultsVar] = results;

</cfscript>

<cfif not variables.hasEndTag>

<cfset onEndTag(attributes,caller,"") />

</cfif>

<cfreturn variables.hasEndTag />

</cffunction>

<cffunction name="runReport">

<cfargument name="jrxml" type="string" required="yes" />

<cfargument name="dataSource" default="" />

<cfargument name="datafile" default="" />

<cfargument name="exportType" default="pdf" />

<cfargument name="reportparams" default="#structNew()#" />

<cfargument name="download" default="no" />

<cfargument name="newquery" default="" />

<cfargument name="query" />

<cfargument name="resourcebundle" default="" />

<cfargument name="locale" default="US" />

<cfargument name="localeLanguage" default="ENGLISH" />

<cflock name="jasperLock" type="exclusive" timeout="10">

<!---

<cfif fileExists(arguments.jrxml)>

<cfset var daJRXML = readJRXMLFile(arguments.jrxml) />

<cfelseif isXML(arguments.jrxml)>

<cfset var daJRXML = xmlparse(arguments.jrxml) />

<cfelse>

<cfthrow type="cfjasperreport.filenotfound" detail="the file #jrxml# could not be found or was not valid XML" />

</cfif>

--->

<cfscript>

//var jasperReport = compile(arguments.jrxml);

var jasperReport = "";

//var system = CreateObject("java", "java.lang.System");

var system = variables.loader.create("java.lang.System");

var classpath = system.getProperty("java.class.path");

// var daTitle = daJRXML.jasperReport.xmlAttributes.name;

// var daXM = toString(daJRXML);

var params = reportparams;

//var parameters = CreateObject("java", "java.util.HashMap");

var parameters = variables.loader.create("java.util.HashMap");

var ka = structNew();

var daConnection = "";

var drs = "";

//var LocaleOb = createObject("java","java.util.Locale");

var LocaleOb = variables.loader.create("java.util.Locale");

//var JRParameter = createObject("java","net.sf.jasperreports.engine.JRParameter");

var JRParameter = variables.loader.create("net.sf.jasperreports.engine.JRParameter");

//var FileOb = createObject("java","java.io.File");

var FileOb = variables.loader.create("java.io.File");

// we get "Cannot load com.apple.laf.AquaLookAndFeel" if we don't set crossPlat on OSX at least

//var UIManager = createObject("java","javax.swing.UIManager");

var UIManager = variables.loader.create("javax.swing.UIManager");

UIManager.setLookAndFeel(UIManager.getCrossPlatformLookAndFeelClassName());

if(NOT isStruct(params)) {

params = structNew();

}

var ka = StructKeyArray(params);

// convert params to hashmap

for(i=1; i LTE ArrayLen(ka); i=i+1){

parameters.put(ka[i], params[ka[i]]);

}

if(arguments.locale gt "") {

parameters.put(JRParameter.REPORT_LOCALE, LocaleOb[ucase(locale)]);

}

if(arguments.resourcebundle gt "") {

//var rbStream = CreateObject("java","java.io.ByteArrayInputStream").init(readBinaryFile(arguments.resourceBundle));

var rbStream = variables.loader.create("java.io.ByteArrayInputStream").init(readBinaryFile(arguments.resourceBundle));

//var rb = createObject("java","java.util.PropertyResourceBundle").init(rbStream);

var rb = variables.loader.create("java.util.PropertyResourceBundle").init(rbStream);

parameters.put(JRParameter.REPORT_RESOURCE_BUNDLE, rb);

}

parameters.put(JRParameter.REPORT_CLASS_LOADER, variables.loader.create("net.sf.jasperreports.engine.JasperCompileManager").getClass().getClassLoader());

parameters.put(variables.loader.create( "net.sf.jasperreports.engine.JRExporterParameter").CLASS_LOADER, 

  variables.loader.create("net.sf.jasperreports.engine.JasperCompileManager").getClass().getClassLoader());

/*

dicking around to get groovy expressions to work-- might need to specifically

use JRGroovyCompiler and set path.  Groovy works if all jars are in JVM classpath.

 jasperclasspath = getJasperreportsClassPath();

 system.setProperty("jasper.reports.compile.class.path",jasperclasspath);

 system.setProperty("java.class.path",jasperclasspath);

 system.setProperty("groovy.classpath",jasperclasspath);

 //jrprops = CreateObject("java","net.sf.jasperreports.engine.util.JRProperties");

 jrprops = variables.loader.create("net.sf.jasperreports.engine.util.JRProperties");

 jrprops.setProperty(jrprops.COMPILER_CLASSPATH, jasperclasspath);

*/

if(datasource gt "" && listLast(datasource,".") == "xml") {

daConnection = jrdatasource(datasource);

} else if(datasource eq "empty") {

//daConnection = createObject("java","net.sf.jasperreports.engine.JREmptyDataSource");

daConnection = variables.loader.create("net.sf.jasperreports.engine.JREmptyDataSource");

} else if(datasource neq "") {

// 20130116 - raffaele...@gruppotesi.com

// using different connection instantiation based on product name

if( CompareNoCase(server.ColdFusion.ProductName,"railo") eq 0 )

{

var manager = getPageContext().getDataSourceManager();

var dc = manager.getConnection(getPageContext(),datasource, javacast("null",""), javacast("null",""));

daConnection = dc.getConnection();

}

else

{

objFactory = CreateObject("java","coldfusion.server.ServiceFactory");

objDataService = objFactory.getDataSourceService();

objDataSource = objDataService.GetDataSource(datasource);

daConnection = objDataSource.getConnection();

}

}

</cfscript>

<!---

<cfdump var="#daConnection#">

<cfabort>

--->

<cfscript>

if (datafile !="") {

if(listLast(datafile,".") == "xml") {

//JRloader = createObject("java","net.sf.jasperreports.engine.util.JRLoader");

//var JRXPathQueryExecuterFactory = createObject("java","net.sf.jasperreports.engine.query.JRXPathQueryExecuterFactory");

var JRXPathQueryExecuterFactory = variables.loader.create("net.sf.jasperreports.engine.query.JRXPathQueryExecuterFactory");

parameters.put(JRXPathQueryExecuterFactory.PARAMETER_XML_DATA_DOCUMENT, xmlParse(datafile));

parameters.put(JRXPathQueryExecuterFactory.XML_DATE_PATTERN, "yyyy-MM-dd");

parameters.put(JRXPathQueryExecuterFactory.XML_NUMBER_PATTERN, "##,####0.####");

parameters.put(JRXPathQueryExecuterFactory.XML_LOCALE, LocaleOb[ucase(localeLanguage)]);

} else {

throw(type="cfjasperreport.datafile.error", message="unsupported datafile type #datafile#");

}

}

//var jasperFillManager = CreateObject("java","net.sf.jasperreports.engine.JasperFillManager");

var jasperFillManager = variables.loader.create("net.sf.jasperreports.engine.JasperFillManager");

//JasperFillManager.fillReportToFile(fileName, null,

   //            new JRXmlDataSource(new BufferedInputStream(new FileInputStream("northwind.xml")), "/Northwind/Customers"));

//System.err.println("Filling time : " + (System.currentTimeMillis() - start));

//System.exit(0);

var jasperPrint = "";

if(isQuery(newquery) OR newquery NEQ ""){

if (isQuery(newquery)) {

rs = newquery;

}

else {

//stmt = CreateObject("java","java.sql.Statement");

stmt = variables.loader.create("java.sql.Statement");

// 20130116 - raffaele...@gruppotesi.com

//stmt = daConnection.createStatement();

//rs = CreateObject("java","java.sql.ResultSet");

rs = variables.loader.create("java.sql.ResultSet");

stmt = daConnection.createStatement(rs.TYPE_SCROLL_INSENSITIVE, rs.CONCUR_READ_ONLY);

rs = stmt.executeQuery(newquery);

}

//drs = CreateObject("java", "net.sf.jasperreports.engine.JRResultSetDataSource");

drs = variables.loader.create( "net.sf.jasperreports.engine.JRResultSetDataSource");

drs.init(rs);

//jasperPrint = CreateObject("java","net.sf.jasperreports.engine.JasperPrint");

jasperPrint = variables.loader.create("net.sf.jasperreports.engine.JasperPrint");

try{

 //jasperPrint = jasperFillManager.fillReport(jasperReport, parameters, drs);

 jasperPrint = jasperFillManager.fillReport(arguments.jrxml, parameters, drs);

}catch(JRException e){

throw(type="cfjasperreport.error", message=e.printStackTrace());

}

}

else if (datasource gt ""){

try{

if(isNull(daConnection)) {

throw(type="cfjasperreport.error.nullconnection", detail="connection for #datasource# is null");

}

//jasperPrint = jasperFillManager.fillReport(jasperReport, parameters, daConnection);

jasperPrint = jasperFillManager.fillReport(arguments.jrxml, parameters, daConnection);

try {

daConnection.close();

} catch(any e) {

// we do not care, only certain datasources need closing

}

if(isDefined("manager")) {

manager.releaseConnection(getPageContext(),dc);

}

}

catch(JRException e){

if(isDefined("manager")) {

manager.releaseConnection(getPageContext(),dc);

}

throw(type="cfjasperreport.error", message=e.printStackTrace());

}

} else if (structKeyExists(arguments,"query") and isQuery(arguments.query)){

try{

//drs = CreateObject("java", "net.sf.jasperreports.engine.data.JRMapArrayDataSource");

drs = variables.loader.create( "net.sf.jasperreports.engine.data.JRMapArrayDataSource");

var arrayQuery = querytoarray(query);

drs.init(arrayQuery);

//jasperPrint = jasperFillManager.fillReport(jasperReport, parameters, drs);

jasperPrint = jasperFillManager.fillReport(arguments.jrxml, parameters, drs);

}

catch(JRException e){

throw(type="cfjasperreport.error", message=e.printStackTrace());

}

} else {

try{

//jasperPrint = jasperFillManager.fillReport(jasperReport, parameters);

jasperPrint = jasperFillManager.fillReport(arguments.jrxml, parameters);

}

catch(JRException e){

throw(type="cfjasperreport.error", message=e.printStackTrace());

}

}

///virtualizer.setReadOnly(true);

//jasperPrint = jasperFillManager.fillReport(jasperReport, parameters, jRXmlDataSource);

//var jasperExportManager = CreateObject("java","net.sf.jasperreports.engine.JasperExportManager");

var jasperExportManager = variables.loader.create("net.sf.jasperreports.engine.JasperExportManager");

   //var expparam = CreateObject("java", "net.sf.jasperreports.engine.JRExporterParameter");

   //var expparam = variables.loader.create( "net.sf.jasperreports.engine.JRExporterParameter");

//var outStream = CreateObject("java","java.io.ByteArrayOutputStream").init();

var outStream = variables.loader.create("java.io.ByteArrayOutputStream").init();

var argy = '';

    //exporter.setParameter(expparam.OUTPUT_FILE_NAME,outfile);

if (exportType is "pdf") {

argy = jasperExportManager.exportReportToPdf(jasperPrint);

} else {

exporterType = ucase(left(exportType,1)) & lcase(right(exportType,len(exportType)-1));

    //jRExporterParameter = CreateObject("java", "net.sf.jasperreports.engine.JRExporterParameter");

    jRExporterParameter = variables.loader.create( "net.sf.jasperreports.engine.JRExporterParameter");

//jasperRtfExporter = CreateObject("java","net.sf.jasperreports.engine.export.JR#exporterType#Exporter");

jasperRtfExporter = variables.loader.create("net.sf.jasperreports.engine.export.JR#exporterType#Exporter");

  jasperRtfExporter.setParameter(jRExporterParameter.JASPER_PRINT, jasperPrint);

jasperRtfExporter.setParameter(JRExporterParameter.OUTPUT_STREAM, outstream);

jasperRtfExporter.exportReport();

argy = outstream;

}

outstream.close();

return argy;

</cfscript>

</cflock>

</cffunction>

<cffunction name="jrdatasource">

<cfargument name="datasource">

<cfargument name="datasourcexpath" default="" />

<cfscript>

var jRDataSource = "";

//var FileOb = createObject("java","java.io.File");

var FileOb = variables.loader.create("java.io.File");

if(listLast(datasource,".") eq "csv") {

//jRDataSource = CreateObject("java","net.sf.jasperreports.engine.data.JRCsvDataSource").init(FileOb.init(datasource),"UTF-8");

jRDataSource = variables.loader.create("net.sf.jasperreports.engine.data.JRCsvDataSource").init(FileOb.init(datasource),"UTF-8");

} else if(datasource gt "" && listLast(datasource,".") == "xml") {

//var jRXmlDataSource = CreateObject("java","net.sf.jasperreports.engine.data.JRXmlDataSource");

var jRXmlDataSource = variables.loader.create("net.sf.jasperreports.engine.data.JRXmlDataSource");

jRDataSource = jRXmlDataSource.init(FileOb.init(datasource));

if(arguments.datasourcexpath gt "") {

jRDataSource.datasource(datasourcexpath);

}

} else {

throw(type="cfjasperreport.datafile.error", message="unsupported datafile type #datafile#");

}

return jRDataSource;

</cfscript>

</cffunction>

<cffunction name="compile">

<cfargument name="jrxml" type="string" required="yes" />

<cfargument name="tofile" type="string" default="" />

<cfif fileExists(arguments.jrxml)>

<cfset var daJRXML = readJRXMLFile(arguments.jrxml) />

<cfelseif isXML(arguments.jrxml)>

<cfset var daJRXML = xmlparse(arguments.jrxml) />

<cfelse>

<cfthrow type="cfjasperreport.filenotfound" detail="the file #jrxml# could not be found or was not valid XML" />

</cfif>

<cfscript>

//var system = CreateObject("java", "java.lang.System");

var system = variables.loader.create("java.lang.System");

var classpath = system.getProperty("java.class.path");

var daTitle = daJRXML.jasperReport.xmlAttributes.name;

var daXM = toString(daJRXML);

//var xmlBuffer = CreateObject("java","java.lang.String").init(daXM).getBytes();

var xmlBuffer = variables.loader.create("java.lang.String").init(daXM).getBytes();

//var xmlInputStream = CreateObject("java","java.io.ByteArrayInputStream").init(xmlBuffer);

var xmlInputStream = variables.loader.create("java.io.ByteArrayInputStream").init(xmlBuffer);

//var jRXmlLoader = CreateObject("Java","net.sf.jasperreports.engine.xml.JRXmlLoader");

var jRXmlLoader = variables.loader.create("net.sf.jasperreports.engine.xml.JRXmlLoader");

var jasperDesign = jRXmlLoader.load(xmlInputStream);

//var jasperCompileManager = CreateObject("java","net.sf.jasperreports.engine.JasperCompileManager");

var jasperCompileManager = variables.loader.create("net.sf.jasperreports.engine.JasperCompileManager");

var jasperVerify = jasperCompileManager.verifyDesign(jasperDesign);

///virtualizer = CreateObject("java", "net.sf.jasperreports.engine.fill.JRFileVirtualizer");

///virtualizer.init(2,javacast("String","/tmp"));

///params["REPORT_VIRTUALIZER"] = virtualizer;

// move the param structure to an array to evaluate

if(arrayLen(jasperVerify) gt 0) {

errors = "";

var x = 0;

for(x = 1; x lte arrayLen(jasperVerify); x++) {

errors = listAppend(errors, jasperVerify[x].getMessage() & "(" & jasperVerify[x].getSource().getText() & ")");

}

throw(type="jasperreports.report.design.flaw",detail=errors);

}

if(findNoCase("language=""groovy""",daXM)) {

//var jThread = createObject("java","java.lang.Thread");

var jThread = variables.loader.create("java.lang.Thread");

var cTL = jThread.currentThread().getContextClassLoader();

jThread.currentThread().setContextClassLoader(jasperCompileManager.getClass().getClassLoader());

}

try {

if(tofile neq "") {

var jasperReport = jasperCompileManager.compileReportToFile(tofile);

} else {

var jasperReport = jasperCompileManager.compileReport(jasperDesign);

}

} catch (any e) {

if(findNoCase("language=""groovy""",daXM)) {

jThread.currentThread().setContextClassLoader(cTL);

}

throw(type="jasperreports.report.compile.error",detail=e.message & " -- " & e.detail);

}

if(findNoCase("language=""groovy""",daXM)) {

jThread.currentThread().setContextClassLoader(cTL);

}

xmlInputStream.close();

return jasperReport;

</cfscript>

</cffunction>

<cffunction name="onEndTag" output="yes" returntype="boolean">

<cfargument name="attributes" type="struct" />

<cfargument name="caller" type="struct" />

<cfargument name="generatedContent" type="string" />

<cfreturn false />

</cffunction>

<cffunction name="readJRXMLFile" output="false" returntype="any" access="private">

<cfargument name="jrxmlfile" type="string" required="yes" />

<cfset var daJR = "" />

<cffile action="read" variable="daJR" file="#arguments.jrxmlfile#" charset="utf-8">

<cfreturn xmlparse(daJR) />

</cffunction>

<cffunction name="readBinaryFile" output="false" returntype="any" access="private">

<cfargument name="filepath" type="string" required="yes" />

<cfset var daFile = "" />

<cffile action="readbinary" variable="daFile" file="#arguments.filepath#">

<cfreturn daFile />

</cffunction>

<cffunction name="getJasperreportsClassPath" output="false" returntype="any" access="private">

<cfscript>

//var jarsArry = CreateObject("java","net.sf.jasperreports.engine.JasperFillManager").getClass().getClassLoader().getURLs();

var jarsArry = variables.loader.create("net.sf.jasperreports.engine.JasperFillManager").getClass().getClassLoader().getURLs();

//var system = CreateObject("java", "java.lang.System");

var system = variables.loader.create("java.lang.System");

var classpath = system.getProperty("java.class.path");

var delim = system.getProperty("path.separator");

for(x = 1; x lte arrayLen(jarsArry); x++) {

jarpath = replace(jarsArry[x].toString(),"file:","");

classpath = listAppend(classpath,jarpath,delim);

}

</cfscript>

<cfreturn classpath />

</cffunction>

<cffunction name="reportToFile" output="false" returntype="void" access="private">

<cfargument name="fileContent" required="true" />

<cfargument name="reportfile" type="string" required="yes" />

<cfset var daJR = "" />

<cffile action="write" output="#arguments.fileContent#" file="#arguments.reportfile#">

</cffunction>

<cffunction name="download" output="true" returntype="void" access="private">

<cfargument name="fileName" required="true" />

<cfargument name="fileContent" required="true" />

<cfargument name="forceDownload" default="false" />

<cfset var cvalue = "" />

<cfset var out = "" />

<cfset var content = "" />

<cfset var context = "" />

<cfset var response = "" />

<cfsetting showdebugoutput="no">

<cfsetting enablecfoutputonly="yes">

<cfif arguments.forceDownload>

<cfset cvalue = 'attachment;' />

</cfif>

<cfset cvalue = cvalue & "filename=#arguments.fileName#" />

<cfheader name="Content-Disposition" value="#cvalue#" charset="utf-8">

<!---

<cfdump var="#filecontent#" abort>

--->

<!---

Doesn't work for some reason, maybe application.cfc?

<cfheader name="Content-Disposition" value="#cvalue#" charset="utf-8">

<cfcontent type="application/#exportType#" reset="true"><cfoutput>#arguments.fileContent#</cfoutput>

--->

<cfscript>

content = toBinary(arguments.fileContent);

context = getPageContext();

response = context.getResponse();

out = response.getOutputStream();

response.setContentType("application/#listLast(filename,'.')#");

response.setContentLength(arrayLen(content));

out.write(content);

out.flush();

out.close();

</cfscript>

</cffunction>

<cffunction name="querytoarray" returntype="array" output="No">

<cfargument name="q" required="Yes" type="query">

<cfset var aTmp = arraynew(1)>

<cfset var qmeta = getMetaData(q)>

<cfset var types = {} />

<cfloop array="#qmeta#" index="met">

<cfset types[met.name] = met.typeName />

</cfloop>

<cfif q.recordcount>

<cfloop query="q">

<cfset stTmp = structNew()>

<cfloop list="#lcase(q.columnlist)#" index="col">

<cfif types[col] eq "INTEGER">

<cfset stTmp["#col#"] = javaCast("int",q[col][currentRow]) />

<cfelse>

<cfset stTmp["#col#"] = q[col][currentRow] />

</cfif>

</cfloop>

<cfset arrayAppend(aTmp,stTmp)>

</cfloop>

<cfelse>

<cfset stTmp = structNew()>

<cfloop list="#lcase(q.columnlist)#" index="col">

<cfset stTmp["#col#"] = "">

</cfloop>

<cfset arrayAppend(aTmp,stTmp)>

</cfif>

<cfreturn aTmp>

</cffunction>

</cfcomponent>

--
You received this message because you are subscribed to the Google Groups "javaloader-dev" group.
To view this discussion on the web visit https://groups.google.com/d/msg/javaloader-dev/-/FaPfyAjXeWYJ.
To post to this group, send email to javaloa...@googlegroups.com.
To unsubscribe from this group, send email to javaloader-de...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/javaloader-dev?hl=en.

--
E: mark....@gmail.com
T: http://www.twitter.com/neurotic
W: www.compoundtheory.com

2 Devs from Down Under Podcast

http://www.2ddu.com/

[Raffaele Castagno]

That did the trick!

I have to refactor it a bit but now it basically works.

Thanks a lot!

Raffaele

[Terry Bankert]

Just curious if you ever got this working and would be willing to share your source code