Thread: JSP assistance - off topic a little

JSP assistance - off topic a little

From
tony
Date:
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

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html


Re: JSP assistance - off topic a little

From
Isaac Sparrow
Date:
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