Appending connection string to datasource

dswitzer · April 12, 2021, 7:07pm

I’m trying to create a datasource programmatically and append to the connection string. I need to add the following MSSQL connection string: “DateTimeInputParameterType=dateTime” to make preserve sending datetime params as “datetime” and not “datetime2” values.

Looking at the documentation, it would appear I should be able to pass the following to the updateDatasource() method of the Administrator.cfc:

“custom”: “DateTimeInputParameterType=dateTime”

However, the actual component (Lucee/Administrator.cfc at 7d73d7357de7a0b0e91d7b7df27b37aa6171d67c · lucee/Lucee · GitHub) does not seem to support this.

Or should it be:

customDateTimeInputParameterType=“dateTime”

Zackster · April 12, 2021, 9:05pm

custom needs to be a struct, but the var custom=structNew(); should go, rather updateDatasource should accept custom as an argument

custom = { DateTimeInputParameterType":"dateTime" }

customDateTimeInputParameterType="dateTime"

should work tho

github.com

lucee/Lucee/blob/6.0/core/src/main/java/resource/component/org/lucee/cfml/Administrator.cfc#L390


		boolean customUseLegacyDatetimeCode=false
	){
		var driverNames=structnew("linked");
		driverNames=ComponentListPackageAsStruct("lucee-server.admin.dbdriver",driverNames);
		driverNames=ComponentListPackageAsStruct("lucee.admin.dbdriver",driverNames);
		driverNames=ComponentListPackageAsStruct("dbdriver",driverNames);
		var driver=createObject("component", drivernames[ arguments.type ]);
		var custom=structNew();
		loop collection="#arguments#" item="key"{
			if(findNoCase("custom",key) EQ 1){
				l=len(key);
				custom[mid(key,8,l-8+1)]=arguments[key];
			}
		}
		if( arguments.type == "MSSQL" ){
			custom["databaseName"] = arguments.database;
		}

dswitzer · April 12, 2021, 9:19pm

Thanks!. That’s what I was really thinking was probably correct.

What’s the customUseLegacyDatetimeCode do in Lucee 6?

I have a feeling that might be doing what I’m wanting, but I’m not sure based on the comment hint, which just says:

@customUseLegacyDatetimeCode Use code for DATE/TIME/DATETIME/TIMESTAMP handling in result sets and statements

Zackster · April 12, 2021, 10:11pm

it’s a mysql jdbc feature/quirk

Zackster · April 22, 2021, 9:11am

I’ve filed an enhancement

https://luceeserver.atlassian.net/browse/LDEV-3469

cfmitrah · April 22, 2021, 1:45pm

FYI, I added a PR on that ticket