Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Java Development

Reply
Contributor
Posts: 22
Registered: ‎05-14-2012
My Device: bold 9700
My Carrier: vodafone
Accepted Solution

Sqlite Large Data

Hi,

 

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?

 

Thank you.

Developer
Posts: 141
Registered: ‎07-13-2011
My Device: BB Bold
My Carrier: Vodafone

Re: Sqlite Large Data

Hi,

 

Instead of using a single file , can you try using more files.

Just try and create several sql file and process one by one.

 

Thanks

Rabi

Contributor
Posts: 22
Registered: ‎05-14-2012
My Device: bold 9700
My Carrier: vodafone

Re: Sqlite Large Data

Hi Rabi,

 

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.

Contributor
Posts: 22
Registered: ‎05-14-2012
My Device: bold 9700
My Carrier: vodafone

Re: Sqlite Large Data

Any idea?

Developer
Posts: 141
Registered: ‎07-13-2011
My Device: BB Bold
My Carrier: Vodafone

Re: Sqlite Large Data

Hi,

 

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....

 

Thx

Rabi

Contributor
Posts: 22
Registered: ‎05-14-2012
My Device: bold 9700
My Carrier: vodafone

Re: Sqlite Large Data

Hi Rabi,

 

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.

Developer
Posts: 141
Registered: ‎07-13-2011
My Device: BB Bold
My Carrier: Vodafone

Re: Sqlite Large Data

so at which point u r getting this error..

 

When reading sql from file  or when you are trying to insert into db

Contributor
Posts: 22
Registered: ‎05-14-2012
My Device: bold 9700
My Carrier: vodafone

Re: Sqlite Large Data

When  Debugging project in eclipse.

Application couldn't start.

Developer
Posts: 141
Registered: ‎07-13-2011
My Device: BB Bold
My Carrier: Vodafone

Re: Sqlite Large Data

Developer
Posts: 141
Registered: ‎07-13-2011
My Device: BB Bold
My Carrier: Vodafone

Re: Sqlite Large Data

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.

 

Regards
Rabi