Hi Francisco,

In the FAQ distributed with JayBird there is a list of unimplemented
methods. Most of the scrollable cursor methods are not implemented, so
resultSet.absolute(xx) throws the "non implemented" exception. There has
been a lot of discussion about this lately so you might want to check the
list archives on yahoogroups to see what folks are saying.

However, the call:

Statement statement =
con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_
ONLY);

should work, because that is implemented.

The code below is in the current cvs of
client-java\src\main\org\firebirdsql\jdbc\FBconnection which implements the
Connection interface for JayBird, so your statement call should work.

What version of JayBird are you using?

You might want to try downloading the most current version or the cvs
sources in case this was implemented recently. I think it's been done for
awhile, though.

You may also want to check to be sure you don't have an old copy of JayBird
installed in your JVM's jre/lib/ext directory because it will be found first
in your classpath and the old version of the driver will be used.

Rick


------------------------------------

//--------------------------JDBC 2.0-----------------------------

/**
*
* Creates a <code>Statement</code> object that will generate
* <code>ResultSet</code> objects with the given type and concurrency.
* This method is the same as the <code>createStatement</code> method
* above, but it allows the default result set
* type and result set concurrency type to be overridden.
*
* @param resultSetType a result set type; see ResultSet.TYPE_XXX
* @param resultSetConcurrency a concurrency type; see
ResultSet.CONCUR_XXX
* @return a new Statement object
* @exception SQLException if a database access error occurs
* @since 1.2
* @see <a href="package-summary.html#2.0 API">What Is in the JDBC 2.0
API</a>
*/
public synchronized Statement createStatement(int resultSetType,
int resultSetConcurrency) throws SQLException
{
if (resultSetType != ResultSet.TYPE_FORWARD_ONLY ||
resultSetConcurrency != ResultSet.CONCUR_READ_ONLY)
{
addWarning(new SQLWarning("Unsupported type and/or concurrency"));
}

Statement stmt = new FBStatement(this,
ResultSet.CONCUR_READ_ONLY);
activeStatements.add(stmt);
return stmt;
}

----- Original Message -----

> Why is not possible to use:
>
> resultSet.absolute(xx) or
>
> Statement statement =
>
con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_
> ONLY);
>
> The exception is always: Not implemented yet
>
> Doesn`t JayBird support this kind of implementation?