Actually I had that field of 40 chars and then i made
that bigger but did not generate the schema again.
thanks for pointing out.
Thanks,
Denna
--- "Gentry, Michael (Contractor)"
<michael_gentr..anniemae.com> wrote:
> According to Emacs:
>
> "Structured Settlements, 205 East 10th Av" = 42
> characters (including
> double-quotes)
>
> In psql, do a "\d Address" and look at the
> definition of the
> "streetAddress" column. I'm guessing it's a
> varchar(40). And 42 > 40.
>
> /dev/mrg
>
>
> -----Original Message-----
> From: Dhruti Ramani [mailto:dhrutiraman..ahoo.com]
>
> Sent: Thursday, August 11, 2005 4:36 PM
> To: cayenne-use..bjectstyle.org
> Subject: 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
>
<http://us.rd.yahoo.com/evt=34442/*http://www.yahoo.com/r/hs>
>
>
>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
This archive was generated by hypermail 2.0.0 : Thu Aug 11 2005 - 16:47:47 EDT