aspose file tools*
The moose likes JDBC and the fly likes comparing csv file values with database attributes. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "comparing csv file values with database attributes." Watch "comparing csv file values with database attributes." New topic
Author

comparing csv file values with database attributes.

Preethi Dev
Ranch Hand

Joined: Sep 07, 2008
Posts: 265
Hi Ranchers!

could anyone suggest me how to compare(mapping) the values in the csv files with the Database table attribute values?

Based on that I need to update the records or insert with the conditions.

please help me.

Regards
Preethi
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30964
    
158

Preethi,
CSV doesn't mean anything to a database so you'd have to split the row into columns. Then you can do a normal PreparedStatement update to match. Note that the merge statement in SQL lets you do an update or insert depending on whether there is already a match.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1851
    
  16

If you are using Oracle, then you can use external tables.

Basically, Oracle external tables allow you to define a SQL table structure over a flat file e.g. in CSV format. Because this looks like any other table inside Oracle, you can then perform SQL operations on the table e.g. to compare its contents with other tables in your database. Generally if your external table is based on a CSV file then you can only read from it within Oracle i.e. you cannot write back to the CSV file.

External tables are especially useful if you have to upload large volumes of data into your database from a flat file format such as CSV: put your file in the appropriate Oracle directory, define your external table to point to that file, then simply use SQL to SELECT the data from the external table and INSERT/MERGE it into a normal relational table in the database. This bulk loading mechanism is much faster than reading records from a CSV file e.g. in Java and using individual INSERTs to write them to the DB.

Of course, if you're not using Oracle, then you're out of luck!


No more Blub for me, thank you, Vicar.
 
 
subject: comparing csv file values with database attributes.