Cayenne error

From: Dhruti Ramani (dhrutiraman..ahoo.com)
Date: Thu Aug 11 2005 - 16:35:52 EDT

  • Next message: Gentry, Michael \(Contractor\): "RE: Cayenne error"

    Hi, I am using cayenne1.1 and postgresql as database.
    I am getting following error.
     
    16:07:02,449 INFO QueryLogger : INSERT INTO USState(a_id, abbreviation, attorney_id,cancellationPeriod,deal_id, disclouserPeriod, easeOfTransfer,hasTransferStatute, he_id, isAnnuityQuoteRequired,isAntiAssignmentLanguageAffirmed, isEstoppelRequired,
    isGuardianConsentRequiredInTheEventOfChildSupport,
    isSpecialDisclouserRequired,isSpecialPurchaseAgreementRequired, name,
    swornDeclarationRequired, usState_id) VALUES (?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

    16:07:02,451 INFO QueryLogger : [bind: NULL, NULL,
    NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
    NULL, NULL, NULL, NULL, 'TX', NULL, 273]
    16:07:02,509 INFO QueryLogger : === updated 1 row.
    16:07:02,511 INFO QueryLogger : INSERT INTO Address(a_id, city, county, he_id, streetAddress, zip) VALUES(?, ?, ?, ?, ?, ?)
    16:07:02,524 INFO QueryLogger : [bind: 273,
    'Amarillo', NULL, NULL, '"Structured Settlements, 205
    East 10th Av"', '79101']
    16:07:02,527 INFO QueryLogger : *** error.
    org.postgresql.util.PSQLException: ERROR: value too
    long for type character varying(40)

     
    Does this have to do with length of the field? Is so, I don't have any field of length 40.
    Any idea on this?
    Thanks,
    Denna

                    
    ---------------------------------
     Start your day with Yahoo! - make it your home page

    This archive was generated by hypermail 2.0.0 : Thu Aug 11 2005 - 16:35:54 EDT