Can you post the JSP code that acts on the database? Might be able to help
you then.
--
-------------------------------------------------------------------
Isaac Sparrow
Staff Engineer
VisiComp, Inc.
http://www.visicomp.com
GnuPG Key Fingerprint:
1060 5A07 F6EC B2B3 9AAA 3EA5 7B79 EFE1 6397 4F47
Get my public key at:
http://www.concentric.net/~issparow
You will be a winner today. Pick a fight with a four-year-old.
On Monday 19 November 2001 07:26 am, tony wrote:
> Hello,
>
> I am using JSP to update a table in Postgresql.
>
> TABLE refers_to consists of
>
> artist_id INTEGER,
> document_id INTEGER
>
> The update itself is a stored function which tests if the name and
> forename supplied corresponds to an existing artist. If so it returns
> the artist_id. If not it inserts the name and forename into the table
> and returns the currval('artist_serial') as the artist_id.
>
> Great stuff. The function works just fine in pgaccess. It also works in
> Ultradevs Query creation tool. But it is not working as a JSP. The
> variables get passed to the page but the function does not execute...
> And a horrible ugly Error 500 page is returned.
>
> I really need a debugging tool for Ultradev JSP. Does such a beast
> exist? Does this mean that i have to move up to Forte4j and learn
> Java??? Yuck...
>
> Any one have the down and dirty on Ultradev 5??? Is there JSP 1.2
> support???
>
> So many questions so little time...
>
> Cheers
>
> Tony Grant