1 Reply Latest reply: Mar 15, 2013 8:28 AM by Joe Weinstein-Oracle RSS

    oracle.sql.BLOB.getBytes

    882437
      Hi,

      When my application( weblogiv 12c) is trying to fetch data from a BLOB column of a table, it is getting the below exception.

           at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      Caused by: java.lang.NullPointerException
           at oracle.sql.BLOB.getBytes(BLOB.java:344)
           at oracle.jdbc.driver.OracleBlobInputStream.needBytes(OracleBlobInputStream.java:181)
           at oracle.jdbc.driver.OracleBufferedStream.readInternal(OracleBufferedStream.java:169)
           at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java:143)
           at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java:132)
           at com.tcs.bancs.ARCH.Q_USER.Get(Q_USER.java:4026)
           ... 63 more

      I am thinking in lines of inappropriate oracle drivers. This application is currently pointed to oracle 11g database and throwing exception. However, when I swtich the database to another one (oracle 10g) with exactly the same data (to be precise, it is a replica of 11g mentioned above), it functions without any issue.

      Could anyone please help me in getting through this ..