aspose file tools*
The moose likes JDBC and the fly likes xls or csv  file as in parameter in stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "xls or csv  file as in parameter in stored procedure" Watch "xls or csv  file as in parameter in stored procedure" New topic
Author

xls or csv file as in parameter in stored procedure

ajse ruku
Ranch Hand

Joined: May 06, 2005
Posts: 194
Hi,
Please let me know if its possible to pass xls or csv file to a stored procedure. Stored procedure will then read the records and insert into a table. I want to do this because file is too large and processing records in java takes very long time.
regards,
Ajse
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

Have you considered JDBC's batch functionality?


My Blog: Down Home Country Coding with Scott Selikoff
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: xls or csv file as in parameter in stored procedure