05-14-2012 05:37 PM
I try make application in eclipse for Blackberry. But my database have 100k rows and I tried that all sql query in txt files and I recieved this error.
Error!: too much resource data, max allowed: 7802880, found: 14240915
Also I tried convert txt files to .zip but I couldn't debug it.
How can I resolve it?
Solved! Go to Solution.
05-15-2012 08:25 AM
Thank you for interest again.
I tried this after you said. But size is still large. Firstly I divided 10 parts 13.9 MB total and then I divided 2000 parts 13.6 MB total.
I can't think other way.
05-16-2012 10:51 AM
I think i missed it...Can you please try and explain what exactly u want to acieve.
Are u trying to run sql and insert data into database...
or u r reading a database and create files....
05-16-2012 11:04 AM
My database have ~100k rows and I tried to divide my sql(have insert into...) file 2000,3000,5000 parts.
Everytime sql file was very large ~13 MB . Eclipse showed this error
Error!: too much resource data, max allowed: 7802880, found: 14240915.
And then I tried to compress sql(convert to .zip) file but I couldn't debug it again.
What should I do?
Thank you for your time.
05-16-2012 11:19 AM
One more way u can achieve this...
Do not write all ur sqls into the text file, just create the text file with data u wanted to insert .
And then generate ur sqls inside java program .
This will reduce your file size.