Long type for input parameter

From: Pirola Davide (davide.pirol..tin.it)
Date: Wed Jan 26 2005 - 10:10:42 EST

  • Next message: Giulio Cesare Solaroli: "Re: Errors trying to insert values on Oracle LONG data type with Cayenne"

    Hi,
    i want to call a stored procedure that accept a NUMBER in input (es. user id).

          procedure.addParameter("user_id", new Long(12345));

    If i add a Long value, cayenne return an error.
            INFO QueryLogger: *** error.
            java.sql.SQLException: Tipo di colonna non valido
                    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
            
    The only type that works correctly is a Integer.

          procedure.addParameter("user_id", new Integer(12345));

    How i can pass a Long value instead?

    Thank's
    Davide

    This archive was generated by hypermail 2.0.0 : Wed Jan 26 2005 - 10:11:20 EST