Query Builder Emits Warning on Trim

kwpsd · December 29, 2017, 7:37pm

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:

    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?

kwpsd · January 8, 2018, 7:10pm

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.

[attachment=1]tooltip_trim.png[/attachment]

[attachment=0]double_trim.png[/attachment]

kwpsd · March 20, 2018, 8:28pm

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

rgansevles · March 23, 2018, 9:47am

Kim,

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

Rob

kwpsd · March 23, 2018, 4:32pm

Thank you for fixing this, Rob! Much appreciated.

kwpsd · March 2, 2019, 1:29am

Hi, Rob.

Servoy version 8.2.3

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

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.

rgansevles · March 6, 2019, 7:14pm

Kim,

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

Rob

kwpsd · March 7, 2019, 12:14am

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.

Topic		Replies	Views
TiNG Cannot Login to Solution Questions	12	10281	August 23, 2024
Parameter Declaration Classic Servoy	22	7371	August 11, 2011
utils.stringTrim() Classic Servoy	2	2707	June 16, 2014
DOS Window Heaven... Classic Servoy	7	5652	January 4, 2006
Error With aggregate Classic Servoy	20	29454	December 21, 2009

Query Builder Emits Warning on Trim

Related topics