Query Builder Emits Warning on Trim

Questions, tips and tricks and techniques for scripting in Servoy

Query Builder Emits Warning on Trim

Postby kwpsd » Fri Dec 29, 2017 9:37 pm

Servoy 8.2.1
JRE 1.8.0_121

The following query builder code emits a warning in the Debug Console when getDataSetByQuery() is executed:

Code: Select all
    var query = datasources.db.arm_data.supplies_inventory.createSelect()
             
    query.result.add( query.columns.inventory_item_description.trim )
   
    var ds = databaseManager.getDataSetByQuery( query, -1 )  // WARNING APPEARS WHEN THIS LINE OF CODE IS EXECUTED


Here is the warning message (the message is shown twice for each instance of getDataSetByQuery()):

WARN org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered
WARN org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered


If trim is removed from the code, no warning is emitted. I don't know what to make of the '4 arguments encountered' part of the message. Is this a bug?
Kim W. Premuda
San Diego, CA USA
User avatar
kwpsd
 
Posts: 687
Joined: Sat Jul 28, 2007 6:59 pm
Location: San Diego, CA USA

Re: Query Builder Emits Warning on Trim

Postby kwpsd » Mon Jan 08, 2018 9:10 pm

Servoy...what is the correct usage of trim vs. trim() function in order to suppress the '4 arguments' warning message? I presume the '4 arguments' pertains to the trim() function but not the trim chain element...correct? So, why does the chain element trim emit a warning message regarding arguments when there are no arguments involved? My assumption is that the chain element trim removes all leading and trailing white space whereas the trim() function allows for removing leading only, trailing only, or both leading and trailing white space.

tooltip_trim.png
tooltip_trim.png (13.35 KiB) Viewed 10343 times


double_trim.png
double_trim.png (44.34 KiB) Viewed 10343 times
Kim W. Premuda
San Diego, CA USA
User avatar
kwpsd
 
Posts: 687
Joined: Sat Jul 28, 2007 6:59 pm
Location: San Diego, CA USA

Re: Query Builder Emits Warning on Trim

Postby kwpsd » Tue Mar 20, 2018 10:28 pm

Customer log file is still showing hundreds of these Function template anticipated warnings, and I do not know what is causing the warnings to be emitted. Does anyone know what is happening (see code above)?

