Bulk Update of Oracle using JSP and SQL plus

[darshbal]

I am thinking of using SQL Loader but I have to use with JSP - as in it has to be automated using jsp - Does anyone know how to jsp code a webpage to allow one to send a file to add more tuples in my oracle databse. Antoher suggestion that someone told me was to use a parser which reads each line and sends the data oracle - Any help would be appreciated

 

[DoubleH]

Hi,
If You can use cgi, then You would be able to do with SQL loader itself or with perl. By the way in which platform does it run. Thanks & Regards,
DoubleH

 

[darshbal]

We are using Windows 2000 wiht Tomcat for the JSP

Any more help,snippets of code or website links would be much appreciated as to coding a jsp page to do this automatically.

thanks

 

[DoubleH]

Hi,
From JSP page, invoke a perl-cgi script. This can be done very easily. It's like calling another html page. Then, in that perl-cgi script, include DBI module and start coding. You can get DBI from

http://www.cpan.org.

I have used Perl-DBI in Solaris for loading a large data which invloved many tranformations and processings. The perl program would look like this:
use DBI;
my $dbh = DBI->connect ( "dbi:Oracle:archaeo", "username", "password" )
or die "Can't connect to Oracle database: $DBI::errstr\n";
my $sth = $dbh->prepare( "INSERT INTO ...." )
or die "Can't prepare INSERT statement: $DBI::errstr\n";
$sth->execute
or die "Can't execute SQL statement: $DBI::errstr\n";
$dbh->commit;
$dbh->disconnect;


hope this helps!
Thanks & Regards,
DoubleH