Using Firebird 1.0 and JBird RC1 (not RC1a) I get an strange error when
doing a join:

javax.servlet.ServletException:
GDS Exception:
org.firebirdsql.gds.GDSException:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 46
outer

PreparedStatement stmtR = conn.prepareStatement(
"select A.*, AG.GrantDBID " +
"from Activity A" +
"left outer join ActivityGrants AG on A.DBID=AG.ActivityDBID " +
"where A.DBID=?");
stmtR.setString(1,activityDBID);
rsR = stmtR.executeQuery();

The query runs fine under IBExpert with a constant in place of the ? but
not under Tomcat 4.0.4 in a JSP file.

I will download JBird RC1a and see if that fixes it. In the meantime anyone
see anything wrong?