I am not sure, but I shall have a quick stab...

How do you know the name of the column is PK_SN? If I do a select MAX()...
In my DB Tool, the column name returned is "MAX"... Whenever I do this in
code, I usually just grab the first column returned... Not sure in java, but
Delphi might be something like Fields[0].AsInteger...

May or may not be the problem...

Regards
Colin

-----Original Message-----
From: Phil [mailto:time_lord@...]
Sent: Monday, 31 May 2004 3:55 p.m.
To: firebird-support@yahoogroups.com
Cc: Firebird-Java@yahoogroups.com
Subject: [firebird-support] Query returning row when it shouldn't...

Hi, I'm a new Firebird user, using Firebird-1.5.0.4306-Win32 and
Firebird-JDBC-SQL-1.5.0Beta3JDK_1.4.

I have a new database , no data in it yet. When my application starts it
looks for a value in the database, returning it if found, i.e something
like:

...
java.sql.Statement s = myConnection.createStatement();
ResultSet rs = s.executeQuery("select max(PK_SN) from MYTABLE");
if (rs.next())
// Then the row exists - return the value:
return rs.getInt("PK_SN");

However an exception occurs on the last line:
"org.firebirdsql.jdbc.FBSQLException: Column name PK_SN not found in result
set"
This in itself is not a suprise because there are no rows... the problem is
that rs.next() should return false (indicating that there is not a 'next'
row).

Can anyone confirm that this is a bug and suggest the 'firebird' way of
doing it? (This sort of thing works properly with SQLserver )

TIA




------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/67folB/TM
--------------------------------------------------------------------~->


Yahoo! Groups Links






######################################################################
Attention:
The information in this email and in any attachments is confidential.
If you are not the intended recipient then please do not distribute,
copy or use this information. Please notify us immediately by return
email and then delete the message from your computer.
Any views or opinions presented are solely those of the author.
######################################################################