Fixed
Details
Assignee
Pothys - MitrahSoftPothys - MitrahSoftReporter
Just LopingJust LopingPriority
MajorLabels
Fix versions
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Sprint
None
Details
Details
Assignee
Pothys - MitrahSoft
Pothys - MitrahSoftReporter
Just Loping
Just LopingPriority
Labels
Fix versions
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Sprint
None
Created 4 August 2017 at 19:54
Updated 21 September 2022 at 10:59
Resolved 30 November 2021 at 07:30
we have the following code to create a mysql dsn
Before we don't need to set connectionLimit to -1 (since it is default)
In Lucee 5.2.x, now the default is set to empty string, and it shows 100 in admin UI
if you put connectionLimit = -1 in adminAPI, the dsn created still has no connectionLimit...
(tried both 5.2.1.9 and 5.2.2.71)
in Lucee 4.5.5, it still works...
======
<cfscript>
dsnname = 'testMySQLDSN';
dbhost = 'localhost';
dbname = 'foo';
dbuser = 'AAA';
dbpwd = '!NOTAPASSWORD';
adminpwd = 'NOTAPASSWORD!';
args = {};
//args['connectionLimit'] = -1;
args['Action'] = 'updateDatasource';
args['newName'] = dsnname;
args['name'] = dsnname;
args['host'] = dbhost;
args['database'] = dbname;
args['dbusername'] = dbuser;
args['dbpassword'] = dbpwd;
args['port'] = 3306;
args['clob'] = true;
args['blob'] = false;
args['connectionTimeout'] = 1;
args['validate'] = true;
args['dsn'] = "jdbc:mysql://{host}:{port}/{database}";
args['classname'] = "org.gjt.mm.mysql.Driver";
args['custom'] = {};
args['custom']['useOldAliasMetadataBehavior'] = true;
args['custom']['zeroDateTimeBehavior'] = 'convertToNull';
args['custom']['characterEncoding'] = 'UTF-8';
args['custom']['useUnicode'] = true;
args['custom']['useLegacyDatetimeCode'] = true;
args.type = 'server';
args.password = adminpwd;
</cfscript>
<cfadmin attributeCollection="#args#">