Re: ERROR: function rtrim(integer) does not exist
Re: ERROR: function rtrim(integer) does not exist
- Subject: Re: ERROR: function rtrim(integer) does not exist
- From: Theodore Petrosky <email@hidden>
- Date: Tue, 12 Oct 2010 13:49:30 -0700 (PDT)
I believe the external type should be 'bool' not int4.
I am going to look through the Posgresql prototypes and see what they have chosen there because they work fine.
Ted
--- On Tue, 10/12/10, Jean Pierre Malrieu <email@hidden> wrote:
> From: Jean Pierre Malrieu <email@hidden>
> Subject: Re: ERROR: function rtrim(integer) does not exist
> To: "Mike Schrag" <email@hidden>
> Cc: "Theodore Petrosky" <email@hidden>, email@hidden
> Date: Tuesday, October 12, 2010, 3:41 PM
> I am using my own prototype
> framework, and this is what I have in the
> EOJDBCPrototype.plist:
>
> {
> columnName =
> intBoolean;
> externalType =
> int4;
>
> factoryMethodArgumentType =
> EOFactoryMethodArgumentIsNSString;
> name =
> intBoolean;
> valueClassName =
> NSNumber;
> valueType = c;
> },
>
> The factoryMethodArgumentType seems suspicious to me.
> Is this correct?
>
> JPM
>
> Le 12 oct. 2010 à 15:57, Mike Schrag a écrit :
>
> > 'C' = character stream, 'c' = boolean ... verify that
> it's 'c' not 'C'
> >
> > On Oct 12, 2010, at 6:39 AM, Theodore Petrosky wrote:
> >
> >>> The attribute "sequential" is defined by the postgresql
> >>> prototype "intBoolean" with external type "int4", Data type
> >>> "Boolean-boolean c".
> >>
> >>
> >> weird I am examining my boolean object using the
> postgresql prototype and I get:
> >>
> >> Prototype: intBoolean
> >> External Type: bool
> >> Class: java.lang.Boolean
> >> Value Class: NSNumber
> >> Value Type: C
> >>
> >>
> >> ------------------------------
> >>>
> >>> Message: 4
> >>> Date: Tue, 12 Oct 2010 14:03:45 +0200
> >>> From: Jean Pierre Malrieu <email@hidden>
> >>> Subject: ERROR: function rtrim(integer) does
> not exist
> >>> To: email@hidden
> >>> Message-ID: <email@hidden>
> >>> Content-Type: text/plain; charset=us-ascii
> >>>
> >>> Hi,
> >>>
> >>> I am randomly getting exceptions like this:
> >>>
> >>> oct. 11 15:14:30 EducStat[2016]
> >>> (ERXDatabaseContextDelegate.java:175) INFO
> >>> er.transaction.adaptor.Exceptions -
> Database Exception
> >>> occured:
> com.webobjects.jdbcadaptor.JDBCAdaptorException:
> >>> EvaluateExpression failed:
> >>>
> <com.webobjects.jdbcadaptor.PostgresqlExpression:
> "SELECT
> >>> t0.ALLORNOTHING, t0.attachment_id,
> t0.AUTONOMY, t0.BLURB,
> >>> t0.classLevelID, t0.CORRECTION, t0.ID,
> t0.IDENTIFIER,
> >>> t0.MATTER_ID, t0.ORG_CODE, t0.qtiExportable,
> >>> RTRIM(t0.QUESTIONTEXT), RTRIM(t0.sequential),
> >>> t0.SERIALIZED_DATA, t0.TEACHER_ID, t0.TITLE,
> t0.TYPE FROM
> >>> series.TDITEM t0 WHERE (t0.TYPE = ?::int4 AND
> t0.ID =
> >>> ?::int4)" withBindings: 1:7(type),
> 2:48(iD)>:
> >>> Next exception:SQL State:42883 --
> error code:
> >>> 0 -- msg: ERROR: function rtrim(integer) does
> not exist
> >>>
> >>> The attribute "sequential" is defined by the
> postgresql
> >>> prototype "intBoolean" with external type
> "int4", Data type
> >>> "Boolean-boolean c".
> >>>
> >>> Why is EOF generating an rtrim() on this
> attribute?
> >>>
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden