I've created Bug 60099 <https://bz.apache.org/bugzilla/show_bug.cgi?id=60099>
2016-09-08 17:20 GMT+02:00 Christopher Schultz <ch...@christopherschultz.net >: > -----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 > >
