DatabaseException

[Rahul-36]

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?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "rife-users" group.
To post to this group, send email to rife-users@...
To unsubscribe from this group, send email to rife-users+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rife-users?hl=en
-~----------~----~----~----~------~----~------~--~---

[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


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "rife-users" group.
To post to this group, send email to rife-users@...
To unsubscribe from this group, send email to rife-users+unsubscribe@...
For more options, visit this group at http://groups.google.com/group/rife-users?hl=en
-~----------~----~----~----~------~----~------~--~---