javax.servlet.ServletException: ORA-00933: SQL command not properly ended

[Guest]

I've created a little web interface that will allow users to insert a string of text to a Oracle table. This string can be up to 4000 characters long and will contain punctuation and other special characters.

My columns in the database are defined as VARCHAR

When I try to update the column from my jsp page I get a ORA-00933 error. How can I troubleshoot and correct this?

Thanks,
Greg

[Guest]

So this must not be a common problem? Anyone have any thoughts or ideas?

[Newsgroup_User]

There aren't a lot of JSP or Oracle users here.
Your problem is not specific to DW, but to Oracle. There's something it
doesn't like about your query. All messages prior to this one have fallen
out of the thread, though, so I have nothing to go on besides your error
message. Could be anything from a missing semicolon to a blank parameter to
just downright wrongness. ;)


"gfoulks" <webforumsuser@macromedia.com> wrote in message
news:eoinlj$jqh$1@forums.macromedia.com...
> So this must not be a common problem? Anyone have any thoughts or ideas?

[Guest]

well I used the DW update form wizard to create the query so i can't imagine what could be wrong with the query...

[Newsgroup_User]

Two form fields with the same name.

"gfoulks" <webforumsuser@macromedia.com> wrote in message
news:eoj6kb$8f1$1@forums.macromedia.com...
> well I used the DW update form wizard to create the query so i can't
> imagine what could be wrong with the query...

[Guest]

Lionstone,
Thanks for the message... I don't understand what you are saying?

I have just one form field collecting the input. The page loads without error but when I try to update the database with the collected input this is when I get the ORA error.

[Newsgroup_User]

I can't see your form.
Without that, the most likely explanation is that you've got two form fields
with the same name. This adds a comma and causes all kinds of syntax
errors. If you've used DW's built-in behaviors, there is a hidden field
containing the record ID. Sometimes, that hidden field gets duplicated if
you edit the behavior after it's applied; sometimes it does not.

If you don't want to try to find the duplicated field, removing and
re-applying the behavior usually fixes it.


"gfoulks" <webforumsuser@macromedia.com> wrote in message
news:ep5au9$2p0$1@forums.macromedia.com...
> Lionstone,
> Thanks for the message... I don't understand what you are saying?
>
> I have just one form field collecting the input. The page loads without
> error
> but when I try to update the database with the collected input this is
> when I
> get the ORA error.
>