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 protected]> wrote: > From: Jean Pierre Malrieu <[email protected]> > Subject: Re: ERROR: function rtrim(integer) does not exist > To: "Mike Schrag" <[email protected]> > Cc: "Theodore Petrosky" <[email protected]>, [email protected] > 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 protected]> > >>> Subject: ERROR: function rtrim(integer) does > not exist > >>> To: [email protected] > >>> Message-ID: <[email protected]> > >>> 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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
