Paulo's comment that you should use a jsp is a good one, but I can't think
of a reason that your approach shouldn't work.
Here is one thing to think about regarding your problem- Your cgi will be
executing using the web server's account. The environment (file permissions,
classpath, database authorizations, etc...) may be very different for this
user. In my case "www-data" is the user for the http server (I think this is
the apache default), so whenever I test something at the command line, I do
an "su - www-data" before running it to make sure I'm testing it in the
environment it will be using.
-NickF
--------------------------------------------------------------------------
Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of bef5471
> Sent: Monday, March 18, 2002 9:46 PM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] cgi
>
>
> I've got a java (JDK 1.3) program and it connects to a
> postgresql database (7.2 on RedHat 7.2) and execute a
> query on a table.
>
> It works fine when I execute it from command line.
> Also it works fine when I call it from a file batch like:
>
> #!/bin/sh
>
> java my_program
>
> But.. when I try to execute this program from a cgi
> script, it happens that the browser hang.
> Any Idea?
>
> Thank's since now!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>