Ben,

> Here is a simpler test case:
>
> insert into test (news) values ('aaa');
> insert into test (NEWS) values ('more than 80 chars are in
> hereeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee
> ');
> insert into test (NEWS) values ('more than 80 chars are in
> hereeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee');
>
>
> select substr(news,1,2) from test;
> select substr(news,1,2) from test;

Sorry, both selects cause me truncation exception. I use Firebird 1.5
RC 7, JayBird 1.5 beta 1. No NullPointerException...

> > This time, Jaybird will complain with the following:
> > java.lang.NullPointerException
> > at org.firebirdsql.jdbc.field.FBField.isNull
> (FBField.java:177)
> > at org.firebirdsql.jdbc.FBResultSet.getField
> > (FBResultSet.java:336)
> > at org.firebirdsql.jdbc.FBResultSet.getObject
> > (FBResultSet.java:295)
> > at Venus.doShowResultset(Venus.java:4570)
> > at Venus$11.run(Venus.java:4341)

Here's the code:

public boolean isNull() {
return (rs.row[numCol] == null);
}

rs can be null if cursor does not point to the record. Can you post
your Venus.doShowResultset method?

Thanks!
Roman