Re: [rife-users] DatabaseException

[Geert Bevin]

Just as with a regular JDBC result set, you need to call next() before
using a row from the result set.

HTH,

Geert

On 06 Apr 2009, at 09:18, Rahul wrote:

>
> I am trying to execute a select query
>
> Select select =new Select(getDatasource());
> select.field("user_id").from(TABLE_NAME_USER).where("username = \'"
> +user.getUsername() + "\'");
> String result = (String)manager.executeQuery(select, new
> DbResultSetHandler() {
> public Object concludeResults(DbResultSet resultset)
> throws SQLException
> {
> return resultset.getString("user_id");
> }
> });
>
>
> While executing this I am getting the error
>
> com.uwyn.rife.database.exceptions.DatabaseException:
> java.sql.SQLException: Before start of result set
>
> not sure why?
>
> CAn anyone help me out with this?
> >

--
Geert Bevin
Terracotta - http://www.terracotta.org
Uwyn "Use what you need" - http://uwyn.com
RIFE Java application framework - http://rifers.org
Flytecase Band - http://flytecase.be
Music and words - http://gbevin.com