(cayenne) branch past-M2 updated: CAY-2954 Do not wrap selecting queries in transactions

[aadamchik]

This is an automated email from the ASF dual-hosted git repository.

asf-gitbox-commits pushed a commit to branch past-M2
in repository https://gitbox.apache.org/repos/asf/cayenne.git


The following commit(s) were added to refs/heads/past-M2 by this push:
     new 475fea2ea CAY-2954 Do not wrap selecting queries in transactions
475fea2ea is described below

commit 475fea2eac3cd245c718682833b8ce973498b017
Author: Andrus Adamchik <and...@objectstyle.com>
AuthorDate: Sat Jun 13 13:53:49 2026 -0400

    CAY-2954 Do not wrap selecting queries in transactions
    
    looks like we stumbled on a cross-DB limitation in a test, disabling for now
---
 .../test/java/org/apache/cayenne/access/DataContextBlobIT.java    | 8 ++++++--
 1 file changed, 6 insertions(+), 2 deletions(-)

diff --git 
a/cayenne/src/test/java/org/apache/cayenne/access/DataContextBlobIT.java 
b/cayenne/src/test/java/org/apache/cayenne/access/DataContextBlobIT.java
index 9efe6359f..8e8409ccd 100644
--- a/cayenne/src/test/java/org/apache/cayenne/access/DataContextBlobIT.java
+++ b/cayenne/src/test/java/org/apache/cayenne/access/DataContextBlobIT.java
@@ -25,6 +25,7 @@ import org.apache.cayenne.testdo.lob.BlobTestEntity;
 import org.apache.cayenne.unit.CayenneProjects;
 import org.apache.cayenne.unit.CayenneTestsEnv;
 import org.junit.jupiter.api.BeforeEach;
+import org.junit.jupiter.api.Disabled;
 import org.junit.jupiter.api.Test;
 import org.junit.jupiter.api.extension.RegisterExtension;
 
@@ -114,6 +115,11 @@ public class DataContextBlobIT {
         runWithBlobSize(1024 * 1024);
     }
 
+    // Disabled: comparing a LOB column in a qualifier (BLOB_COL = ?) is not 
portable SQL. Derby rejects
+    // "BLOB = BLOB" comparisons and SQL Server reports "image and varbinary 
are incompatible in the equal to
+    // operator", so this fails across the CI matrix. supportsLobs() only 
covers storing/reading LOBs, not
+    // comparing them. Re-enable once LOB-based criteria are supported with 
the appropriate per-adapter SQL.
+    @Disabled
     @Test
     public void selectWithBlobInQualifier() {
         if (skipTests()) {
@@ -125,8 +131,6 @@ public class DataContextBlobIT {
         blob.setBlobCol(bytes);
         context.commitChanges();
 
-        // TODO: change this to a real query one PostgreSQLAdapter start 
supporting LOB-based criteria (that will require
-        //  a special SQL syntax).
         assertDoesNotThrow(() -> ObjectSelect.query(BlobTestEntity.class)
                 .where(BlobTestEntity.BLOB_COL.eq(bytes))
                 .selectCount(context2));