5 Replies Latest reply on Jun 11, 2020 8:12 AM by 4039541

    Sql Developer 19.1 query end without giving output or error

    4039541

      Hi Team,

       

      Client is using Sql Developer 19.1 and connecting to Oracle 11.2.0.4.

       

      When they are running the query it comes out after 15-20 min without any error but query continues to run on database.

       

      Please find attached screenshot.

       

      I have also try keepalive.jar but not luck.

       

      Executing :- select * from view in 0 seconds.

        • 1. Re: Sql Developer 19.1 query end without giving output or error
          thatJeffSmith-Oracle

          There's no screenshot

           

          Also, not much for us to go on here.

          • 2. Re: Sql Developer 19.1 query end without giving output or error
            4039541

            Hi,

             

            Please find attached screenshot

             

             

            In message log i am getting below error

            ---

            java.lang.NegativeArraySizeException

            at oracle.net.ano.CryptoNIONSDataChannel.readDataFromSocketChannel(Unknown Source)

            at oracle.jdbc.driver.T4CMAREngineNIO.prepareForReading(T4CMAREngineNIO.java:98)

            at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:534)

            at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:485)

            at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)

            at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)

            at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:223)

            at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:56)

            at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:907)

            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)

            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)

            at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1300)

            at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)

            at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4230)

            at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)

            at oracle.jdbc.proxy.oracle$1dbtools$1raptor$1proxy$1driver$1oracle$1RaptorProxyOJDBCStatement$2oracle$1jdbc$1internal$1OracleCallableStatement$$$Proxy.execute(Unknown Source)

            at oracle.dbtools.db.OracleUtil.checkAccessImpl(OracleUtil.java:451)

            at oracle.dbtools.db.DBUtil.checkAccess(DBUtil.java:1815)

            at oracle.dbtools.db.AccessCache.checkAccess(AccessCache.java:64)

            at oracle.dbtools.db.AccessCache.hasAccess(AccessCache.java:55)

            at oracle.dbtools.db.AccessCache.hasAccess(AccessCache.java:24)

            at oracle.dbtools.raptor.query.QueryUtils.checkNonOracleAccess(QueryUtils.java:610)

            at oracle.dbtools.raptor.query.QueryUtils.getQuery(QueryUtils.java:410)

            at oracle.dbtools.raptor.query.QueryUtils.getQuery(QueryUtils.java:329)

            at oracle.dbtools.raptor.query.ObjectQueries.getQuery(ObjectQueries.java:46)

            at oracle.dbtools.raptor.navigator.db.xml.XmlObjectFactory.createFolderInstance(XmlObjectFactory.java:63)

            at oracle.dbtools.raptor.navigator.db.xml.XmlTypeOwnerInstance.listTypeFolders(XmlTypeOwnerInstance.java:93)

            at oracle.dbtools.raptor.navigator.db.impl.TypeContainerTreeNode.loadTypeFolders(TypeContainerTreeNode.java:121)

            at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode$LoadTask.doWork(DatabaseTreeNode.java:190)

            at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode$LoadTask.doWork(DatabaseTreeNode.java:119)

            at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:199)

            at java.util.concurrent.FutureTask.run(FutureTask.java:266)

            at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:702)

            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

            at java.util.concurrent.FutureTask.run(FutureTask.java:266)

            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

            at java.lang.Thread.run(Thread.java:748)

            • 3. Re: Sql Developer 19.1 query end without giving output or error
              4039541

              Hi Jeff,

               

              Is there any solution for that.

               

              I am able to run query on command prompt.

              • 4. Re: Sql Developer 19.1 query end without giving output or error
                thatJeffSmith-Oracle

                Weird

                 

                That error has been known for 12.1 jdbc and fix was 12.2 or higher jdbc...

                 

                Can you pull 19.4 and try that?

                 

                It has a 19c jdbc driver

                • 5. Re: Sql Developer 19.1 query end without giving output or error
                  4039541

                  Hi Jeff,

                   

                  When using Java Thick connection query runs successfully.

                   

                  jdbc:oracle:oci8:@<host-name>.local:1522/<service-name>

                   

                  But when using Java thin client, we don't get any output or error.

                   

                  jdbc:oracle:thin:@<host-name>:1522/<service-name>

                   

                  What is the solution if we need to run through JDBC thin connection?, below are the details of jdbc driver.

                   

                   

                  Database Product Name: Oracle

                  Database Product Version: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

                  With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

                  Data Mining and Real Application Testing options

                  Database Major Version: 11

                  Database Minor Version: 2

                  -- Driver Info --

                  Driver Name: Oracle JDBC driver

                  Driver Version: 12.2.0.1.0

                  Driver Major Version: 12

                  Driver Minor Version: 2

                  Driver URL: jdbc:oracle:thin:@(DESCRIPTION=    (ADDRESS=      (PROTOCOL=TCP)      (HOST=hastname)      (PORT=1522)    )    (CONNECT_DATA=      (SERVICE_NAME=aaaa)    )  )

                  Driver Location: Unable to parse URL: bundleresource://234.fwk366626712/oracle/jdbc/OracleDriver.class