lucee 5 and taffy 3.1.0

[Cage Sarin]

I just installed Lucee 5 and taffy 3.1.0. I get the following error. Any thoughts on what could be going on?

{  
   "ERROR":"No matching Method/Function for Query.getColumnList(boolean) found",
   "DETAIL":"",
   "TAGCONTEXT":"/opt/lucee/tomcat/webapps/ROOT/orrms/server/apiv1/taffy/core/resource.cfc [Line 55]",
   "STACKTRACE":[  
      {  
         "Raw_Trace":"core.resource_cfc$cf.udfCall1(/taffy/core/resource.cfc:55)",
         "codePrintPlain":"53: \t\t\tvar local = {};\n54: \t\t\tif (structKeyExists(server, \"railo\") or structKeyExists(server, \"lucee\")) {\n55: \t\t\t\tlocal.Columns = listToArray(arguments.q.getColumnList(false));\n56: \t\t\t}\n57: \t\t\telse {\n",
         "column":0,
         "line":55,
         "template":"/opt/lucee/tomcat/webapps/ROOT/orrms/server/apiv1/taffy/core/resource.cfc",
         "id":"??",
         "type":"cfml",
         "codePrintHTML":"53: \t\t\tvar local = {};<br>\n54: \t\t\tif (structKeyExists(server, &quot;railo&quot;) or structKeyExists(server, &quot;lucee&quot;)) {<br>\n<b>55: \t\t\t\tlocal.Columns = listToArray(arguments.q.getColumnList(false));</b><br>\n56: \t\t\t}<br>\n57: \t\t\telse {<br>\n"
      },
      {  
         "Raw_Trace":"messagescollection_cfc$cf.udfCall(/resources/messagesCollection.cfc:60)",
         "codePrintPlain":"58:                                     messagessent={value=arrayToList(messagesSent), cfsqltype=\"CF_SQL_INTEGER\", list=true}};\n59:                 var messages = queryExecute(sql, params, {datasource=\"db_orrms_dev\"});\n60:                 messages = queryToArray(messages);\n61: \n62:                 if (not isNull(messages) and not arrayIsEmpty(messages)){\n",
         "column":0,
         "line":60,
         "template":"/opt/lucee/tomcat/webapps/ROOT/orrms/server/apiv1/resources/messagesCollection.cfc",
         "id":"??",
         "type":"cfml",
         "codePrintHTML":"58:                                     messagessent={value=arrayToList(messagesSent), cfsqltype=&quot;CF_SQL_INTEGER&quot;, list=true}};<br>\n59:                 var messages = queryExecute(sql, params, {datasource=&quot;db_orrms_dev&quot;});<br>\n<b>60:                 messages = queryToArray(messages);</b><br>\n61: <br>\n62:                 if (not isNull(messages) and not arrayIsEmpty(messages)){<br>\n"
      },
      {  
         "Raw_Trace":"taffy.core.api_cfc$cf.udfCall1(/orrmsapiv1/taffy/core/api.cfc:338)",
         "codePrintPlain":"336: \t\t\t\t\t\tmethod=\"#_taffyRequest.method#\"\n337: \t\t\t\t\t\targumentcollection=\"#_taffyRequest.requestArguments#\"\n338: \t\t\t\t\t\treturnvariable=\"_taffyRequest.result\"\n339: \t\t\t\t\t/>\n340: \t\t\t\t\t<cfset m.afterResource = getTickCount() />\n",
         "column":0,
         "line":338,
         "template":"/opt/lucee/tomcat/webapps/ROOT/orrms/server/apiv1/taffy/core/api.cfc",
         "id":"??",
         "type":"cfml",
         "codePrintHTML":"336: \t\t\t\t\t\tmethod=&quot;#_taffyRequest.method#&quot;<br>\n337: \t\t\t\t\t\targumentcollection=&quot;#_taffyRequest.requestArguments#&quot;<br>\n<b>338: \t\t\t\t\t\treturnvariable=&quot;_taffyRequest.result&quot;</b><br>\n339: \t\t\t\t\t/&gt;<br>\n340: \t\t\t\t\t&lt;cfset m.afterResource = getTickCount() /&gt;<br>\n"
      }
   ]
}

[Adam Tuttle]

We put in a workaround for Railo and Lucee a long time ago to get the column list and it sounds like maybe that doesn't work with Lucee5?

https://github.com/atuttle/Taffy/blob/master/core/resource.cfc#L54

Try commenting out all of the if/else logic there, leaving only the logic inside the else (line 58) to run, and see if that works for you.

Adam

--
You received this message because you are subscribed to the Google Groups "Taffy Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to taffy-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Cage Sarin]

Thanks for the info. I think this issue is only happening with one of the Lucee 5 daily snapshots and I just downgraded.

I'm still having significant performance issues. Taffy Requests are taking 15 seconds or more, and eventually they time out. I am using Hibernate / ORM and wondering if that's causing the problem. Just wondering if anyone else has encountered similar issues and/or how to solve it?

Thanks,

Cage

Adam

To unsubscribe from this group and stop receiving emails from it, send an email to taffy-users...@googlegroups.com.

[Adam Tuttle]

I have never had success using ORM on Lucee. I eventually gave up and spent a week converting my app back to queries.

Adam

To unsubscribe from this group and stop receiving emails from it, send an email to taffy-users+unsubscribe@googlegroups.com.

[Cage Sarin]

!!! 

Oh, okay. I had issues with 4.5 also but solved them by increasing memory to JVN and GC method. Sadly, this hasn't worked for Lucee 5. Guess I need to go back to 4.5 :(

