3 Replies Latest reply on Nov 20, 2014 1:15 PM by user4176461

    ORA-00942 on File-Upload by oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader checkDocMethod

    user4176461

      Hi,

       

      I want to user the ApexListner/ORDS for uploading BLOB-files into the database (11g).

      (without using APEX -, no Apex-Schema is available, all Apex stuff removed by the dba...)

       

      I'm using ords.war in standalone mode - and in default.xml the key entry apex.docTable for the document table is set.

      On submitting a multipart/form-data form, I receive an "ora-00942 table or view does not exist" error.

      (same problem either with ApexListener 2.0.4 or ORDS 2.0.9)

       

      htp.p() and file downloading works fine.

       

      Any idea to solve this problem?

       

      Thanks

      Klaus

       

      INFO: Using configuration folder: C:\test_ords\ords

      Configuration properties for: apex

      apex.docTable=Z_DOCUMENTS

       

      INFO: Oracle REST Data Services initialized
      Oracle REST Data Services version : 2.0.9.224.01.05
      Oracle REST Data Services server info: Grizzly/1.9.49

      17.10.2014 15:59:26 com.sun.grizzly.Controller logVersion
      INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 17.10.14 15:59
      17.10.2014 15:59:27 oracle.dbtools.standalone.Standalone execute
      INFO: http://localhost:8080/ords/ gestartet.
      17.10.2014 15:59:51 oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader checkDocMethod
      SCHWERWIEGEND: ORA-00942: Tabelle oder View nicht vorhanden

       

      java.sql.SQLSyntaxErrorException: ORA-00942: Tabelle oder View nicht vorhanden

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:505)
              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:223)
              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
              at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
              at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3612)
              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3656)
              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:111)
              at com.sun.proxy.$Proxy44.executeQuery(Unknown Source)
              at oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader.checkDocMethod(ApexFileLoader.java:108)
              at oracle.dbtools.apex.hooks.fileUpload.ApexFileLoader.processFile(ApexFileLoader.java:73)
              at oracle.dbtools.apex.hooks.ProcessorRegistry.fileUploadPreProcess(ProcessorRegistry.java:95)
              at oracle.dbtools.apex.FileUpload.loadFiles(FileUpload.java:63)
              at oracle.dbtools.apex.ModApex.doPost(ModApex.java:143)
              at oracle.dbtools.apex.ModApex.service(ModApex.java:303)
              at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:350)
              at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
              at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.doFilter(ServletAdapter.java:1059)
              at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.invokeFilterChain(ServletAdapter.java:999)
              at com.sun.grizzly.http.servlet.ServletAdapter.doService(ServletAdapter.java:434)
              at oracle.dbtools.standalone.SecureServletAdapter.doService(SecureServletAdapter.java:91)
              at com.sun.grizzly.http.servlet.ServletAdapter.service(ServletAdapter.java:379)
              at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
              at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.service(GrizzlyAdapterChain.java:196)
              at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
              at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:849)
              at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:746)
              at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1045)
              at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:228)
              at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
              at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
              at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
              at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
              at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
              at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
              at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
              at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
              at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
              at java.lang.Thread.run(Unknown Source)