query doesn't throw any exception

Description

If query execution fail, Lucee won't throw any error. Won't rolback transaction and so on ...

That happens when in same cfquery are executed 2 queries, and first executed query success.
Example:

<cfquery name="test2" datasource="sage">
	CREATE TABLE TestTable2(
		test_col varchar(1)
	)
</cfquery>

<cfquery name="q" datasource="sage">
	SELECT 1
</cfquery>

<!--- Example: 1 --->
<cfquery name="q" datasource="sage">
	DELETE FROM TestTable2
	insert TestTable2 (test_col) select  'zz';  -- Exception
</cfquery>
<cfdump var="#q#">

<!--- Example: 2 --->
<cfquery name="q"  datasource="sage">
	select 1;
	insert TestTable2 (test_col) select  'zz';  -- Exception
</cfquery>
<cfdump var="#q#">

ACF throws errors as expected.

Environment

DatabaseName Microsoft SQL Server
DatabaseVersion 12.00.5203
DriverName Microsoft JDBC Driver 7.0 for SQL Server
DriverVersion 7.0.0.0

Linked issues

relates to

LDEV-3127

When using the MSSQL driver exceptions are ignored

Activity

Show:

Pothys - MitrahSoft 21 April 2021 at 13:24

@Guardian Issue solved means shall I close this ticket?

Guardian 14 December 2020 at 09:31

That is fixed with JTDS driver too.

Pothys - MitrahSoft 30 November 2020 at 15:36

I've checked the ticket with @Dan Switzer, II PR in LDEV-3127. Its works fine. Now lucee throws an exception for this.

Guardian 6 March 2020 at 07:43

I have installed ACF10/18/Lucee 5.3.3.64 and Lucee 5.3.4.8 on same machine, configured with same datasource.
Tested with different versions of Microsoft SQL Server extensions 4.0/6.4.0.jre8/7.2.2.jre8

Michael Offner 6 March 2020 at 03:35

we will do some testing, but it is not Lucee that decides if an exception is thrown or not, the JDBC driver throws the exception.

Unresolved

Details
Assignee
Michael Offner
Reporter
Guardian
Priority
Blocker
Labels
JDBCerrorquery
Fix versions
5.3.8.169
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
Affects versions
5.3.3.64
5.3.4.80

Created 5 March 2020 at 14:39

Updated 19 May 2021 at 09:49