2018-03-15 09:17:30,621 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:17:30,623 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:19:23,314 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:19:23,315 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:20:19,358 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:20:19,359 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:21:38,799 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:21:38,808 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:22:21,453 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:22:21,453 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:22:43,388 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:22:43,388 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:22:54,821 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:22:54,821 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:23:12,396 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:23:12,397 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:23:31,516 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:23:31,517 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:25:55,054 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:25:55,055 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:26:11,323 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:26:11,324 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:27:23,629 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:27:23,630 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:27:48,572 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:27:48,572 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:28:46,691 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:28:46,692 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:30:17,406 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:30:17,407 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:30:22,413 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:30:22,413 WARN [RMI TCP Connection(4184)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:39:07,179 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:39:07,181 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:40:05,036 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:40:05,049 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:40:47,442 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:40:47,442 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:42:21,564 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:42:21,565 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:43:21,788 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:43:21,789 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:44:23,432 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:44:23,433 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:48:38,364 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:48:38,384 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:49:25,585 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:49:25,586 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:52:46,673 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:52:46,674 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:54:46,249 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 09:54:46,250 WARN [RMI TCP Connection(4190)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 10:04:58,852 WARN [RMI TCP Connection(4196)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 10:04:58,853 WARN [RMI TCP Connection(4196)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 10:06:57,268 WARN [RMI TCP Connection(4196)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 10:06:57,269 WARN [RMI TCP Connection(4196)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 10:14:06,606 WARN [RMI TCP Connection(4199)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 10:14:06,607 WARN [RMI TCP Connection(4199)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 10:14:14,579 WARN [RMI TCP Connection(4199)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 10:14:14,580 WARN [RMI TCP Connection(4199)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:05:13,721 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:05:13,722 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:06:26,786 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:06:26,787 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:07:58,529 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:07:58,530 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:09:52,851 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:09:52,852 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:10:28,286 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:10:28,287 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:10:31,813 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:10:31,823 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:11:34,188 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:11:34,189 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:12:45,780 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:12:45,781 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:14:26,893 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:14:26,894 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:16:00,279 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:16:00,280 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:18:17,501 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:18:17,502 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:18:25,660 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:18:25,661 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:20:11,042 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:20:11,043 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:21:38,978 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:21:38,978 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:22:27,184 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 11:22:27,184 WARN [RMI TCP Connection(4217)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 12:38:37,199 WARN [RMI TCP Connection(4253)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 12:38:37,200 WARN [RMI TCP Connection(4253)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:19:00,617 WARN [RMI TCP Connection(4269)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:19:00,618 WARN [RMI TCP Connection(4269)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:19:50,861 WARN [RMI TCP Connection(4269)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:19:50,862 WARN [RMI TCP Connection(4269)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:22:44,285 WARN [RMI TCP Connection(4269)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:22:44,286 WARN [RMI TCP Connection(4269)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:25:08,254 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:25:08,264 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:26:40,412 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:26:40,412 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:26:44,429 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:26:44,430 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:26:57,539 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:26:57,539 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:30:00,068 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:30:00,069 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:30:27,477 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:30:27,477 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:30:33,050 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:30:33,050 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:30:55,155 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:30:55,155 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:31:40,627 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:31:40,628 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:31:44,346 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:31:44,346 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:31:53,439 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:31:53,439 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:33:41,854 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:33:41,855 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:34:15,958 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:34:15,958 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:36:04,178 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:36:04,178 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:36:18,611 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:36:18,611 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:36:32,499 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:36:32,500 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:39:26,850 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:39:26,857 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:39:53,332 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:39:53,339 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:41:42,871 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:41:42,874 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:43:05,039 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:43:05,040 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:43:57,908 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 13:43:57,909 WARN [RMI TCP Connection(4271)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:19:11,726 WARN [RMI TCP Connection(4289)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:19:11,727 WARN [RMI TCP Connection(4289)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:19:38,296 WARN [RMI TCP Connection(4289)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:19:38,297 WARN [RMI TCP Connection(4289)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:19:53,394 WARN [RMI TCP Connection(4289)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:19:53,395 WARN [RMI TCP Connection(4289)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:21:15,216 WARN [RMI TCP Connection(4289)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:21:15,217 WARN [RMI TCP Connection(4289)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:32:58,672 WARN [RMI TCP Connection(4299)-10.100.56.254] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:32:58,673 WARN [RMI TCP Connection(4299)-10.100.56.254] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:34:12,244 WARN [RMI TCP Connection(4299)-10.100.56.254] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:34:12,259 WARN [RMI TCP Connection(4299)-10.100.56.254] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:34:37,583 WARN [RMI TCP Connection(4302)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:34:37,584 WARN [RMI TCP Connection(4302)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:34:55,804 WARN [RMI TCP Connection(4302)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:34:55,805 WARN [RMI TCP Connection(4302)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:36:44,415 WARN [RMI TCP Connection(4302)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:36:44,416 WARN [RMI TCP Connection(4302)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:37:06,089 WARN [RMI TCP Connection(4302)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
2018-03-15 14:37:06,089 WARN [RMI TCP Connection(4302)-10.100.58.255] org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered [ ]
Kim W. Premuda
San Diego, CA USA
User avatar
kwpsd
 
Posts: 687
Joined: Sat Jul 28, 2007 6:59 pm
Location: San Diego, CA USA

Re: Query Builder Emits Warning on Trim

Postby rgansevles » Fri Mar 23, 2018 11:47 am

Kim,

This has been fixed in Servoy 8.2, see https://support.servoy.com/browse/SVY-10807

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Query Builder Emits Warning on Trim

Postby kwpsd » Fri Mar 23, 2018 6:32 pm

Thank you for fixing this, Rob! Much appreciated.
Kim W. Premuda
San Diego, CA USA
User avatar
kwpsd
 
Posts: 687
Joined: Sat Jul 28, 2007 6:59 pm
Location: San Diego, CA USA

Re: Query Builder Emits Warning on Trim

Postby kwpsd » Sat Mar 02, 2019 3:29 am

Hi, Rob.

Servoy version 8.2.3

We are getting similar error messages when .upper is used in Query Builder.

Code: Select all
e.g. query.where.add( query.columns.column_name.upper.eq( variable_name.toUpperCase() ) )


WARN org.hibernate.dialect.function.TemplateRenderer - Function template anticipated 1 arguments, but 4 arguments encountered


Would it be possible to suppress these warnings as well? There are hundreds of them in our customer's log.

Thank you.
Kim W. Premuda
San Diego, CA USA
User avatar
kwpsd
 
Posts: 687
Joined: Sat Jul 28, 2007 6:59 pm
Location: San Diego, CA USA

Re: Query Builder Emits Warning on Trim

Postby rgansevles » Wed Mar 06, 2019 9:14 pm

Kim,

That is strange, the upper-function has only 1 argument, what database do you see this on?

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Query Builder Emits Warning on Trim

Postby kwpsd » Thu Mar 07, 2019 2:14 am

Hi, Rob.

We use Microsoft SQL Server 2016 version 13.0.1742 for development work. I don't know if it matters, but it's the free SQLEXPRESS version.
Kim W. Premuda
San Diego, CA USA
User avatar
kwpsd
 
Posts: 687
Joined: Sat Jul 28, 2007 6:59 pm
Location: San Diego, CA USA


Return to Methods

Who is online

Users browsing this forum: No registered users and 11 guests