Cayenne error

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Cayenne error

Dhruti Ramani
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: Cayenne error

Gentry, Michael (Contractor)
Message
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:[hidden email]]
Sent: Thursday, August 11, 2005 4:36 PM
To: [hidden email]
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: Cayenne error

Dhruti Ramani

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)"
<[hidden email]> 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:[hidden email]]
>
> Sent: Thursday, August 11, 2005 4:36 PM
> To: [hidden email]
> 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 
 
Loading...