Re: StackOverflowError for large Scrollable result sets

Hi Jason, Just a few control questions, as Derby doesn't use PushbackInputStream much internally: 1) Which Derby version are you using? 2a) Does the failing result set contain any CLOB columns? 2b) Are you accessing an upgraded database? 1 - I just upgraded to 10.5.3 from 10.5.2 and verify it'

Re: StackOverflowError for large Scrollable result sets

Jason Ward wrote: Thanks Bryan, I should have included the info from the derby.log. Here's a small snippet of the ~1K lines from the log: 2009-09-17 14:58:48.873 GMT Thread[DRDAConnThread_19,5,derby.daemons] (XID = 5212534), (SESSIONID = 21), (DATABASE = C:/temp/testDB), (DRDAID = NF01.H0

Re: StackOverflowError for large Scrollable result sets

java.lang.StackOverflowError at java.io.BufferedInputStream.read(BufferedInputStream.java:317) at java.io.FilterInputStream.read(FilterInputStream.java:116) at org.apache.derby.iapi.services.io.LimitInputStream.read(Unknown ... That's a very interesting stack trace, thanks for includin

Re: StackOverflowError for large Scrollable result sets

Thanks Bryan, I should have included the info from the derby.log. Here's a small snippet of the ~1K lines from the log: 2009-09-17 14:58:48.873 GMT Thread[DRDAConnThread_19,5,derby.daemons] (XID = 5212534), (SESSIONID = 21), (DATABASE = C:/temp/testDB), (DRDAID = NF01.H0EE-4195946224626394

Re: StackOverflowError for large Scrollable result sets

Caused by: org.apache.derby.client.am.SqlException: DERBY SQL error: SQLCODE: -1, SQLSTATE: XJ001, SQLERRMC: java.lang.StackOverflowErrorXJ001.U at org.apache.derby.client.am.ResultSet.completeSqlca(Unknown Source) Is there a more detailed exception trace in your derby.log file? I'd expe

StackOverflowError for large Scrollable result sets

Hi folks. Has anyone had difficulties using scrollable result sets when the results sets are large? I'm hoping it's a simple configuration issue or coding problem. I'm fronting this with Hibernate so it's possible it's doing something bad... I'm investigating the ScrollableResultsImpl.java cal

slow subqueries (was: StackOverflowError)

#x27;m not sure how to do it in the general case. Any feedback or responses to the above comments are welcome. Regards, Jim > -Original Message- > From: Rajesh Kartha [mailto:[EMAIL PROTECTED] > Sent: Monday, November 06, 2006 6:04 PM > To: Derby Discussion > Subject: Re: StackOv

RE: StackOverflowError

Regards, Jim > -Original Message- > From: Rajesh Kartha [mailto:[EMAIL PROTECTED] > Sent: Monday, November 06, 2006 6:04 PM > To: Derby Discussion > Subject: Re: StackOverflowError > > > Hello Jim, > > Is it possible to try this query out with the

Re: StackOverflowError

the problem is appreciated. I'm using Derby 10.1.3.1. Thanks, Jim P.S. I just included the outer query ("select count(*) from..") to reproduce the problem in ij. My program actually uses jdbc, executes the inner query, and calls ResultSet.last(). The result is the same, a Stac

RE: StackOverflowError

Thanks, Jim P.S. I just included the outer query ("select count(*) from..") to reproduce the problem in ij. My program actually uses jdbc, executes the inner query, and calls ResultSet.last(). The result is the same, a StackOverflowError. Here's the stack trace I get in my app: Ca

StackOverflowError

Any reason why I should get a stack overflow error with the following query? Yes, I know the query is a bit odd... it's not hand-written. The query generator could be optimized. Nevertheless... is the stack overflow here considered a bug or a limitation? If limitation, what specifically is the