JSP assistance - off topic a little - Mailing list pgsql-jdbc

From tony
Subject JSP assistance - off topic a little
Date
Msg-id 1006183575.1414.8.camel@tonux
Whole thread Raw
Responses Re: JSP assistance - off topic a little
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Retrieving bytea column problem - they're are sometimes truncated
Next
From: Barry Lind
Date:
Subject: Re: Retrieving bytea column problem - they're are sometimes truncated