-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Mohamad,
On 9/8/16 4:20 AM, Mohamad Abbas wrote: > Hello, > > I am working on a legacy web application running on a tomcat > 8.0.37, and i am getting an error "Invalid operation for forward > only resultset: absolute" when trying to use an > InsensitiveScrollableResultSet (to paginate results). > > To make it simple and reproduce the problem i've created a test > project who contains the "Main" class below. The test project is > executed on on a windows 7, using jdk1.8.0_92. The only jars are > present in the classpath of the project are: tomcat-jdbc(8.0.37), > tomcat-juli(8.8.37), and ojdbc7-12.1.0.2.0. > > Those are the steps to reproduce the problem: > > - Create a Statement using the method .prepareStatement(String)=> > OK - Execute the query => OK (simple query: SELECT 1 FROM dual) - > Create a new Statement (with a SCROLL_INSENSITIVE type) for the > same query (SELECT 1 FROM dual) => KO (or OK?), tomcat-jdbc is > returning the cached Statement created in Step 1 (a FORWARD_ONLY > Statement). - Execute the query => OK - Call absolute method => > Exception: Invalid operation for forward only resultset: absolute > > I don't know if it is really a bug in tomcat-jdbc or if my problem > is due to a misconfiguration. This looks like a bug to me. Please file a BZ issue for this, and include your test case. Also please include a full stack trace of the error. If this is possible to get working with an embedded database e.g. Derby (which ships with recent Java versions), please do that instead of complicating things with Oracle, etc. Thanks, - -chris -----BEGIN PGP SIGNATURE----- Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCAAGBQJX0YGsAAoJEBzwKT+lPKRYJHMQAIkgWgJq+5WQj9uNEVYE55oY aw6rqc3HOA7V5YK83Q02uPW+XxklXXc74EsJV9nSHfuG6K+gU4zk10/+1YNDM4M4 OljO9ACua+/lV21t1zqaBIr0+cJQ8dDphwMve9q1j5YNiqCB2UsxmT/fOLwUqPrx gItN5trShCDvIGlGNSx5BJS2mF5jm6yJUeFUccRUWKJWthi2jzjNjFSqBHh5+wZV aIDI8ljXpqCie5tflRM9wF+Bf/jufufssQMSY2+nmcTuu9NHyA5hshGNo3XNAIIA E3tJsi9BQ6wvR0eqV7VbgfANSGRRUpWqvaPmtiXSXvYszVjCkItPhp+drjbyFil5 6j7p/c0gWtHPhQJ9xWGnIrXvSt6otlAxNEHQedrz43wE5ekEmBTSmIFafaWYICpm vHpKoRvnEFKB2UdONRjEs7kX7arTqzpaxuqcN4/1178Cir16ab12NL5fab0cnzx8 Lwqer8EGOndtc1a5nn3vtxwd2HQb8HN+mG98Czy5ChDeiGZv4MHByCeck8wJF+nQ TqvBuIRDyrVCG09bmBIRdVb65MmdQhlxoxB+k+uURGGGY5GgkC5O21mje9N8+vcn UmmfeyDrHs4HvecvSfz7/kmFAM+yj8AqsjeYNpWQU4wG/v/kz+Eof1zkLbZs4VyH Tu30JtRs0P0hzlTAq60N =htwU -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org