> when trying to get the resultset for my prepared statement, I get the
> following exception:
>
> org.firebirdsql.jdbc.FBSQLException: Only one resultset at a
> time/statement.
> at org.firebirdsql.jdbc.AbstractStatement.getResultSet(
> AbstractStatement.java:531)
>
> what happened?

See documentation to java.sql.Statement.getResultSet():

public ResultSet getResultSet()
throws SQLException

Retrieves the current result as a ResultSet object. This method should
be called only once per result.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Returns:
the current result as a ResultSet object or null if the result is
an update count or there are no more results
Throws:
SQLException - if a database access error occurs
See Also:
execute(java.lang.String)

Roman