Announcement Announcement Module
Collapse
No announcement yet.
Error ORA-01008 Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error ORA-01008

    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

  • #2
    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

    Comment


    • #3
      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

      Comment


      • #4
        CowBoy

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

        Comment

        Working...
        X