rodyon
02/03/2023, 12:15 PMsalted
02/08/2023, 5:06 PMsalted
02/08/2023, 5:06 PMzackster
02/08/2023, 10:58 PMTravis
02/09/2023, 10:27 PMAdam Cameron
Attribute [datasource] is required when attribute [dbtype] is not [query] and no default datasource is defined
However my this.datasource
is set in Application.cfc. And my CF2021 instance using the same codebase is running the code fine.
The error goes on to say:
you can define a default datasource as attribute [defaultdatasource] of the tag cfapplication or as data member of the Application.cfc (this.defaultdatasource="mydatasource";)
But it shouldn't be defaultdatasource
. That's not a thing. It should just be datasource
. And indeed this is what we use all day, every day in our production code. Granted this is on a different Lucee instance that @ work, but it's always been this.datasource
, has it not?
Lucee 5.3.9.166
.zackster
02/14/2023, 12:36 AMPeter Bennett
02/14/2023, 10:09 AMwebsolete
02/14/2023, 2:48 PMdswitzer
02/14/2023, 6:26 PM<cfquery name="text">
select <cfqueryparam cfsqltype="CF_SQL_CHAR" value="2" />
</cfquery>
And then I monitored the actual SQL that SQL Server executes, I'm seeing the cached plan end up as:
exec sp_executesql N'select @P0',N'@P0 nvarchar(4000)',N'2'
Notice that instead of 2
being cast as char(1)
it's cast as an nvarchar(4000)
. Any of the string values are behaving the same way.
Shouldn't the executed SQL look like this instead:
exec sp_executesql N'select @P0',N'@P0 char(1)','2'
David Rogers
02/15/2023, 6:19 PMAdam Cameron
Adam Cameron
Adam Cameron
nyahgfx
02/20/2023, 8:35 AMSebastiaan Naafs - van Dijk
02/20/2023, 4:05 PMMatt Dyer
02/21/2023, 4:02 PMzackster
02/22/2023, 12:31 AMchapmandu
02/22/2023, 5:29 AMjc
02/22/2023, 9:57 PMGetApplicationMetadata()
is executed.
The error is
Lucee 5.3.10.120 Error (java.lang.NoSuchMethodError)
has anyone experienced this and know how to fix?zackster
02/23/2023, 12:47 AMjakobward
02/23/2023, 1:04 AMAsher Densmore-Lynn
02/23/2023, 3:36 PMchapmandu
02/24/2023, 3:22 AMJohn Liljegren
02/24/2023, 3:43 AMchapmandu
02/24/2023, 3:50 AM<cfquery datasource="mydsn">
UPDATE mytable
SET mycolumn = <cfqueryparam cfsqltype="cf_sql_integer" value="" null="true">
where id = 1;
</cfquery>
The code above now throws:
Invalid data [''] for CFSQLTYPE in CFQUERYPARAM
whereas Lucee5 would ignore the value if the null attribute is true.John Liljegren
02/24/2023, 8:37 AMBrandon Brown
02/24/2023, 4:33 PM"DEBUG","http-nio-8888-exec-6","02/24/2023","10:28:37","scope-context","create new session scope for TEST/12429c6b-35e9-4d0a-9ae1-5b647e88676f in cache [redissession]"
"DEBUG","http-nio-8888-exec-6","02/24/2023","10:28:37","scope-context","create new session scope for TEST/12429c6b-35e9-4d0a-9ae1-5b647e88676f in cache [redissession]"
"DEBUG","http-nio-8888-exec-6","02/24/2023","10:28:37","scope-context","create new session scope for TEST/12429c6b-35e9-4d0a-9ae1-5b647e88676f in cache [redissession]"
Failure
"DEBUG","http-nio-8888-exec-2","02/24/2023","10:29:10","scope-context","create new session scope for TEST/bdadbe7a-ead9-4d2d-97c2-1b43e0c56c2d in cache [redissession]"
"DEBUG","http-nio-8888-exec-2","02/24/2023","10:29:10","scope-context","create new session scope for TEST/bdadbe7a-ead9-4d2d-97c2-1b43e0c56c2d in cache [redissession]"
"DEBUG","http-nio-8888-exec-2","02/24/2023","10:29:10","scope-context","create new session scope for TEST/bdadbe7a-ead9-4d2d-97c2-1b43e0c56c2d in cache [redissession]"
"DEBUG","http-nio-8888-exec-2","02/24/2023","10:29:10","scope-context","create new session scope for TEST/bdadbe7a-ead9-4d2d-97c2-1b43e0c56c2d in cache [redissession]"
I am wondering if anyone has experienced something similar before? I found a lot of old bug tickets and blog posts but the bug tickets have been resolved and the blogs are more than a decade old. I don't know if locking the session
scope is still a thing or not but I did try it and it did not seem to fix it.Brandon Brown
02/24/2023, 4:34 PMJohn Liljegren
02/24/2023, 9:13 PM