Hello,

I'm using FS demo version 1.7. The application is a simple search form (just like the one in the tutorial). The only difference is that my search results grid is based on a query rather than a table. After clicking submit button, I get the following popup:

There was an error with your request. Please check your Internet connection and try reconnecting. Reconnecting in NN seconds.

There is also an error logged in catalina.out:

java.sql.SQLException: ORA-22275: invalid LOB locator specified

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)

"catalina.out" 876L, 54049C 675,2-9 77% at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8TTILob.freeTemporaryLob(T4C8TTILob.java:297) at oracle.jdbc.driver.T4CConnection.freeTemporary(T4CConnection.java:3410) at oracle.sql.CLOB.freeTemporary(CLOB.java:1044) at oracle.sql.CLOB.freeTemporary(CLOB.java:1002) at co.gerger.bdf.view.BDFServlet.doPost(BDFServlet.java:316) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at co.gerger.filters.GZIPFilter.doFilter(GZIPFilter.java:48) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:744)

I'm not selecting LOBs in my query.

asked 29 May '14, 14:19

Ilia%20Sazonov's gravatar image

Ilia Sazonov
120512
accept rate: 0%

Hi Ilia,

We are truly sorry for the inconvenience caused. Can you specify your Oracle DB and Tomcat version? Also, can you e-mail your application's export XML file and a short description explaining how to replicate this error to contact[at]theformspider.com?

Thanks in advance, Ibrahim

(30 May '14, 03:22) Ibrahim Sand... ♦♦

I'm running Oracle 12.1.0.1 on Linux. Tomcat version is installed from Formspider distro v.1.7. It appears that the issue occurs with a relatively long running query (30+ seconds). I got the message after the query had been running for the first few seconds, and then it reappeared several times while the query was running. Once the query had finished, the results displayed in a grid just fine. I've already changed my application to work around the issue to use dbms_scheduler to populate the query results into a table while the front-end is displaying a timer based progress indicator. Once the data is in the table, FS pulls it from the table and displays it in a grid perfectly fine.

Thanks, Ilia

link

answered 30 May '14, 09:27

Ilia%20Sazonov's gravatar image

Ilia Sazonov
120512
accept rate: 0%

Hi Ilia, Glad you have solved the problem.

The JavaScript library has a built-in timeout. I suspect because it took 30+ seconds for the server to respond, the JavaScript Library thought that there was an issue with the connection and it showed an error.

I am not sure what the Tomcat error is about though. The connection may indeed be broken for some reason.

Kind Regards,
Yalim

(04 Jun '14, 07:13) Yalim ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×44

Asked: 29 May '14, 14:19

Seen: 1,010 times

Last updated: 04 Jun '14, 07:14


© Copyright Gerger 2017