Problem with Insert in to SQL server

Hi everyone

i need to insert data from csv file in to the SQL server .The problem is the data will be given as parameter to the store procedure which will insert data in to different table in database.

So if there will be 10,000 records so should i execute the stored procedure 10,000 times or is there any alternative way to do it.

please suggest.

Thanks in advance

[398 byte] By [MohantySRa] at [2007-11-27 5:15:34]

«« How to pass form data in jsp to bean that can be accessed in the servlet
»» Accessing Java Access Bridge from C#

# 1

Does it have to be a stored procedure?If you have to insert 10,000 records, you are going to call something 10,000 times to do it : ) .

kdajania at 2007-7-12 10:37:52 >

top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...

# 2

What's the big deal with 10K inserts ... you should be good to go with a SP.I am not familiar with your DB. Oracle has built in support for things like this in the form of SQLLoader (sqlldr). Can you find out if your DB vendor offer a similar built-in?

abillconsla at 2007-7-12 10:37:52 >

# 3

do you think it is a wise move to execute the store procedure for 10000 times asthis is the parent store procedure and it will call other store procedure after doing some validation.Any way thanks for your suggestion.

MohantySRa at 2007-7-12 10:37:52 >

# 4

> do you think it is a wise move How could we possibly know that?It's your data. It's your program. It's your procedures. What other options do you have?

cotton.ma at 2007-7-12 10:37:52 >

Database Connectivity

Java Database Connectivity (JDBC)

Java Database Connectivity (JDBC)

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Problem with Insert in to SQL server

Database Connectivity Hot Topic

Database Connectivity

All Classified