good advice needed for web db project

From: kevin (kevin_at_mtel.co.uk)
Date: 01/29/04


Date: 29 Jan 2004 08:01:50 -0800

i have a project that has a postgres db updated by files sent from a
perl script to it via a jsp page as part of the http request. The
transaction is started by one request and files loaded each by one
request then another allows commit.
This causes the coding at the back to be complex and prone to
transactions locked in postgres where a session did not complete.

What better way is there to do this?

Even if it's starting again from scratch, the best method to update
multiple csv file sources into a remote system with postgres and jsp
/java?
 
please help

kevin.



Relevant Pages

  • Re: Obtaining SQL insert auto generated key from query within JSP
    ... There will be a different function for each of SQL-Server, Oracle, PostGres, MySQL, Derby and others. ... I've not used JSP so if JSP magically unifies this, that would be surprising but welcome! ...
    (comp.lang.java.programmer)
  • Re: iptables log analyzer
    ... On Thu, 2004-10-14 at 13:31, HaJo Schatz wrote: ... > into a Postgres DB and a CGI front-end analyses it on request (Ie ...
    (Fedora)
  • Re: iptables log analyzer
    ... A Perl script throws the entries ... into a Postgres DB and a CGI front-end analyses it on request (Ie ...
    (Fedora)