DatabaseException when running the SQLTraceListenerTest test

[OndroMih]

Hello @OndroMih, I updated my local branch too, though this time round the build is failing due to a test in SQLTraceListenerTest class, i.e, public void testSQLQueryWithListener() throws IOException, which expected an asadmin succeeded but an exception was thrown, ie

<remote failure: Error occurred during deployment: Exception while preparing the app : Exception [EclipseLink-4002] (Eclipse Persistence Services - 5.0.0-B09.v202507111153-40df9e5d15636cd7801cd5f26058b0963b6496e5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Failed to obtain/create connection from connection pool [DerbyPool]. Reason: Connection creation failed for 1 times.
Error Code: 0. Please see server.log for more details. remote failure: Error occurred during deployment: Exception while preparing the app : Exception [EclipseLink-4002] (Eclipse Persistence Services - 5.0.0-B09.v202507111153-40df9e5d15636cd7801cd5f26058b0963b6496e5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Failed to obtain/create connection from connection pool [DerbyPool]. Reason: Connection creation failed for 1 times.
Error Code: 0. Please see server.log for more details.

And this looks to be the same with the master branch, too!

Originally posted by @Ariho-Seth in #25646 (comment)

[OndroMih]

Hi @Ariho-Seth, the test should configure the DerbyPool to use the Embedded Derby database, so I don't understand the error you're getting. The test runs normally and passes on my side and in Github or Jenkins.

What's the command you execute?

[Ariho-Seth]

When I try to build ie, ../glassfish % mvn clean install
It yeilds a BUILD FAILURE with these errors;

[ERROR] Failed to execute goal org.apache.maven.plugins:maven-failsafe-plugin:3.5.2:verify (verify) on project glassfish-itest-tools: There are test failures.
[ERROR] 
[ERROR] See /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/itest-tools/target/failsafe-reports for the individual test results.
[ERROR] See dump files (if any exist) [date].dump, [date]-jvmRun[N].dump and [date].dumpstream.
[ERROR] -> [Help 1]

This started the time when I pulled all the remote branches when I wanted to rebase on the 8.0branch when I was working this PR #25646. After pulling them, the master branch also started failing to build

[OndroMih]

It's weird. Can you just go to appserver/tests/application directory in GlassFish repository and run mvn test -Dtest=org.glassfish.main.test.app.connpool.SQLTraceListenerTest? That should run this single test.

If it fails, please share the output of the maven command.

[Ariho-Seth]

Error logs

[INFO] Results:
[INFO] 
[ERROR] Failures: 
[ERROR]   SQLTraceListenerTest.<clinit>:58 
Expected: asadmin succeeded
     but: was <Remote server does not listen for requests on [localhost:4848]. Is the server up?
Unable to get remote commands. 
Closest matching local command(s): 
    help>
[INFO] 
[ERROR] Tests run: 1, Failures: 1, Errors: 0, Skipped: 0
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time:  12.877 s
[INFO] Finished at: 2025-08-04T16:23:52+01:00

[OndroMih]

This is a different problem. The server doesn't even start. Can you please paste the whole output, not only the error?

[Ariho-Seth]

arihoseth@Macbook ~/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application % mvn test -Dtest=org.glassfish.main.test.app.connpool.SQLTraceListenerTest
[INFO] Scanning for projects...
[INFO] 
[INFO] -------------< org.glassfish.main.tests:application-tests >-------------
[INFO] Building GlassFish Application Tests 7.1.0-SNAPSHOT
[INFO]   from pom.xml
[INFO] --------------------------------[ jar ]---------------------------------
[INFO] 
[INFO] --- enforcer:3.4.1:enforce (enforce-maven) @ application-tests ---
[INFO] Rule 0: org.apache.maven.enforcer.rules.version.RequireMavenVersion passed
[INFO] 
[INFO] --- jaxws:4.0.3:wsimport (jaxws-generate) @ application-tests ---
[INFO] Ignoring: file:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/src/main/resources/wsdl/hello-ejb.wsdl
[INFO] Ignoring: file:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/src/main/resources/wsdl/hello-servlet.wsdl
[INFO] 
[INFO] --- dependency:3.8.1:unpack-dependencies (unpack-glassfish) @ application-tests ---
[INFO] 
[INFO] --- compiler:3.13.0:compile (generate-hk2-config) @ application-tests ---
[INFO] Nothing to compile - all classes are up to date.
[INFO] 
[INFO] --- build-helper:3.6.1:add-resource (add-resource) @ application-tests ---
[INFO] 
[INFO] --- build-helper:3.6.1:add-resource (add-legal-resource) @ application-tests ---
[INFO] 
[INFO] --- dependency:3.8.1:unpack (unpack-resource) @ application-tests ---
[INFO] Configured Artifact: org.glassfish.main:nucleus-parent:resources:7.1.0-SNAPSHOT:zip
[INFO] 
[INFO] --- resources:3.3.1:resources (default-resources) @ application-tests ---
[INFO] Copying 59 resources from src/main/resources to target/classes
[INFO] skip non existing resourceDirectory /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/src/main/manpages
[INFO] Copying 2 resources from target/common-resources/legal to target/classes/META-INF
[INFO] 
[INFO] --- compiler:3.13.0:compile (default-compile) @ application-tests ---
[INFO] Nothing to compile - all classes are up to date.
[INFO] 
[INFO] --- compiler:3.13.0:compile (process-annotations) @ application-tests ---
[INFO] Nothing to compile - all classes are up to date.
[INFO] 
[INFO] --- resources:3.3.1:testResources (default-testResources) @ application-tests ---
[INFO] skip non existing resourceDirectory /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/src/test/resources
[INFO] 
[INFO] --- compiler:3.13.0:testCompile (default-testCompile) @ application-tests ---
[INFO] Nothing to compile - all classes are up to date.
[INFO] 
[INFO] --- surefire:3.5.2:test (default-test) @ application-tests ---
[INFO] Using auto detected provider org.apache.maven.surefire.junitplatform.JUnitPlatformProvider
[INFO] 
[INFO] -------------------------------------------------------
[INFO]  T E S T S
[INFO] -------------------------------------------------------
[0.004s][info][gc] Using G1
[0.289s][info][gc] GC(0) Pause Young (Normal) (G1 Evacuation Pause) 24M->6M(258M) 1.978ms
[INFO] Running org.glassfish.main.test.app.connpool.SQLTraceListenerTest
16:23:43.048612    INFO                 main                                                             . Using basedir: /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application
16:23:43.051127    INFO                 main                                                             . Expected GlassFish directory: /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish
16:23:43.661005    INFO                 main                                                             . STDOUT: 
Command change-admin-password executed successfully.
Admin password changed.
16:23:51.381106    INFO                 main                                                             . STDOUT: 
Debugging is enabled.  The debugging port is: 9,009
Waiting finished after 7,277 ms.
Server domain domain1 started successfuly. The startup command produced following output before it finished: 
Listening for transport dt_socket at address: 9009
Launching GlassFish on Felix platform
Resolved GlassFish install root: /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish
Resolved properties: {-upgrade=false, -read-stdin=true, -domainname=domain1, -asadmin-modulepath=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/bootstrap, -domaindir=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1, -asadmin-args=--host,,,localhost,,,--port,,,4848,,,--user,,,admin,,,--passwordfile,,,/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/password.txt,,,--secure=false,,,--terse=true,,,--echo=false,,,--interactive=false,,,start-domain,,,--verbose=false,,,--watchdog=false,,,--debug=true,,,--domaindir,,,/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains,,,domain1, -instancename=server, -type=DAS, -verbose=false, -asadmin-classpath=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/appserver-cli.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/admin-cli.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/asadmin/cluster-cli.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/asadmin/cli-optional.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/asadmin/osgi-cli-interactive.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/asadmin/server-mgmt.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/admin-util.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/backup.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/cluster-common.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/cluster-ssh.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/config-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/config-types.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/common-util.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/glassfish-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/hk2.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/hk2-config-generator.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/internal-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jackson-core.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jakarta.activation-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jakarta.validation-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jakarta.xml.bind-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jaxb-osgi.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jettison.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jsch.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/launcher.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/mimepull.jar, -debug=true, -asadmin-classname=com.sun.enterprise.admin.cli.AdminMain}
OSGI framework packages:
org.glassfish.main.jdke;uses:="javax.naming,javax.naming.spi";version="7.1.0",org.glassfish.main.jdke.cl;version="7.1.0",org.glassfish.main.jdke.i18n;version="7.1.0",org.glassfish.main.jdke.props;version="7.1.0",org.glassfish.main.jdke.security;version="7.1.0", com.sun.enterprise.glassfish.bootstrap;version="7.1.0",com.sun.enterprise.glassfish.bootstrap.cfg;version="7.1.0",com.sun.enterprise.glassfish.bootstrap.cp;uses:="com.sun.enterprise.glassfish.bootstrap.cfg";version="7.1.0",com.sun.enterprise.glassfish.bootstrap.launch;uses:="org.glassfish.main.jdke.cl";version="7.1.0",com.sun.enterprise.glassfish.bootstrap.log;version="7.1.0", org.glassfish.embeddable;version="7.1.0",org.glassfish.embeddable.client;version="7.1.0",org.glassfish.embeddable.spi;uses:="org.glassfish.embeddable";version="7.1.0", org.glassfish.main.jul;uses:="org.glassfish.main.jul.cfg,org.glassfish.main.jul.handler";version="7.1.0",org.glassfish.main.jul.cfg;version="7.1.0",org.glassfish.main.jul.env;version="7.1.0",org.glassfish.main.jul.formatter;uses:="org.glassfish.main.jul.cfg,org.glassfish.main.jul.record";version="7.1.0",org.glassfish.main.jul.handler;uses:="org.glassfish.main.jul.cfg,org.glassfish.main.jul.formatter,org.glassfish.main.jul.record";version="7.1.0",org.glassfish.main.jul.record;version="7.1.0",org.glassfish.main.jul.rotation;version="7.1.0",org.glassfish.main.jul.tracing;version="7.1.0", null, org.osgi.dto;version="1.1.1",org.osgi.framework;version="1.10",org.osgi.framework.connect;uses:="org.osgi.framework,org.osgi.framework.launch";version="1.0",org.osgi.framework.dto;uses:="org.osgi.dto";version="1.8",org.osgi.framework.hooks.bundle;uses:="org.osgi.framework";version="1.1",org.osgi.framework.hooks.resolver;uses:="org.osgi.framework.wiring";version="1.0",org.osgi.framework.hooks.service;uses:="org.osgi.framework";version="1.1",org.osgi.framework.hooks.weaving;uses:="org.osgi.framework.wiring";version="1.1",org.osgi.framework.launch;uses:="org.osgi.framework";version="1.2",org.osgi.framework.namespace;uses:="org.osgi.resource";version="1.2",org.osgi.framework.startlevel;uses:="org.osgi.framework";version="1.0",org.osgi.framework.startlevel.dto;uses:="org.osgi.dto";version="1.0",org.osgi.framework.wiring;uses:="org.osgi.framework,org.osgi.resource";version="1.2",org.osgi.framework.wiring.dto;uses:="org.osgi.dto,org.osgi.resource.dto";version="1.3",org.osgi.resource;version="1.0.1",org.osgi.resource.dto;uses:="org.osgi.dto";version="1.0.1",org.osgi.service.condition;version="1.0",org.osgi.service.packageadmin;uses:="org.osgi.framework";version="1.2.1",org.osgi.service.resolver;uses:="org.osgi.resource";version="1.1.1",org.osgi.service.startlevel;uses:="org.osgi.framework";version="1.1.1",org.osgi.service.url;version="1.0.1",org.osgi.util.tracker;uses:="org.osgi.framework";version="1.5.3"
JDK provided packages:
com.sun.enterprise.glassfish.bootstrap.cfg, com.sun.enterprise.glassfish.bootstrap.launch, com.sun.java.accessibility.util, com.sun.jdi, com.sun.jdi.connect, com.sun.jdi.connect.spi, com.sun.jdi.event, com.sun.jdi.request, com.sun.management, com.sun.net.httpserver, com.sun.net.httpserver.spi, com.sun.nio.file, com.sun.nio.sctp, com.sun.security.auth, com.sun.security.auth.callback, com.sun.security.auth.login, com.sun.security.auth.module, com.sun.security.jgss, com.sun.source.doctree, com.sun.source.tree, com.sun.source.util, com.sun.tools.attach, com.sun.tools.attach.spi, com.sun.tools.javac, com.sun.tools.jconsole, java.applet, java.awt, java.awt.color, java.awt.datatransfer, java.awt.desktop, java.awt.dnd, java.awt.event, java.awt.font, java.awt.geom, java.awt.im, java.awt.im.spi, java.awt.image, java.awt.image.renderable, java.awt.print, java.beans, java.beans.beancontext, java.io, java.lang, java.lang.annotation, java.lang.constant, java.lang.foreign, java.lang.instrument, java.lang.invoke, java.lang.management, java.lang.module, java.lang.ref, java.lang.reflect, java.lang.runtime, java.math, java.net, java.net.http, java.net.spi, java.nio, java.nio.channels, java.nio.channels.spi, java.nio.charset, java.nio.charset.spi, java.nio.file, java.nio.file.attribute, java.nio.file.spi, java.rmi, java.rmi.dgc, java.rmi.registry, java.rmi.server, java.security, java.security.cert, java.security.interfaces, java.security.spec, java.sql, java.text, java.text.spi, java.time, java.time.chrono, java.time.format, java.time.temporal, java.time.zone, java.util, java.util.concurrent, java.util.concurrent.atomic, java.util.concurrent.locks, java.util.function, java.util.jar, java.util.logging, java.util.prefs, java.util.random, java.util.regex, java.util.spi, java.util.stream, java.util.zip, javax.accessibility, javax.annotation.processing, javax.crypto, javax.crypto.interfaces, javax.crypto.spec, javax.imageio, javax.imageio.event, javax.imageio.metadata, javax.imageio.plugins.bmp, javax.imageio.plugins.jpeg, javax.imageio.plugins.tiff, javax.imageio.spi, javax.imageio.stream, javax.lang.model, javax.lang.model.element, javax.lang.model.type, javax.lang.model.util, javax.management, javax.management.loading, javax.management.modelmbean, javax.management.monitor, javax.management.openmbean, javax.management.relation, javax.management.remote, javax.management.remote.rmi, javax.management.timer, javax.naming, javax.naming.directory, javax.naming.event, javax.naming.ldap, javax.naming.ldap.spi, javax.naming.spi, javax.net, javax.net.ssl, javax.print, javax.print.attribute, javax.print.attribute.standard, javax.print.event, javax.rmi.ssl, javax.script, javax.security.auth, javax.security.auth.callback, javax.security.auth.kerberos, javax.security.auth.login, javax.security.auth.spi, javax.security.auth.x500, javax.security.cert, javax.security.sasl, javax.smartcardio, javax.sound.midi, javax.sound.midi.spi, javax.sound.sampled, javax.sound.sampled.spi, javax.sql, javax.sql.rowset, javax.sql.rowset.serial, javax.sql.rowset.spi, javax.swing, javax.swing.border, javax.swing.colorchooser, javax.swing.event, javax.swing.filechooser, javax.swing.plaf, javax.swing.plaf.basic, javax.swing.plaf.metal, javax.swing.plaf.multi, javax.swing.plaf.nimbus, javax.swing.plaf.synth, javax.swing.table, javax.swing.text, javax.swing.text.html, javax.swing.text.html.parser, javax.swing.text.rtf, javax.swing.tree, javax.swing.undo, javax.tools, javax.transaction.xa, javax.xml, javax.xml.catalog, javax.xml.crypto, javax.xml.crypto.dom, javax.xml.crypto.dsig, javax.xml.crypto.dsig.dom, javax.xml.crypto.dsig.keyinfo, javax.xml.crypto.dsig.spec, javax.xml.datatype, javax.xml.namespace, javax.xml.parsers, javax.xml.stream, javax.xml.stream.events, javax.xml.stream.util, javax.xml.transform, javax.xml.transform.dom, javax.xml.transform.sax, javax.xml.transform.stax, javax.xml.transform.stream, javax.xml.validation, javax.xml.xpath, jdk.dynalink, jdk.dynalink.beans, jdk.dynalink.linker, jdk.dynalink.linker.support, jdk.dynalink.support, jdk.javadoc.doclet, jdk.jfr, jdk.jfr.consumer, jdk.jshell, jdk.jshell.execution, jdk.jshell.spi, jdk.jshell.tool, jdk.management.jfr, jdk.net, jdk.nio, jdk.nio.mapmode, jdk.security.jarsigner, jdk.swing.interop, netscape.javascript, org.glassfish.embeddable, org.glassfish.embeddable.client, org.glassfish.embeddable.spi, org.glassfish.main.jdke, org.glassfish.main.jdke.cl, org.glassfish.main.jdke.i18n, org.glassfish.main.jdke.props, org.glassfish.main.jdke.security, org.glassfish.main.jul, org.glassfish.main.jul.cfg, org.glassfish.main.jul.env, org.glassfish.main.jul.formatter, org.glassfish.main.jul.handler, org.glassfish.main.jul.record, org.ietf.jgss, org.w3c.dom, org.w3c.dom.bootstrap, org.w3c.dom.css, org.w3c.dom.events, org.w3c.dom.html, org.w3c.dom.ls, org.w3c.dom.ranges, org.w3c.dom.stylesheets, org.w3c.dom.traversal, org.w3c.dom.views, org.w3c.dom.xpath, org.xml.sax, org.xml.sax.ext, org.xml.sax.helpers, sun.misc, sun.reflect
[#|2025-08-04T16:23:45.411618+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.system.core|_ThreadID=1;_ThreadName=main;_LevelValue=800;|
  Loaded server named: server|#]

[#|2025-08-04T16:23:45.466785+01:00|INFO|GF 7.1.0-SNAPSHOT|com.sun.enterprise.server.logging.LogManagerService|_ThreadID=45;_ThreadName=RunLevelControllerThread-1754321025437;_LevelValue=800;|
  Using property file: /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1/config/logging.properties|#]

[#|2025-08-04T16:23:45.498058+01:00|INFO|GF 7.1.0-SNAPSHOT|com.sun.enterprise.server.logging.LogManagerService|_ThreadID=45;_ThreadName=RunLevelControllerThread-1754321025437;_LevelValue=800;_MessageID=NCLS-LOGGING-00009;|
  Running GlassFish Version: Eclipse GlassFish 7.1.0-SNAPSHOT (commit: 4aeb6bafe58cc27d9c366adabafb77116dd878e8)|#]

[#|2025-08-04T16:23:45.557556+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.system.core.security|_ThreadID=44;_ThreadName=RunLevelControllerThread-1754321025436;_LevelValue=800;_MessageID=NCLS-SECURITY-01115;|
  Realm [admin-realm] of classtype [com.sun.enterprise.security.auth.realm.file.FileRealm] successfully created.|#]

[#|2025-08-04T16:23:45.558360+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.system.core.security|_ThreadID=44;_ThreadName=RunLevelControllerThread-1754321025436;_LevelValue=800;_MessageID=NCLS-SECURITY-01115;|
  Realm [file] of classtype [com.sun.enterprise.security.auth.realm.file.FileRealm] successfully created.|#]

[#|2025-08-04T16:23:45.561477+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.system.core.security|_ThreadID=44;_ThreadName=RunLevelControllerThread-1754321025436;_LevelValue=800;_MessageID=NCLS-SECURITY-01115;|
  Realm [certificate] of classtype [com.sun.enterprise.security.auth.realm.certificate.CertificateRealm] successfully created.|#]

[#|2025-08-04T16:23:45.613103+01:00|INFO|GF 7.1.0-SNAPSHOT|org.glassfish.ha.store.spi.BackingStoreFactoryRegistry|_ThreadID=47;_ThreadName=RunLevelControllerThread-1754321025440;_LevelValue=800;|
  Registered org.glassfish.ha.store.adapter.cache.ShoalBackingStoreProxy for persistence-type = replicated in BackingStoreFactoryRegistry|#]

[#|2025-08-04T16:23:45.768377+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.system.core|_ThreadID=44;_ThreadName=RunLevelControllerThread-1754321025436;_LevelValue=800;_MessageID=NCLS-CORE-00087;|
  Grizzly Framework 4.0.2 started in: 6 ms - bound to [/0.0.0.0:8181]|#]

[#|2025-08-04T16:23:45.774625+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.system.core|_ThreadID=44;_ThreadName=RunLevelControllerThread-1754321025436;_LevelValue=800;_MessageID=NCLS-CORE-00087;|
  Grizzly Framework 4.0.2 started in: 1 ms - bound to [/0.0.0.0:4848]|#]

[#|2025-08-04T16:23:45.797856+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.security.services|_ThreadID=44;_ThreadName=RunLevelControllerThread-1754321025436;_LevelValue=800;_MessageID=SEC-SVCS-00100;|
  Authorization Service has successfully initialized.|#]

[#|2025-08-04T16:23:45.819650+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.system.core|_ThreadID=46;_ThreadName=RunLevelControllerThread-1754321025440;_LevelValue=800;_MessageID=NCLS-CORE-00087;|
  Grizzly Framework 4.0.2 started in: 5 ms - bound to [/0.0.0.0:3700]|#]

[#|2025-08-04T16:23:45.862828+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.system.core|_ThreadID=1;_ThreadName=main;_LevelValue=800;_MessageID=NCLS-CORE-00017;|
  Eclipse GlassFish 7.1.0-SNAPSHOT (commit: 4aeb6bafe58cc27d9c366adabafb77116dd878e8) startup time: Felix (1,232 ms), startup services (431 ms), total (1,663 ms)|#]

[#|2025-08-04T16:23:45.864114+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.system.core|_ThreadID=1;_ThreadName=main;_LevelValue=800;_MessageID=NCLS-CORE-00018;|
  Total startup time including CLI: 2,058 ms|#]

[#|2025-08-04T16:23:45.864235+01:00|SEVERE|GF 7.1.0-SNAPSHOT|jakarta.enterprise.system.core|_ThreadID=1;_ThreadName=main;_LevelValue=1000;_MessageID=NCLS-CORE-00019;|
  Shutting down server due to startup exception
java.io.IOException: Failed to start listener com.sun.enterprise.v3.services.impl.GlassfishNetworkListener@deeaed1[name=http-listener-1, address=/0.0.0.0, port=8080]
        at org.glassfish.grizzly.config.GenericGrizzlyListener.start(GenericGrizzlyListener.java:167)
        at com.sun.enterprise.v3.services.impl.GrizzlyProxy.start0(GrizzlyProxy.java:253)
        at com.sun.enterprise.v3.services.impl.GrizzlyProxy.start(GrizzlyProxy.java:227)
        at com.sun.enterprise.v3.services.impl.GrizzlyService.createNetworkProxy(GrizzlyService.java:584)
        at com.sun.enterprise.v3.services.impl.GrizzlyService.postConstruct(GrizzlyService.java:509)
        at org.jvnet.hk2.internal.ClazzCreator.postConstructMe(ClazzCreator.java:356)
        at org.jvnet.hk2.internal.ClazzCreator.create(ClazzCreator.java:410)
        at org.jvnet.hk2.internal.SystemDescriptor.create(SystemDescriptor.java:479)
        at org.glassfish.hk2.runlevel.internal.AsyncRunLevelContext.findOrCreate(AsyncRunLevelContext.java:288)
        at org.glassfish.hk2.runlevel.RunLevelContext.findOrCreate(RunLevelContext.java:65)
        at org.jvnet.hk2.internal.Utilities.createService(Utilities.java:2111)
        at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:98)
        at org.jvnet.hk2.internal.ServiceHandleImpl.getService(ServiceHandleImpl.java:68)
        at org.glassfish.hk2.runlevel.internal.CurrentTaskFuture$QueueRunner.oneJob(CurrentTaskFuture.java:1366)
        at org.glassfish.hk2.runlevel.internal.CurrentTaskFuture$QueueRunner.run(CurrentTaskFuture.java:1294)
        at org.glassfish.hk2.runlevel.internal.CurrentTaskFuture$UpOneLevel.run(CurrentTaskFuture.java:848)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
        at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: java.net.BindException: Address already in use
        at java.base/sun.nio.ch.Net.bind0(Native Method)
        at java.base/sun.nio.ch.Net.bind(Net.java:565)
        at java.base/sun.nio.ch.ServerSocketChannelImpl.netBind(ServerSocketChannelImpl.java:344)
        at java.base/sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:301)
        at java.base/sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:89)
        at org.glassfish.grizzly.nio.transport.TCPNIOBindingHandler.bindToChannelAndAddress(TCPNIOBindingHandler.java:95)
        at org.glassfish.grizzly.nio.transport.TCPNIOBindingHandler.bind(TCPNIOBindingHandler.java:63)
        at org.glassfish.grizzly.nio.transport.TCPNIOTransport.bind(TCPNIOTransport.java:224)
        at org.glassfish.grizzly.nio.transport.TCPNIOTransport.bind(TCPNIOTransport.java:215)
        at org.glassfish.grizzly.nio.transport.TCPNIOTransport.bind(TCPNIOTransport.java:82)
        at org.glassfish.grizzly.config.GenericGrizzlyListener.start(GenericGrizzlyListener.java:164)
        ... 18 more
|#]

[#|2025-08-04T16:23:45.883672+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.system.core|_ThreadID=90;_ThreadName=Thread-11;_LevelValue=800;_MessageID=NCLS-CORE-00092;|
  Server shutdown initiated|#]

[#|2025-08-04T16:23:45.884068+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.logging.stdout|_ThreadID=90;_ThreadName=Thread-11;_LevelValue=800;|
  FileMonitoring shutdown|#]

[#|2025-08-04T16:23:45.912027+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.system.core|_ThreadID=90;_ThreadName=Thread-11;_LevelValue=800;_MessageID=NCLS-CORE-00013;|
  Shutdown procedure finished|#]

[#|2025-08-04T16:23:45.912617+01:00|INFO|GF 7.1.0-SNAPSHOT|jakarta.enterprise.logging.stdout|_ThreadID=23;_ThreadName=GlassFish Shutdown Hook;_LevelValue=800;|
  Completed shutdown of GlassFish runtime|#]


Successfully started the domain : domain1
domain  Location: /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1
Log File: /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1/logs/server.log
Admin Port: 4,848
16:23:51.383564    INFO                 main                                                             . STDERR: 
Executing: nohup /opt/homebrew/Cellar/openjdk@21/21.0.7/libexec/openjdk.jdk/Contents/Home/bin/java --module-path /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/bootstrap --add-modules ALL-MODULE-PATH -agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=*:9009 -DWALL_CLOCK_START=2025-08-04T15:23:43.805450Z -Dcom.sun.aas.debugMode=true -XX:+UnlockDiagnosticVMOptions -XX:NewRatio=2 -Xmx512m --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/sun.nio.fs=ALL-UNNAMED --add-opens=java.base/sun.net.www.protocol.jrt=ALL-UNNAMED --add-opens=java.naming/javax.naming.spi=org.glassfish.main.jdke --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED --add-opens=jdk.management/com.sun.management.internal=ALL-UNNAMED --add-exports=java.naming/com.sun.jndi.ldap=ALL-UNNAMED --add-exports=java.base/jdk.internal.vm.annotation=ALL-UNNAMED --add-opens=java.base/jdk.internal.vm.annotation=ALL-UNNAMED -javaagent:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/monitor/flashlight-agent.jar -Djava.util.logging.manager=org.glassfish.main.jul.GlassFishLogManager -Djava.util.logging.config.block=true -Djava.awt.headless=true -Djdk.corba.allowOutputStreamSubclass=true -Djdk.tls.rejectClientInitiatedRenegotiation=true -Djdk.xml.totalEntitySizeLimit=50000000 -Djavax.xml.accessExternalSchema=all -Djava.security.policy=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1/config/server.policy -Djava.security.auth.login.config=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1/config/login.conf -Dcom.sun.enterprise.security.httpsOutboundKeyAlias=s1as -Djavax.net.ssl.keyStore=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1/config/keystore.p12 -Djavax.net.ssl.trustStore=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1/config/cacerts.p12 -Djdbc.drivers=org.apache.derby.jdbc.ClientDriver -DANTLR_USE_DIRECT_CLASS_LOADING=true -Dcom.sun.enterprise.config.config_environment_factory_class=com.sun.enterprise.config.serverbeans.AppserverConfigEnvironmentFactory -Dorg.glassfish.additionalOSGiBundlesToStart=org.apache.felix.shell,org.apache.felix.gogo.runtime,org.apache.felix.gogo.shell,org.apache.felix.gogo.command,org.apache.felix.shell.remote,org.apache.felix.fileinstall -Dosgi.shell.telnet.port=6666 -Dosgi.shell.telnet.maxconn=1 -Dosgi.shell.telnet.ip=127.0.0.1 -Dgosh.args=--nointeractive -Dfelix.fileinstall.dir=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/autostart/ -Dfelix.fileinstall.poll=5000 -Dfelix.fileinstall.log.level=2 -Dfelix.fileinstall.bundles.new.start=true -Dfelix.fileinstall.bundles.startTransient=true -Dfelix.fileinstall.disableConfigSave=false -Dorg.glassfish.gmbal.no.multipleUpperBoundsException=true -Dcom.ctc.wstx.returnNullForDefaultNamespace=true -Djdk.attach.allowAttachSelf=true -Dcom.sun.aas.instanceRoot=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1 -Dcom.sun.aas.installRoot=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish -Djava.library.path=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib:/Users/2/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application com.sun.enterprise.glassfish.bootstrap.GlassFishMain -upgrade false -domaindir /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1 -read-stdin true -asadmin-args --host,,,localhost,,,--port,,,4848,,,--user,,,admin,,,--passwordfile,,,/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/password.txt,,,--secure=false,,,--terse=true,,,--echo=false,,,--interactive=false,,,start-domain,,,--verbose=false,,,--watchdog=false,,,--debug=true,,,--domaindir,,,/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains,,,domain1 -domainname domain1 -instancename server -type DAS -verbose false -asadmin-modulepath /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/bootstrap -asadmin-classpath /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/appserver-cli.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/admin-cli.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/asadmin/cluster-cli.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/asadmin/cli-optional.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/asadmin/osgi-cli-interactive.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/asadmin/server-mgmt.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/admin-util.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/backup.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/cluster-common.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/cluster-ssh.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/config-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/config-types.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/common-util.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/glassfish-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/hk2.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/hk2-config-generator.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/internal-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jackson-core.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jakarta.activation-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jakarta.validation-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jakarta.xml.bind-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jaxb-osgi.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jettison.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jsch.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/launcher.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/mimepull.jar -debug true -asadmin-classname com.sun.enterprise.admin.cli.AdminMain
Please look at the server log for more details...
16:23:51.601667    INFO                 main                                                             . STDERR: 
Remote server does not listen for requests on [localhost:4848]. Is the server up?
Unable to get remote commands. 
Closest matching local command(s): 
    help
[ERROR] Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 8.594 s <<< FAILURE! -- in org.glassfish.main.test.app.connpool.SQLTraceListenerTest
[ERROR] org.glassfish.main.test.app.connpool.SQLTraceListenerTest -- Time elapsed: 8.594 s <<< FAILURE!
java.lang.AssertionError: 

Expected: asadmin succeeded
     but: was <Remote server does not listen for requests on [localhost:4848]. Is the server up?
Unable to get remote commands. 
Closest matching local command(s): 
    help>
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.glassfish.main.itest.tools.asadmin.DomainPropertiesBackup.<init>(DomainPropertiesBackup.java:48)
        at org.glassfish.main.itest.tools.asadmin.DomainPropertiesBackup.backupDerbyPool(DomainPropertiesBackup.java:79)
        at org.glassfish.main.test.app.connpool.SQLTraceListenerTest.<clinit>(SQLTraceListenerTest.java:58)
        at java.base/jdk.internal.misc.Unsafe.ensureClassInitialized0(Native Method)
        at java.base/jdk.internal.misc.Unsafe.ensureClassInitialized(Unsafe.java:1160)
        at java.base/java.lang.reflect.Field.acquireOverrideFieldAccessor(Field.java:1200)
        at java.base/java.lang.reflect.Field.getOverrideFieldAccessor(Field.java:1169)
        at java.base/java.lang.reflect.Field.set(Field.java:836)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
        at java.base/java.util.Collections$UnmodifiableCollection.forEach(Collections.java:1116)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)

[INFO] 
[INFO] Results:
[INFO] 
[ERROR] Failures: 
[ERROR]   SQLTraceListenerTest.<clinit>:58 
Expected: asadmin succeeded
     but: was <Remote server does not listen for requests on [localhost:4848]. Is the server up?
Unable to get remote commands. 
Closest matching local command(s): 
    help>
[INFO] 
[ERROR] Tests run: 1, Failures: 1, Errors: 0, Skipped: 0
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time:  12.877 s
[INFO] Finished at: 2025-08-04T16:23:52+01:00
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:3.5.2:test (default-test) on project application-tests: There are test failures.
[ERROR] 
[ERROR] See /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/surefire-reports for the individual test results.
[ERROR] See dump files (if any exist) [date].dump, [date]-jvmRun[N].dump and [date].dumpstream.
[ERROR] -> [Help 1]
[ERROR] 
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
arihoseth@Macbook ~/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application % 

[OndroMih]

This error means there's already another GlassFish server running. Check the running processes in Task manager and kill the GlassFish process.

[Ariho-Seth]

It is still failing even after killing the process;

] 
[ERROR] Failures: 
[ERROR]   SQLTraceListenerTest.deployAll:79 
Expected: asadmin succeeded
     but: was <remote failure: Error occurred during deployment: Exception while preparing the app : Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.5.v202412231137-a96b873527f305f932543045c8679bb1de8d3a43): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Failed to obtain/create connection from connection pool [DerbyPool]. Reason: Connection creation failed for 1 times.
Error Code: 0. Please see server.log for more details.>
[ERROR]   DeployAfterFailedDeploymentTest.testDeployFailedAppAndThenFixedAppWithSameNameAndContextRoot:102 
Expected: asadmin failed in an expected way
     but: was <remote failure: Error occurred during deployment: Exception while deploying the app [DeployAfterFailedDeploymentTestOKApp] : jakarta.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.5.v202412231137-a96b873527f305f932543045c8679bb1de8d3a43): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Failed to obtain/create connection from connection pool [DerbyPool]. Reason: Connection creation failed for 1 times.
Error Code: 0. Please see server.log for more details.>
[ERROR]   JtaDataSourceResourceRefTest.deploy:64 
Expected: asadmin succeeded
     but: was <remote failure: Error occurred during deployment: Exception while deploying the app [JtaDataSourceResourceRefTestWebApp] : jakarta.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.5.v202412231137-a96b873527f305f932543045c8679bb1de8d3a43): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Failed to obtain/create connection from connection pool [DerbyPool]. Reason: Connection creation failed for 1 times.
Error Code: 0. Please see server.log for more details.>
[INFO] 
[ERROR] Tests run: 74, Failures: 3, Errors: 0, Skipped: 3

[OndroMih]

Please, run mvn test -Dtest=org.glassfish.main.test.app.connpool.SQLTraceListenerTest and paste the whole output, not only the errors.

[Ariho-Seth]

Please, run mvn test -Dtest=org.glassfish.main.test.app.connpool.SQLTraceListenerTest and paste the whole output, not only the errors.

arihoseth@Macbook ~/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application % mvn test -Dtest=org.glassfish.main.test.app.connpool.SQLTraceListenerTest
[INFO] Scanning for projects...
[INFO] 
[INFO] -------------< org.glassfish.main.tests:application-tests >-------------
[INFO] Building GlassFish Application Tests 7.1.0-SNAPSHOT
[INFO]   from pom.xml
[INFO] --------------------------------[ jar ]---------------------------------
[INFO] 
[INFO] --- enforcer:3.4.1:enforce (enforce-maven) @ application-tests ---
[INFO] Rule 0: org.apache.maven.enforcer.rules.version.RequireMavenVersion passed
[INFO] 
[INFO] --- jaxws:4.0.3:wsimport (jaxws-generate) @ application-tests ---
[INFO] Ignoring: file:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/src/main/resources/wsdl/hello-ejb.wsdl
[INFO] Ignoring: file:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/src/main/resources/wsdl/hello-servlet.wsdl
[INFO] 
[INFO] --- dependency:3.8.1:unpack-dependencies (unpack-glassfish) @ application-tests ---
[INFO] org.glassfish.main.distributions:glassfish:zip:7.1.0-SNAPSHOT already exists in destination.
[INFO] 
[INFO] --- compiler:3.13.0:compile (generate-hk2-config) @ application-tests ---
[INFO] Nothing to compile - all classes are up to date.
[INFO] 
[INFO] --- build-helper:3.6.1:add-resource (add-resource) @ application-tests ---
[INFO] 
[INFO] --- build-helper:3.6.1:add-resource (add-legal-resource) @ application-tests ---
[INFO] 
[INFO] --- dependency:3.8.1:unpack (unpack-resource) @ application-tests ---
[INFO] Configured Artifact: org.glassfish.main:nucleus-parent:resources:7.1.0-SNAPSHOT:zip
[INFO] nucleus-parent-7.1.0-SNAPSHOT-resources.zip already unpacked.
[INFO] 
[INFO] --- resources:3.3.1:resources (default-resources) @ application-tests ---
[INFO] Copying 59 resources from src/main/resources to target/classes
[INFO] skip non existing resourceDirectory /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/src/main/manpages
[INFO] Copying 2 resources from target/common-resources/legal to target/classes/META-INF
[INFO] 
[INFO] --- compiler:3.13.0:compile (default-compile) @ application-tests ---
[INFO] Nothing to compile - all classes are up to date.
[INFO] 
[INFO] --- compiler:3.13.0:compile (process-annotations) @ application-tests ---
[INFO] Nothing to compile - all classes are up to date.
[INFO] 
[INFO] --- resources:3.3.1:testResources (default-testResources) @ application-tests ---
[INFO] skip non existing resourceDirectory /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/src/test/resources
[INFO] 
[INFO] --- compiler:3.13.0:testCompile (default-testCompile) @ application-tests ---
[INFO] Nothing to compile - all classes are up to date.
[INFO] 
[INFO] --- surefire:3.5.2:test (default-test) @ application-tests ---
[INFO] Using auto detected provider org.apache.maven.surefire.junitplatform.JUnitPlatformProvider
[INFO] 
[INFO] -------------------------------------------------------
[INFO]  T E S T S
[INFO] -------------------------------------------------------
[0.004s][info][gc] Using G1
[0.251s][info][gc] GC(0) Pause Young (Normal) (G1 Evacuation Pause) 24M->6M(258M) 1.776ms
[INFO] Running org.glassfish.main.test.app.connpool.SQLTraceListenerTest
17:58:06.288627    INFO                 main                                                             . Using basedir: /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application
17:58:06.290506    INFO                 main                                                             . Expected GlassFish directory: /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish
17:58:06.575671    INFO                 main                                                             . STDOUT: 
Command change-admin-password failed.
17:58:06.575935    INFO                 main                                                             . STDERR: 
Authorization has been refused for credentials [user: admin] given in this request.
(Usually, this means invalid user name and/or password)
Admin password NOT changed.
17:58:09.011996    INFO                 main                                                             . STDOUT: 
Debugging is enabled.  The debugging port is: 9,009
Waiting finished after 1,632 ms.
Successfully started the domain : domain1
domain  Location: /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1
Log File: /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1/logs/server.log
Admin Port: 4,848
17:58:09.012213    INFO                 main                                                             . STDERR: 
Executing: nohup /opt/homebrew/Cellar/openjdk@21/21.0.7/libexec/openjdk.jdk/Contents/Home/bin/java --module-path /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/bootstrap --add-modules ALL-MODULE-PATH -agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=*:9009 -DWALL_CLOCK_START=2025-08-04T16:58:06.719642Z -Dcom.sun.aas.debugMode=true -XX:+UnlockDiagnosticVMOptions -XX:NewRatio=2 -Xmx512m --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/sun.nio.fs=ALL-UNNAMED --add-opens=java.base/sun.net.www.protocol.jrt=ALL-UNNAMED --add-opens=java.naming/javax.naming.spi=org.glassfish.main.jdke --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED --add-opens=jdk.management/com.sun.management.internal=ALL-UNNAMED --add-exports=java.naming/com.sun.jndi.ldap=ALL-UNNAMED --add-exports=java.base/jdk.internal.vm.annotation=ALL-UNNAMED --add-opens=java.base/jdk.internal.vm.annotation=ALL-UNNAMED -javaagent:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/monitor/flashlight-agent.jar -Djava.util.logging.manager=org.glassfish.main.jul.GlassFishLogManager -Djava.util.logging.config.block=true -Djava.awt.headless=true -Djdk.corba.allowOutputStreamSubclass=true -Djdk.tls.rejectClientInitiatedRenegotiation=true -Djdk.xml.totalEntitySizeLimit=50000000 -Djavax.xml.accessExternalSchema=all -Djava.security.policy=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1/config/server.policy -Djava.security.auth.login.config=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1/config/login.conf -Dcom.sun.enterprise.security.httpsOutboundKeyAlias=s1as -Djavax.net.ssl.keyStore=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1/config/keystore.p12 -Djavax.net.ssl.trustStore=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1/config/cacerts.p12 -Djdbc.drivers=org.apache.derby.jdbc.ClientDriver -DANTLR_USE_DIRECT_CLASS_LOADING=true -Dcom.sun.enterprise.config.config_environment_factory_class=com.sun.enterprise.config.serverbeans.AppserverConfigEnvironmentFactory -Dorg.glassfish.additionalOSGiBundlesToStart=org.apache.felix.shell,org.apache.felix.gogo.runtime,org.apache.felix.gogo.shell,org.apache.felix.gogo.command,org.apache.felix.shell.remote,org.apache.felix.fileinstall -Dosgi.shell.telnet.port=6666 -Dosgi.shell.telnet.maxconn=1 -Dosgi.shell.telnet.ip=127.0.0.1 -Dgosh.args=--nointeractive -Dfelix.fileinstall.dir=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/autostart/ -Dfelix.fileinstall.poll=5000 -Dfelix.fileinstall.log.level=2 -Dfelix.fileinstall.bundles.new.start=true -Dfelix.fileinstall.bundles.startTransient=true -Dfelix.fileinstall.disableConfigSave=false -Dorg.glassfish.gmbal.no.multipleUpperBoundsException=true -Dcom.ctc.wstx.returnNullForDefaultNamespace=true -Djdk.attach.allowAttachSelf=true -Dcom.sun.aas.instanceRoot=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1 -Dcom.sun.aas.installRoot=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish -Djava.library.path=/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib:/Users/2/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application com.sun.enterprise.glassfish.bootstrap.GlassFishMain -upgrade false -domaindir /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains/domain1 -read-stdin true -asadmin-args --host,,,localhost,,,--port,,,4848,,,--user,,,admin,,,--passwordfile,,,/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/password.txt,,,--secure=false,,,--terse=true,,,--echo=false,,,--interactive=false,,,start-domain,,,--verbose=false,,,--watchdog=false,,,--debug=true,,,--domaindir,,,/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/domains,,,domain1 -domainname domain1 -instancename server -type DAS -verbose false -asadmin-modulepath /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/bootstrap -asadmin-classpath /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/appserver-cli.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/admin-cli.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/asadmin/cluster-cli.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/asadmin/cli-optional.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/asadmin/osgi-cli-interactive.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/lib/asadmin/server-mgmt.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/admin-util.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/backup.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/cluster-common.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/cluster-ssh.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/config-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/config-types.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/common-util.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/glassfish-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/hk2.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/hk2-config-generator.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/internal-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jackson-core.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jakarta.activation-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jakarta.validation-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jakarta.xml.bind-api.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jaxb-osgi.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jettison.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/jsch.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/launcher.jar:/Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/glassfish7/glassfish/modules/mimepull.jar -debug true -asadmin-classname com.sun.enterprise.admin.cli.AdminMain
Please look at the server log for more details...
17:58:09.754295    INFO                 main                                                             . STDOUT: 
resources.jdbc-connection-pool.DerbyPool.property.Password=APP
resources.jdbc-connection-pool.DerbyPool.allow-non-component-callers=false
resources.jdbc-connection-pool.DerbyPool.associate-with-thread=false
resources.jdbc-connection-pool.DerbyPool.connection-creation-retry-attempts=0
resources.jdbc-connection-pool.DerbyPool.connection-creation-retry-interval-in-seconds=10
resources.jdbc-connection-pool.DerbyPool.connection-leak-reclaim=false
resources.jdbc-connection-pool.DerbyPool.connection-leak-timeout-in-seconds=0
resources.jdbc-connection-pool.DerbyPool.connection-validation-method=table
resources.jdbc-connection-pool.DerbyPool.datasource-classname=org.apache.derby.jdbc.EmbeddedDataSource
resources.jdbc-connection-pool.DerbyPool.deployment-order=100
resources.jdbc-connection-pool.DerbyPool.fail-all-connections=false
resources.jdbc-connection-pool.DerbyPool.idle-timeout-in-seconds=300
resources.jdbc-connection-pool.DerbyPool.is-connection-validation-required=false
resources.jdbc-connection-pool.DerbyPool.is-isolation-level-guaranteed=false
resources.jdbc-connection-pool.DerbyPool.lazy-connection-association=false
resources.jdbc-connection-pool.DerbyPool.lazy-connection-enlistment=false
resources.jdbc-connection-pool.DerbyPool.match-connections=false
resources.jdbc-connection-pool.DerbyPool.max-connection-usage-count=0
resources.jdbc-connection-pool.DerbyPool.max-pool-size=32
resources.jdbc-connection-pool.DerbyPool.max-wait-time-in-millis=60000
resources.jdbc-connection-pool.DerbyPool.name=DerbyPool
resources.jdbc-connection-pool.DerbyPool.non-transactional-connections=false
resources.jdbc-connection-pool.DerbyPool.object-type=user
resources.jdbc-connection-pool.DerbyPool.ping=false
resources.jdbc-connection-pool.DerbyPool.pool-resize-quantity=2
resources.jdbc-connection-pool.DerbyPool.pooling=true
resources.jdbc-connection-pool.DerbyPool.res-type=javax.sql.DataSource
resources.jdbc-connection-pool.DerbyPool.statement-cache-size=0
resources.jdbc-connection-pool.DerbyPool.statement-cache-type=
resources.jdbc-connection-pool.DerbyPool.statement-leak-reclaim=false
resources.jdbc-connection-pool.DerbyPool.statement-leak-timeout-in-seconds=0
resources.jdbc-connection-pool.DerbyPool.statement-timeout-in-seconds=-1
resources.jdbc-connection-pool.DerbyPool.steady-pool-size=8
resources.jdbc-connection-pool.DerbyPool.validate-atmost-once-period-in-seconds=0
resources.jdbc-connection-pool.DerbyPool.wrap-jdbc-objects=true
resources.jdbc-connection-pool.DerbyPool.property.DatabaseName=sun-appserv-samples
resources.jdbc-connection-pool.DerbyPool.property.User=APP
resources.jdbc-connection-pool.DerbyPool.property.connectionAttributes=;create=true
17:58:09.774173    INFO                 main                                                             . 9b40dc87-faae-4980-9d28-27cfcba40bf9.war:
/WEB-INF/
/WEB-INF/classes/
/WEB-INF/classes/org/
/WEB-INF/classes/org/glassfish/
/WEB-INF/classes/org/glassfish/main/
/WEB-INF/classes/org/glassfish/main/test/
/WEB-INF/classes/org/glassfish/main/test/app/
/WEB-INF/classes/org/glassfish/main/test/app/connpool/
/WEB-INF/classes/org/glassfish/main/test/app/connpool/webapp/
/WEB-INF/classes/org/glassfish/main/test/app/connpool/webapp/SqlListenerApplication.class
/WEB-INF/classes/org/glassfish/main/test/app/connpool/webapp/SqlListenerEndpoint.class
/WEB-INF/classes/org/glassfish/main/test/app/connpool/webapp/Employee.class
/WEB-INF/classes/META-INF/
/WEB-INF/classes/META-INF/persistence.xml
/WEB-INF/classes/META-INF/load.sql
17:58:09.781411    INFO                 main                                                             . ba263dfb-9d5a-4aea-ad09-6846badc9ab1.jar:
/org/
/org/glassfish/
/org/glassfish/main/
/org/glassfish/main/test/
/org/glassfish/main/test/app/
/org/glassfish/main/test/app/connpool/
/org/glassfish/main/test/app/connpool/lib/
/org/glassfish/main/test/app/connpool/lib/LastTraceSQLTraceListener.class
17:58:10.245748    INFO                 main                                                             . STDOUT: 
resources.jdbc-connection-pool.DerbyPool.datasource-classname=org.apache.derby.jdbc.EmbeddedDataSource
resources.jdbc-connection-pool.DerbyPool.property.PortNumber=
resources.jdbc-connection-pool.DerbyPool.property.serverName=
resources.jdbc-connection-pool.DerbyPool.property.URL=
17:58:10.461460    INFO                 main                                                             . STDOUT: 
resources.jdbc-connection-pool.DerbyPool.property.Password=APP
resources.jdbc-connection-pool.DerbyPool.allow-non-component-callers=false
resources.jdbc-connection-pool.DerbyPool.associate-with-thread=false
resources.jdbc-connection-pool.DerbyPool.connection-creation-retry-attempts=0
resources.jdbc-connection-pool.DerbyPool.connection-creation-retry-interval-in-seconds=10
resources.jdbc-connection-pool.DerbyPool.connection-leak-reclaim=false
resources.jdbc-connection-pool.DerbyPool.connection-leak-timeout-in-seconds=0
resources.jdbc-connection-pool.DerbyPool.connection-validation-method=table
resources.jdbc-connection-pool.DerbyPool.datasource-classname=org.apache.derby.jdbc.EmbeddedDataSource
resources.jdbc-connection-pool.DerbyPool.deployment-order=100
resources.jdbc-connection-pool.DerbyPool.fail-all-connections=false
resources.jdbc-connection-pool.DerbyPool.idle-timeout-in-seconds=300
resources.jdbc-connection-pool.DerbyPool.is-connection-validation-required=false
resources.jdbc-connection-pool.DerbyPool.is-isolation-level-guaranteed=false
resources.jdbc-connection-pool.DerbyPool.lazy-connection-association=false
resources.jdbc-connection-pool.DerbyPool.lazy-connection-enlistment=false
resources.jdbc-connection-pool.DerbyPool.match-connections=false
resources.jdbc-connection-pool.DerbyPool.max-connection-usage-count=0
resources.jdbc-connection-pool.DerbyPool.max-pool-size=32
resources.jdbc-connection-pool.DerbyPool.max-wait-time-in-millis=60000
resources.jdbc-connection-pool.DerbyPool.name=DerbyPool
resources.jdbc-connection-pool.DerbyPool.non-transactional-connections=false
resources.jdbc-connection-pool.DerbyPool.object-type=user
resources.jdbc-connection-pool.DerbyPool.ping=false
resources.jdbc-connection-pool.DerbyPool.pool-resize-quantity=2
resources.jdbc-connection-pool.DerbyPool.pooling=true
resources.jdbc-connection-pool.DerbyPool.res-type=javax.sql.DataSource
resources.jdbc-connection-pool.DerbyPool.statement-cache-size=0
resources.jdbc-connection-pool.DerbyPool.statement-cache-type=
resources.jdbc-connection-pool.DerbyPool.statement-leak-reclaim=false
resources.jdbc-connection-pool.DerbyPool.statement-leak-timeout-in-seconds=0
resources.jdbc-connection-pool.DerbyPool.statement-timeout-in-seconds=-1
resources.jdbc-connection-pool.DerbyPool.steady-pool-size=8
resources.jdbc-connection-pool.DerbyPool.validate-atmost-once-period-in-seconds=0
resources.jdbc-connection-pool.DerbyPool.wrap-jdbc-objects=true
resources.jdbc-connection-pool.DerbyPool.property.DatabaseName=sun-appserv-samples
resources.jdbc-connection-pool.DerbyPool.property.User=APP
resources.jdbc-connection-pool.DerbyPool.property.connectionAttributes=;create=true
17:58:10.663385    INFO                 main                                                             . STDOUT: 
resources.jdbc-connection-pool.DerbyPool.sql-trace-listeners=org.glassfish.main.test.app.connpool.lib.LastTraceSQLTraceListener
17:58:12.297666    INFO                 main                                                             . STDERR: 
remote failure: Error occurred during deployment: Exception while preparing the app : Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.5.v202412231137-a96b873527f305f932543045c8679bb1de8d3a43): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Failed to obtain/create connection from connection pool [DerbyPool]. Reason: Connection creation failed for 1 times.
Error Code: 0. Please see server.log for more details.
17:58:12.513121    INFO                 main                                                             . STDERR: 
remote failure: Application webapp is not deployed on this target [server]
17:58:12.730182    INFO                 main                                                             . STDOUT: 
resources.jdbc-connection-pool.DerbyPool.sql-trace-listeners=
[ERROR] Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 6.682 s <<< FAILURE! -- in org.glassfish.main.test.app.connpool.SQLTraceListenerTest
[ERROR] org.glassfish.main.test.app.connpool.SQLTraceListenerTest -- Time elapsed: 6.682 s <<< FAILURE!
java.lang.AssertionError: 

Expected: asadmin succeeded
     but: was <remote failure: Error occurred during deployment: Exception while preparing the app : Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.5.v202412231137-a96b873527f305f932543045c8679bb1de8d3a43): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Failed to obtain/create connection from connection pool [DerbyPool]. Reason: Connection creation failed for 1 times.
Error Code: 0. Please see server.log for more details.>
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
        at org.glassfish.main.test.app.connpool.SQLTraceListenerTest.deployAll(SQLTraceListenerTest.java:79)
        at java.base/java.lang.reflect.Method.invoke(Method.java:580)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
        Suppressed: org.opentest4j.MultipleFailuresError: Multiple Failures (1 failure)
        java.lang.AssertionError: 
Expected: asadmin succeeded
     but: was <remote failure: Application webapp is not deployed on this target [server]>
                at org.glassfish.main.test.app.connpool.SQLTraceListenerTest.undeployAll(SQLTraceListenerTest.java:86)
                at java.base/java.lang.reflect.Method.invoke(Method.java:580)
                at java.base/java.util.ArrayList.forEach(ArrayList.java:1596)
                at java.base/java.util.Collections$UnmodifiableCollection.forEach(Collections.java:1116)
                ... 1 more
                Suppressed: java.lang.AssertionError: 
Expected: asadmin succeeded
     but: was <remote failure: Application webapp is not deployed on this target [server]>
                        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
                        at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6)
                        at org.glassfish.main.test.app.connpool.SQLTraceListenerTest.lambda$undeployAll$0(SQLTraceListenerTest.java:87)
                        at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)
                        at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:1024)
                        at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)
                        at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:499)
                        at java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:921)
                        at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
                        at java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:682)
                        ... 5 more

[INFO] 
[INFO] Results:
[INFO] 
[ERROR] Failures: 
[ERROR]   SQLTraceListenerTest.deployAll:79 
Expected: asadmin succeeded
     but: was <remote failure: Error occurred during deployment: Exception while preparing the app : Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.5.v202412231137-a96b873527f305f932543045c8679bb1de8d3a43): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Failed to obtain/create connection from connection pool [DerbyPool]. Reason: Connection creation failed for 1 times.
Error Code: 0. Please see server.log for more details.>
[INFO] 
[ERROR] Tests run: 1, Failures: 1, Errors: 0, Skipped: 0
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time:  10.089 s
[INFO] Finished at: 2025-08-04T17:58:14+01:00
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:3.5.2:test (default-test) on project application-tests: There are test failures.
[ERROR] 
[ERROR] See /Users/2/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application/target/surefire-reports for the individual test results.
[ERROR] See dump files (if any exist) [date].dump, [date]-jvmRun[N].dump and [date].dumpstream.
[ERROR] -> [Help 1]
[ERROR] 
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
arihoseth@Macbook ~/ariho/Programming/Opensource-Projects/glassfish/appserver/tests/application % 

[Ariho-Seth]

This is th output when I run the DeployAfterFailedDeploymentTest test individually
This line assertThat(ASADMIN.exec("deploy", "--name", OK_APP_NAME, "--contextroot", "/", failingAppWarFile.getAbsolutePath()), asadminError("Initialization failed for Singleton BeanFailingDeployment")); is the one failing

java.lang.AssertionError: 
Expected: asadmin failed in an expected way
     but: was <remote failure: Error occurred during deployment: Exception while deploying the app [DeployAfterFailedDeploymentTestOKApp] : jakarta.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 4.0.5.v202412231137-a96b873527f305f932543045c8679bb1de8d3a43): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Failed to obtain/create connection from connection pool [DerbyPool]. Reason: Connection creation failed for 1 times.
Error Code: 0. Please see server.log for more details.>
<Click to see difference>
``

[Ariho-Seth]

Hello @OndroMih, I think I've found the problem. I had deleted the maven.config file because I couldn't run the website locally, as I mentioned here #25503 (comment)

But since then, I didn't know that deleting it came with side effects.
Though that means I won't be running the website locally since I have replaced it as required here

glassfish/README.md

Line 49 in afe25f3

If you use Maven 3.9+, we recommend that you copy the `.mvn/maven.config.template` file into `.mvn/maven.config` and uncomment one of the options there or customize the options as you need. Then you can just run `mvn clean install` and the options in `maven.config` will be applied automatically. Or with just `mvn`, the default goal will be run with those options. See [Configuring Maven Documentation](https://maven.apache.org/configure.html)