Error ORA-01008

[Vicente]

select
gusuarios0_.ID_USUARIO as ID1_0_0_,
gusuarios0_.ID_EMPRESA as ID2_0_0_,
gusuarios0_.LOGIN_USUARIO as LOGIN3_0_0_,
gusuarios0_.USUARIO as USUARIO0_0_,
gusuarios0_.TELF as TELF0_0_,
gusuarios0_.FAX as FAX0_0_,
gusuarios0_.E_MAIL as E7_0_0_,
gusuarios0_.F_ALTA_REG as F8_0_0_,
gusuarios0_.ES_SUPERVISOR as ES9_0_0_
from
AQUACORP.G_USUARIOS gusuarios0_
where
gusuarios0_.ID_USUARIO=?
Error de DataAccessException:
Hibernate operation:
could not load an entity:
[org.aqua.jsf.AQHibernate.GUsuarios#SPRING];
uncategorized SQLException for SQL [
select
gusuarios0_.ID_USUARIO as ID1_0_0_,
gusuarios0_.ID_EMPRESA as ID2_0_0_,
gusuarios0_.LOGIN_USUARIO as LOGIN3_0_0_,
gusuarios0_.USUARIO as USUARIO0_0_,
gusuarios0_.TELF as TELF0_0_,
gusuarios0_.FAX as FAX0_0_,
gusuarios0_.E_MAIL as E7_0_0_,
gusuarios0_.F_ALTA_REG as F8_0_0_,
gusuarios0_.ES_SUPERVISOR as ES9_0_0_
from
AQUACORP.G_USUARIOS gusuarios0_
where
gusuarios0_.ID_USUARIO=?];
SQL state [72000];
error code [1008];
ORA-01008: not all variables bound
; nested exception is java.sql.SQLException: ORA-01008: not all variables bound

[Cowboy Bob]

This exception usually means that there aren't enough parameters submitted to Oracle to perform the query.

So is the parameter for 'gusuarios0_.ID_USUARIO' null?

Bob

[Vicente]

This problem is resolve it.

I'm pass this <<username>> ( type string ) and it's error, I am passing new Long(lusername) this is work.

Thank you for all

[rrivera]

CowBoy

I'm experimenting the same problem, what happens if I'm passing null values as parameters?