Re: [dba-dev] Multiple issues with Calc and JDBC-Oracle queries to large tables

2010-12-01 Thread Ocke Janssen
Hi Alexander, On 01.12.2010 21:10, Alexander W. Janssen wrote: I already thought so; I just helped myself and did the right thing; aggregating and limiting the data using a query and then calling the query from OOo Calc. I should've done that in the first place, but I was in a rush of banging o

Re: [dba-dev] Multiple issues with Calc and JDBC-Oracle queries to large tables

2010-12-01 Thread Alexander W. Janssen
2010/12/1 Frank Schönheit : > Hello Alexander, Good evening! First, thanks to everyone to offer your help. I was quite busy lately, but I also got the chance to test out a few things. First, RC7 showed the same results on both, OSX and Linux. I also tested an older version (I forgot which, some 3

Re: [dba-dev] Base bug storing large files in a blob

2010-12-01 Thread Frank Schönheit
Hi Andrew, sorry for the delay, hope the answer is still of some use. > ** > > I am working with OpenOffice basic, HSQlDB 2.0. > > I have a table for attachments in my DB. > When i upload a File that is big for example 32 MB or 72MB in my table > which has BLOB datatype which h

Re: [dba-dev] Multiple issues with Calc and JDBC-Oracle queries to large tables

2010-12-01 Thread Frank Schönheit
Hello Alexander, > Accessing a few thousand rows works just fine, however, I got one > table with about 1.2 mio. rows at 11 columns. > ... > OK, I'm not sure if Calc was made for my certain usecase or for that > much data at all - but I thought I'll give you a hint that issues > exists. Honestly,