Re: seeking explanation of SQLException error message

[Tim Watts]

On Wed, 2013-10-23 at 10:48 -0700, Bob M wrote:
> hi
> 
> I have the following code
> *****************
> // retrieve and output date and time of oldest record from the table
> rs = s.executeQuery("SELECT * FROM USD_JPY ORDER BY Date ASC, Time ASC FETCH
> FIRST ROW ONLY");
> rs.next();
> String Date2 = rs.getString("Date");
> int Time2 = rs.getInt("Time");
> 
> myConsole.getOut().println("Date/Time: " + Date2 + ", " + Time2);
> 
> // and now delete this record.............
> 
> s.setCursorName("MYCURSOR");
> rs = s.executeQuery("SELECT * from USD_JPY WHERE Date = Date2 AND Time =
> Time2 FOR UPDATE");
> rs.next();
> conn.prepareStatement("DELETE FROM USD_JPY WHERE CURRENT OF
> MYCURSOR").executeUpdate();
> 
> myConsole.getOut().println("Deleted oldest record");
> ******************************
> 
> and the following log.............
> 
> 2013-10-23 17:30:55   Message: Column 'DATE2' is either not in any table in
> the FROM list or appears within a join specification and is outside the
> scope of the join specification or appears in a HAVING clause and is not in
> the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then
> 'DATE2' is not a column in the target table.
> 2013-10-23 17:30:55   Error Code: 20000
> 2013-10-23 17:30:55   SQL State: 42X04

It's telling you that the table USD_JPY doesn't have a column named
DATE2.  Perhaps what you want is something like this instead:

"SELECT * from USD_JPY WHERE Date = '" + Date2 + "' AND Time = " + Time2
+ " FOR UPDATE"

(Note the string concatenations and single quotes around the date value)

How far along are you on that SQL tutorial? :-)


> 2013-10-23 17:30:55   ----- SQLException -----
> 2013-10-23 17:30:55   Date/Time: 01-01-2010, 0
> 
> Can somebody throw some light on what the problem might be ?
> 
> Bob M 
> 
> 
> 
> --
> View this message in context: 
> http://apache-database.10148.n7.nabble.com/seeking-explanation-of-SQLException-error-message-tp135002.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.

signature.asc
Description: This is a digitally signed message part