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>
This archive was generated by hypermail 2.0.0 : Thu Aug 11 2005 - 16:42:40 EDT