db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jstrunk <jstr...@stny.rr.com>
Subject Re: SQLException: Syntax error: Encountered "<EOF>" at line 1, column 19.
Date Mon, 28 Sep 2009 18:06:10 GMT

I was coding "create procedure show_suppliers ...." and the error went away
when I changed it to 
"create procedure show_suppliers() ....". Does that make sense? There are no
parms on the method but I saw the parens in a syntax diagram and thought
they might be required anyway.

The sample code I am using seems to be full of errors which makes it very
hard to learn from.
Does anyone have working sample programs that use JBDC and to create, store,
and run a SQLJ stored procedure? 

jstrunk wrote:
> I am using Eclipse 3.5.0 with Derby (not the Derby Plugin). I
> created an SQLJ stored procedure and stored it. When I try to execute it I
> get SQLException: Syntax error: Encountered "<EOF>" at line 1, column 19. 
> That is the only error information I get. How can I get a listing of what
> SQL thinks the procedure looks like up to the point where the error
> occurs?

View this message in context: http://www.nabble.com/SQLException%3A-Syntax-error%3A-Encountered-%22%3CEOF%3E%22-at-line-1%2C-column-19.-tp25638168p25650118.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

View raw message