JSP assistance - off topic a little

From: tony <tony(at)animaproductions(dot)com>
To: jdbc list <pgsql-jdbc(at)postgresql(dot)org>
Subject: JSP assistance - off topic a little
Date: 2001-11-19 15:26:14
Message-ID: 1006183575.1414.8.camel@tonux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2001-11-19 17:52:51 Re: Retrieving bytea column problem - they're are sometimes truncated
Previous Message Tom Lane 2001-11-19 05:44:42 Re: Retrieving bytea column problem - they're are sometimes truncated