How to insert morethan 1 lakh records
[161 byte] By [sgnana81a] at [2007-11-27 5:41:33] 
Hi All,Can any one tell me how to insert more than 1 lakh records in jdbc program at a time.Tks in advance,Tks & RgdsGnana
# 1
You havent provided enough information on your problem.
If you have a .sql file with the entries, try to import it into your database directly without using java.
If you have it some other format, then write a java program that reads the contents of the file and insert it one row at a time.
ArcherKinga at 2007-7-12 15:19:11 >
# 2
> Hi All,> Can any one tell me how to insert more than 1> lakh records in jdbc program at a time.What is the problem, there is really no difference in inserting 10 or 1 lakh records (provided you are using a loop to do so ;) ) ?zincteapota at 2007-7-12 15:19:11 >
Database Connectivity Hot Topic
- Can i store file in Database?
- JDBC Driver Problem
- Maximum Parameters for PreparedStatement
- Instantiation Error in JAR file
- number of rows returned by SELECT LAST(column)
- PreparedStatement
- I have name of a savepoint, can i rollback to that savepoint?
- JDBC INSERT PROGRAM
- COUNT field incorrect or syntax error
- Problem with recycling connection pool
- Checking the existence of temp tables?
- max db
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding