• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: [Wonder-disc] OpenBase / boolean / ERPrototypes
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Wonder-disc] OpenBase / boolean / ERPrototypes

  • Subject: Re: [Wonder-disc] OpenBase / boolean / ERPrototypes
  • From: "Ricardo J. Parada" <email@hidden>
  • Date: Sun, 08 Mar 2009 18:49:50 -0400


Hmmm... I tried changing the column type in openbase to an integer and saved the change.  Then I deleted my EOAttribute from my entity and added it back, this time using intBoolean.  But as soon as I fetch my EO from the database it blows up with the following exception:

er.transaction.adaptor.Exceptions  - Database Exception occured: com.webobjects.foundation.NSForwardException [java.lang.NoSuchMethodException] Class java.lang.Number does not implement method valueOf:java.lang.NoSuchMethodException: Class java.lang.Number does not implement method valueOf

The query looks right though.  It just seems that the EOAttribute is having trouble converting the value from the database to the type used in the EO.

[2009-3-8 18:42:3 EDT] <WorkerThread0> com.webobjects.foundation.NSForwardException [java.lang.NoSuchMethodException] Class java.lang.Number does not implement method valueOf:java.lang.NoSuchMethodException: Class java.lang.Number does not implement method valueOf
at com.webobjects.foundation.NSForwardException._runtimeExceptionForThrowable(NSForwardException.java:41)
at com.webobjects.eoaccess.EOAttribute.newValueForString(EOAttribute.java:2003)
at com.webobjects.jdbcadaptor.JDBCColumn._newValueForString(JDBCColumn.java:675)
at com.webobjects.jdbcadaptor.JDBCColumn._fetchCorrectObject(JDBCColumn.java:334)
at com.webobjects.jdbcadaptor.JDBCColumn._fetchValue(JDBCColumn.java:384)
at com.webobjects.jdbcadaptor.JDBCColumn.fetchValue(JDBCColumn.java:372)
at com.webobjects.jdbcadaptor.JDBCChannel.fetchRow(JDBCChannel.java:1462)
at com.webobjects.eoaccess.EODatabaseChannel._fetchObject(EODatabaseChannel.java:321)
at com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3071)
at com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195)
at com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488)
at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069)
at er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1114)
at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4444)
at com.paradacafe.model._Cliente.fetchBusqueda(_Cliente.java:516)
at com.paradacafe.webapps.admin.components.ClientesBusqueda.buscar(ClientesBusqueda.java:132)
[...snip...]
at er.extensions.components.ERXComponent.invokeAction(ERXComponent.java:92)
at com.webobjects.appserver.WOSession.invokeAction(WOSession.java:1357)
at com.webobjects.appserver.WOApplication.invokeAction(WOApplication.java:1745)
at er.extensions.appserver.ajax.ERXAjaxApplication.invokeAction(ERXAjaxApplication.java:49)
at er.extensions.appserver.ERXApplication.invokeAction(ERXApplication.java:1622)
[...snip...]



On Mar 8, 2009, at 6:25 PM, Ricardo J. Parada wrote:

Hi Mike,

Not sure I understood what you mean by flag.  :-)

Anyways, here's the boolean protototype from ERPrototypes as defined in EOJDBCOpenBasePrototypes.plist:

        {
            adaptorValueConversionMethodName = toString;
            columnName = "";
            externalType = varchar;
            factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString;
            name = boolean;
            valueClassName = "java.lang.Boolean";
            valueFactoryMethodName = valueOf;
            valueType = S;
            width = 5;
        },

and the intBoolean prototype is setup as follows:

        {
            adaptorValueConversionMethodName = toString;
            columnName = "";
            externalType = bool;
            factoryMethodArgumentType = EOFactoryMethodArgumentIsNSString;
            name = intBoolean;
            valueClassName = NSNumber;
            valueFactoryMethodName = valueOf;
            valueType = c;
        },

I tried both and neither one works for me.  Anybody out there using OpenBase 10.0.11 with and boolean properties in your columns and EOs?


I've been trying all kinds of things to get these booleans to work...  And I just thought of one which might work.  I'll change the type in openbase for those columns back to integer type.  Then I'll use the intBoolean prototype from ERPrototypes.  I assume that's what the intBoolean prototype is for: to have a boolean in your EO stored as an integer in the database.  Right?




On Mar 8, 2009, at 10:20 AM, Mike Schrag wrote:

"boolean" in erp = varchar, not boolean, "intBoolean" in erp = number, "flag" = probably what OB is calling "boolean", but you'd have to check if the OB variant of erp declares this properly.

ms

On Mar 8, 2009, at 3:06 AM, Ricardo J. Parada wrote:

Hi All,

There seems to be something wrong with booleans when using OpenBase and ERPrototypes.

In OpenBaseManager the column type for my column says boolean:

<Picture 2.png>

In openisql (command line) I can query like this:

select count(*) from cliente where suspendido = true

of like this:

select count(*) from cliente where suspendido = 1

In entity modeler, if I configure my attribute using the boolean prototype from ERPrototypes as shown below, then the queries don't return the right number of rows.  The update statements generated by EOF don't work either (even though they look right).  

If I model my attribute as an integer then the queries work okay and the update statements issued by EOF work too.  By I don't like having an Integer in my accessor methods in my EO for a boolean column.  I want to use boolean.

Looking at the screenshot below, does this look like the boolean prototype is setting the fields correctly for a boolean column in OpenBase? Anybody wants to guess?  Anybody using booleans in OpenBase and ERPrototypes?


<Picture 1.png>

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H_______________________________________________
Wonder-disc mailing list
email@hidden
https://lists.sourceforge.net/lists/listinfo/wonder-disc

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H_______________________________________________
Wonder-disc mailing list
email@hidden
https://lists.sourceforge.net/lists/listinfo/wonder-disc

------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H_______________________________________________
Wonder-disc mailing list
email@hidden
https://lists.sourceforge.net/lists/listinfo/wonder-disc

 _______________________________________________
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
References: 
 >OpenBase / boolean / ERPrototypes (From: "Ricardo J. Parada" <email@hidden>)
 >Re: [Wonder-disc] OpenBase / boolean / ERPrototypes (From: Mike Schrag <email@hidden>)
 >Re: [Wonder-disc] OpenBase / boolean / ERPrototypes (From: "Ricardo J. Parada" <email@hidden>)

  • Prev by Date: Re: escaping in HTML
  • Next by Date: Re: WOLips - Entity Modeler - reverse engineer from multiple scheme/user?
  • Previous by thread: Re: [Wonder-disc] OpenBase / boolean / ERPrototypes
  • Next by thread: Re: [Wonder-disc] OpenBase / boolean / ERPrototypes
  • Index(es):
    • Date
    • Thread