Java Development

[ankitagrawal]

INSERT INTO 'tablename'('column1','column2')VALUES
('data1','data2'),
('data3','data4'),
('data5','data6'),
('data7','data8');

Can I use above mentioned query in Blackberry while performing DB transaction??

[simon_hain]

i would suggest that you try the statement with an sql manager, i use sqlite manager as an addon in firefox.

[ankitagrawal]

Hi simon,

I have tried it with sqlite manager add-on, but it's not working. And also giving error while implementing in code.

So want to know - "Is there any other method to insert multiple rows into database"??

[simon_hain]

i guess you have to insert them one after another. not really my area of expertise though.

[ankitagrawal]

Thanks simon.

Please tell me the optimized way to insert rows into database.

Now, I am using bindings for Insert operations.

[shaan_softwaredvlpr]

Why don't you add these rows by running a loop like for loop.
In per loop statement insert one row. Hence you are having very less no. of rows to insert than it should not be a problem.

[ankitagrawal]

It is not an issue shaan. I just want to optimize my existing code.

Thanks for your suggestion.