Firebird generatedkey for sql2java.properties

[tcy]

need to create "sequence" number table first "create generator SEQ_<TABLE> "

#-- Firebird ------
# the 1 is how much to increment the sequence
generatedkey.retrieve=before
generatedkey.statement=SELECT GEN_ID(SEQ_<TABLE>, 1) FROM RDB$DATABASE

[tcy]

oh got a exception in loadByWhere
Exception in thread "main" org.firebirdsql.jdbc.FBDriverNotCapableException: Result set is TYPE_FORWARD_ONLY

found a workaround, hopefully it will help others using sql2java with firebird
//pStatement = c.createStatement();
            pStatement = c.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);