Cage

[Nando Breiter]

I saw something about the latest version of Hibernate having issues ... and that downgrading Hibernate alone solved the problem someone was having somewhere ... sorry I don't recall the somewhere. 

Aria Media Sagl

+41 (0)76 303 4477 cell
skype: ariamedia

To unsubscribe from this group and stop receiving emails from it, send an email to taffy-users+unsubscribe@googlegroups.com.

[Nando Breiter]

Adam,

Did you retain the objects in your code, using your own queries to populate them? Or ?

Years after the fact, I wish I hadn't started down the ORM path with what has grown to be a very large app. It's clearly the weakest link in the chain.

Aria Media Sagl

+41 (0)76 303 4477 cell
skype: ariamedia

[Adam Tuttle]

I eliminated all traces of ORM from that particular app.

Adam

[Cage Sarin]

If anyone else has a similar issue...

I found out the source of performance issues: using "cachedWithin='#timespan(0,0,60,0)#'" on the taffy GET functions slowed down the response (anywhere from 3-15 seconds delay!).

[Adam Tuttle]

Would you mind isolating that from Taffy to see if it's just a lucee querying bug?

Adam

To unsubscribe from this group and stop receiving emails from it, send an email to taffy-users+unsubscribe@googlegroups.com.

[Cage Sarin]

Well, that's interesting...

So if I call the web service directly (from browser), there's no significant difference using via Taffy vs. without Taffy on same function with / without cachedWithin.

However, if my app does it via an XHR call, there's still that 5-6 second delay in using cachedWithin via Taffy call. I haven't had a chance to modify the app to use the non-Taffy version of the call...

One difference is that my app is making 5 simultaneous XHR calls (with different input parameters). Each call has the 5-6 second delay if I use cachedWithin but no delay if I don't. Do you think it could be Lucee's cache management that is locking execution for some reason?

Cage

[Cage Sarin]

Response headers (with cachedWithin on function):

1. ALLOW:
   GET
2. Cache-control:
   no-cache,no-store
3. Content-Encoding:
   gzip
4. Content-Type:
   application/json;charset=utf-8
5. Date:
   Wed, 11 Jan 2017 23:13:21 GMT
6. Expires:
   -1
7. Pragma:
   no-cache
8. Server:
   Apache-Coyote/1.1
9. Transfer-Encoding:
   chunked
10. X-TIME-IN-CACHE-CHECK:
    0
11. X-TIME-IN-CACHE-SAVE:
    0
12. X-TIME-IN-ONTAFFYREQUEST:
    0
13. X-TIME-IN-ONTAFFYREQUESTEND:
    0
14. X-TIME-IN-PARSE:
    0
15. X-TIME-IN-RESOURCE:
    8200
16. X-TIME-IN-SERIALIZE:
    5
17. X-TIME-IN-TAFFY:
    0

 Response headers WITHOUT cachedWithin:

1. ALLOW:
   GET
2. Cache-control:
   no-cache,no-store
3. Content-Encoding:
   gzip
4. Content-Type:
   application/json;charset=utf-8
5. Date:
   Wed, 11 Jan 2017 23:15:30 GMT
6. Expires:
   -1
7. Pragma:
   no-cache
8. Server:
   Apache-Coyote/1.1
9. Transfer-Encoding:
   chunked
10. X-TIME-IN-CACHE-CHECK:
    0
11. X-TIME-IN-CACHE-SAVE:
    0
12. X-TIME-IN-ONTAFFYREQUEST:
    0
13. X-TIME-IN-ONTAFFYREQUESTEND:
    0
14. X-TIME-IN-PARSE:
    1
15. X-TIME-IN-RESOURCE:
    1408
16. X-TIME-IN-SERIALIZE:
    2
17. X-TIME-IN-TAFFY:
    0

[Adam Tuttle]

Post the SQL?

--

You received this message because you are subscribed to the Google Groups "Taffy Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to taffy-users+unsubscribe@googlegroups.com.

[Cage Sarin]

Here's the code:

var validFor = (validfor!=""?validfor:"");
var sql = "select distinct t1.orpodid, t1.orpodposition, t1.orpodname
        from podsettings t1
        left join roomsettings t2
        on t1.orpodid=t2.orpodid
        where (t1.activeae = :activeae or t2.activene = :activene)
        and t1.location=:location
        and t2.validfor=:validfor
        order by t1.orpodposition ASC, t1.orpodname ASC";
var queryResults = queryExecute(sql, {activeae={value = true, cfsqltype="CF_SQL_BOOLEAN"},
                                       activene={value = true, cfsqltype="CF_SQL_BOOLEAN"},
                                       validfor={value = validfor, cfsqltype="CF_SQL_VARCHAR"},
                                       location={value = location, cfsqltype="CF_SQL_VARCHAR"}}, {datasource="db_name_blah"});

queryResults = queryToArray(queryResults);

for (var a=1; a<=arrayLen(queryResults); a++){
    var orpodid = queryResults[a].orpodid;

(additional sql statement based on above results)

    roomsettings = queryToArray(roomsettings);

    queryResults[a]["roomsettings"] = roomsettings;
}

return representationOf(queryResults).withStatus(200);

Post the SQL?

To unsubscribe from this group and stop receiving emails from it, send an email to taffy-users...@googlegroups.com.

[Adam Tuttle]

I don't see any obvious problems. I still suspect a Lucee bug.

Adam

To unsubscribe from this group and stop receiving emails from it, send an email to taffy-users+unsubscribe@googlegroups.com.