Issues

 
2 of 2

query doesn't throw any exception

Unresolved

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

Details

Assignee

Reporter

Priority

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

Affects versions

Created 5 March 2020 at 14:39
Updated 19 May 2021 at 09:49

Activity

Pothys - MitrahSoft21 April 2021 at 13:24

Issue solved means shall I close this ticket?

Guardian14 December 2020 at 09:31

That is fixed with JTDS driver too.

Pothys - MitrahSoft30 November 2020 at 15:36

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

Guardian6 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 Offner6 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.