René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Detected Oracle driver stuck during Statement initialization Caused by: java.sql.SQLRecoverableException: Closed Connection","articleBody":"I have local configuration: oracle container (19.3) + maven container and it works fine.\r\nHere is output:\r\n\r\n\u003e \r\n\u003e INFO] --- utplsql-maven-plugin:3.1.4:test (run-plsql-test-packages) @ debtcollect ---\r\n\u003e [INFO] utPLSQL Version = v3.1.10.3349\r\n\u003e [INFO] Invoking TestRunner with: /opt/debtcollect/target\r\n\u003e [INFO] TestRunner initialized\r\n\u003e [INFO] Running on utPLSQL v3.1.10.3349\r\n\u003e [INFO] Initializing reporters\r\n\u003e [INFO] Running tests\r\n\u003e [INFO] Running tests finished.\r\n\u003e [info] Writing report UT_COVERAGE_SONAR_REPORTER to /opt/debtcollect/target/coverage-sonar-report.xml\r\n\u003e [info] Writing report UT_COVERAGE_HTML_REPORTER to /opt/debtcollect/target/coverage-report.html\r\n\u003e [info] Writing report UT_SONAR_TEST_REPORTER to /opt/debtcollect/target/sonar-test-report.xml\r\n\u003e [INFO] ------------------------------------------------------------------------\r\n\u003e [INFO] BUILD SUCCESS\r\n\u003e [INFO] ------------------------------------------------------------------------\r\n\u003e [INFO] Total time:  4.462 s\r\n\u003e [INFO] Finished at: 2022-04-17T15:38:41Z\r\n\u003e [INFO] ------------------------------------------------------------------------\r\n\r\nAnd I have test oracle instance in my company (19.6) + my local maven and i've got strange error with connection.\r\nHere is output:\r\n\u003e [INFO] --- utplsql-maven-plugin:3.1.4:test (run-plsql-test-packages) @ debtcollect ---\r\n\u003e [INFO] utPLSQL Version = v3.1.10.3349\r\n\u003e [INFO] Invoking TestRunner with: /Users/ivan/Documents/Work/sandbox/debt/target\r\n\u003e [INFO] TestRunner initialized\r\n\u003e [INFO] Running on utPLSQL v3.1.10.3349\r\n\u003e [INFO] Initializing reporters\r\n\u003e [ERROR] Detected Oracle driver stuck during Statement initialization\r\n\u003e [ERROR] Unexpected error opening file ouput \r\n\u003e org.apache.maven.plugin.MojoExecutionException: Unexpected error opening file ouput \r\n\u003e     at org.utplsql.maven.plugin.reporter.ReporterWriter.writeReports (ReporterWriter.java:101)\r\n\u003e     at org.utplsql.maven.plugin.reporter.ReporterWriter.writeReporters (ReporterWriter.java:63)\r\n\u003e     at org.utplsql.maven.plugin.UtPLSQLMojo.execute (UtPLSQLMojo.java:196)\r\n\u003e     at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo (DefaultBuildPluginManager.java:137)\r\n\u003e     at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:210)\r\n\u003e     at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:156)\r\n\u003e     at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:148)\r\n\u003e     at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:117)\r\n\u003e     at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81)\r\n\u003e     at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56)\r\n\u003e     at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:128)\r\n\u003e     at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:305)\r\n\u003e     at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192)\r\n\u003e     at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105)\r\n\u003e     at org.apache.maven.cli.MavenCli.execute (MavenCli.java:972)\r\n\u003e     at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:293)\r\n\u003e     at org.apache.maven.cli.MavenCli.main (MavenCli.java:196)\r\n\u003e     at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)\r\n\u003e     at jdk.internal.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:77)\r\n\u003e     at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43)\r\n\u003e     at java.lang.reflect.Method.invoke (Method.java:568)\r\n\u003e     at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282)\r\n\u003e     at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225)\r\n\u003e     at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406)\r\n\u003e     at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347)\r\n\u003e Caused by: java.sql.SQLRecoverableException: Closed Connection\r\n\u003e     at oracle.jdbc.driver.PhysicalConnection.prepareCall (PhysicalConnection.java:1935)\r\n\u003e     at oracle.jdbc.driver.PhysicalConnection.prepareCall (PhysicalConnection.java:1911)\r\n\u003e     at oracle.jdbc.driver.PhysicalConnection.prepareCall (PhysicalConnection.java:1877)\r\n\u003e     at org.utplsql.api.outputBuffer.OutputBufferProvider.hasOutput (OutputBufferProvider.java:62)\r\n\u003e     at org.utplsql.api.outputBuffer.OutputBufferProvider.getCompatibleOutputBuffer (OutputBufferProvider.java:33)\r\n\u003e     at org.utplsql.maven.plugin.reporter.ReporterWriter.writeReports (ReporterWriter.java:74)\r\n\u003e     at org.utplsql.maven.plugin.reporter.ReporterWriter.writeReporters (ReporterWriter.java:63)\r\n\u003e     at org.utplsql.maven.plugin.UtPLSQLMojo.execute (UtPLSQLMojo.java:196)\r\n\u003e     at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo (DefaultBuildPluginManager.java:137)\r\n\u003e     at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:210)\r\n\u003e     at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:156)\r\n\u003e     at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:148)\r\n\u003e     at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:117)\r\n\u003e     at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81)\r\n\u003e     at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56)\r\n\u003e     at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:128)\r\n\u003e     at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:305)\r\n\u003e     at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192)\r\n\u003e     at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105)\r\n\u003e     at org.apache.maven.cli.MavenCli.execute (MavenCli.java:972)\r\n\u003e     at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:293)\r\n\u003e     at org.apache.maven.cli.MavenCli.main (MavenCli.java:196)\r\n\u003e     at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)\r\n\u003e     at jdk.internal.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:77)\r\n\u003e     at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43)\r\n\u003e     at java.lang.reflect.Method.invoke (Method.java:568)\r\n\u003e     at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282)\r\n\u003e     at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225)\r\n\u003e     at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406)\r\n\u003e     at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347)\r\n\u003e [INFO] ------------------------------------------------------------------------\r\n\u003e [INFO] BUILD FAILURE\r\n\u003e [INFO] ------------------------------------------------------------------------\r\n\u003e [INFO] Total time:  14.796 s\r\n\u003e [INFO] Finished at: 2022-04-17T18:35:11+03:00\r\n\u003e [INFO] ------------------------------------------------------------------------\r\n\u003e [ERROR] Failed to execute goal org.utplsql:utplsql-maven-plugin:3.1.4:test (run-plsql-test-packages) on project debtcollect: Oracle driver stuck during creating the TestRunner statement. Retry.: TimeoutException -\u003e [Help 1]\r\n\u003e [ERROR] \r\n\u003e [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.\r\n\u003e [ERROR] Re-run Maven using the -X switch to enable full debug logging.\r\n\u003e [ERROR] \r\n\u003e [ERROR] For more information about the errors and possible solutions, please read the following articles:\r\n\u003e [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException\r\n\r\nThe driver is the same, the uptplsql version is the same, the oracle version is almost the same (major = 19.0, minor is little different).\r\nWith the same oracle driver and mvn liquibase plugin i create tables and procedures on both servers, i've got this error only when try to run tests.\r\nOracle JDBC version is 19.3.0.0, also tried 21.3.0.0 but no changes.\r\nCommand ut.run on server works well of course on both servers.\r\nIf it's important: connection to company server is over VPN.\r\nIf it's important2: server is far away and first connection is kinda slow so local server connection is 100ms, remote server connection is 5-7 seconds.","author":{"url":"https://github.com/Gepar","@type":"Person","name":"Gepar"},"datePublished":"2022-04-17T15:49:02.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/104/utPLSQL-java-api/issues/104"}