Administrator.cfc and cannot update the field connection timeout for a datasource with updateDatasource method

TonyMonast · January 4, 2022, 8:40pm

Hi,

I’m trying to create a datasource with cfml code by using the administrator.cfc component.

createObject('component','Administrator')

I am using the updateDatasource method. I am able to create the datasource and set most of the settings, but I’m not able to set the correct value for the field Connection timeout. The HTML input name is LiveTimeout and I’m passing the value for LiveTimeout in the updateDatasource method.

I searched the source code of Lucee and found the method. There is nothing about LiveTimeout, so I suppose it’s normal that I can’t update this setting with the component?

github.com

lucee/Lucee/blob/3a563f215bc6060f0410a36099f5310300f0cf75/core/src/main/java/resource/component/org/lucee/cfml/Administrator.cfc#L341


      
          	* @customCharacterEncoding Should only be used when the driver can't determine the character set mapping, or you are trying to 'force' the driver to use a character set that MySQL either doesn't natively support (such as UTF-8)If it is set to true, what character encoding should the driver use when dealing with strings?
          	* @customUseOldAliasMetadataBehavior Should the driver use the legacy behavior for "AS" clauses on columns and tables, and only return aliases (if any) rather than the original column/table name? In 5.0.x, the default value was true.
          	* @customAllowMultiQueries Allow the use of ";" to delimit multiple queries during one statement
          	* @customZeroDateTimeBehavior What should happen when the driver encounters DATETIME values that are composed entirely of zeroes (used by MySQL to represent invalid dates)? Valid values are "exception", "round" and "convertToNull"
          	* @customAutoReconnect Should the driver try to re-establish stale and/or dead connections?
          	* @customJdbcCompliantTruncation If set to false then values for table fields are automatically truncated so that they fit into the field.
          	* @customTinyInt1isBit if set to "true" (default) tinyInt(1) is converted to a bit value otherwise as integer.
          	* @customUseLegacyDatetimeCode Use code for DATE/TIME/DATETIME/TIMESTAMP handling in result sets and statements
          	* @verify whether connection needs to be verified
          	*/
          	public void function updateDatasource(
          		required string name,
          		required string type,
          		required string newName,
          		required string host,
          		required string database,
          		required numeric port,
          		required string username,
          		required string password,
          
          
		string timezone="",

Should I report it as a bug or a feature request?

Thank you

Additional bug for another setting
When I use updateDatasource to create a new datasource, I pass -1 for connectionLimit, but when I go in the server admin, the value is at 100. I need to call updateDatasource again to set the connectionLimit to -1. It’s like that the datasource must exists first to set the value. Same situation if you create a new datasource via the web interface. If you set -1 (Inf) for connectionLimit when you create the datasource the first time, the value will be 100 when you will edit the datasource. You need to change it once the datasource exists.

Lucee Version: Lucee 5.3.8.206

cfmitrah · January 5, 2022, 8:35am

@TonyMonast For the additional bug about connectionLimit was already has a ticket [LDEV-1445] - Lucee and fixed in lucee 6.0.

TonyMonast · January 5, 2022, 1:37pm

Good to hear and thank you for the info!

For LiveTimeout, I suppose you can’t set it on Lucee 6.0 as well, because when I look at the source code, there is no argument for that in the method updateDatasource : Lucee/Administrator.cfc at 382c0235cb6b604abc0a865405b8545f3af6482d · lucee/Lucee · GitHub

cfmitrah · January 5, 2022, 3:06pm

@TonyMonast yes, there are no options to set liveTimeout (which is Connection timeout in admin datasource UI) using AdminAPI. There is an argument named ConnectionTimeout was available but that for Connection timeout which have marked as Connection idle timeout in the admin datasource create page. So can please file a bug for the issue in Jira? https://luceeserver.atlassian.net/

TonyMonast · January 5, 2022, 3:27pm

Ticket created : Lucee Development - Issues - Lucee

cfmitrah · May 8, 2023, 7:39am

This issue has been fixed on lucee version 6.0.0.383-SNAPSHOT