• 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: what am i doing wrong with this qualifier
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: what am i doing wrong with this qualifier


  • Subject: Re: what am i doing wrong with this qualifier
  • From: Theodore Petrosky <email@hidden>
  • Date: Wed, 26 Jan 2011 03:47:33 -0800 (PST)

So I stopped guessing (or maybe bad guessing). Here is what I saw:

1. from my nslog:

qualifier=(invoiceBookedDate =
> (com.webobjects.foundation.NSTimestamp)'2010-12-06 00:00:00
> Etc/GMT'),

I know this date is good. I was querying the postgresql db from psql with a select using that datestamp and I got rows of data. So i looked at the postgresql logs and I notice that the actual date passing into the query is:

'2010-12-05 00:00:00 Etc/GMT'

WT_???

So i didn't change anything but selected the next day in my app (in this case '2010-07-01..' and voila it worked as expected (I got good data and no error). And the date passed in the postgresql logs said the 6th.

so why was I doing this:
theDate = theDate.timestampByAddingGregorianUnits(0, 0, 0, -5, 0, 0);

I did that because I kept seeing:

'2010-12-06 05:00:00 Etc/GMT'   in my logs and I knew I was only interested in the date (without timestamp) but I never figured out how to only pass around dates without timestamps and everything was working. I was subtracting the 5 hours and I didn't need to. (and it was biting me in the backend.)

Postgresql supports dates without timestamp, I wish I knew how to do this in webobject java. (But still call them dates so I can do date math.)

So the error has nothing to do with my WOD. I am picking up the JasperReports example from the WOWODC 2010 videos. I guess the example has problems with a query returning no rows.

Now if I can only figure out how to pass an array from a previous query to JasperReports I would be happier.

I have to go back to re-reading this plethora of documentation.

Thanks for your timely help.

Ted



--- On Tue, 1/25/11, Chuck Hill <email@hidden> wrote:

> From: Chuck Hill <email@hidden>
> Subject: Re: what am i doing wrong with this qualifier
> To: "Theodore Petrosky" <email@hidden>
> Cc: email@hidden
> Date: Tuesday, January 25, 2011, 6:35 PM
> Stop guessing.  Think. 
> :-)
>
> > Jan 25 18:15:09 TheWorkTracker[63447] INFO 
> er.extensions.components._private.ERXWOString  -
> Exception while formatting
> > NumberFormatException: Infinite or NaN
>
> Read that.  Again.  Again.
>
> ... ERXWOString ...
>
> This error is coming from a WOString binding in your wod
> file.
>
>
> Chuck
>
>
> On Jan 25, 2011, at 3:18 PM, Theodore Petrosky wrote:
>
> > I just quit the app and relaunched:
> > Here is the full method:
> >
> > public static Callable<File>
> createSingleDateReportTask(NSTimestamp theDate) {
> >     // SortOrderings
> >     // Sort by studio name alphabetical
> sort
> >     //ERXSortOrderings sortOrderings =
> User.LAST_NAME.ascs();
> >
> >     ERXSortOrderings sortOrderings =
> Invoice.INVOICE_BOOKED_DATE.ascs();
> >        
> >     theDate =
> theDate.timestampByAddingGregorianUnits(0, 0, 0, -5, 0, 0);
> >        
> >    
> //Invoice.INVOICE_BOOKED_DATE.is(theDate)
> >     EOQualifier qualifier =
> ERXQ.is("invoiceBookedDate", theDate);
> >     //EOQualifier qualifier =
> null;       
>        
> >        
> >    
> ERXFetchSpecification<Invoice> fs = new
> ERXFetchSpecification<Invoice>(Invoice.ENTITY_NAME,
> qualifier, sortOrderings);
> >        
> >     NSLog.out.appendln("fs = " + fs);
> >        
> >     String reportDescription = "A
> report on Invoices booked on: " + theDate;
> >        
> >    
> NSLog.out.appendln("reportDescription = " +
> reportDescription);
> >     HashMap<String, Object>
> parameters = new HashMap<String, Object>();
> >     parameters.put("reportDescription",
> reportDescription);
> >     //parameters.put("userName",
> "WOWODC Demo");
> >        
> >     // Builder pattern for constructor
> since.
> >     ERJRFetchSpecificationReportTask
> reportTask = new ERJRFetchSpecificationReportTask(fs,
> "BillingToday.jasper", parameters);
> >        
> >     NSLog.out.appendln("reportTask " +
> reportTask);
> >        
> >     return reportTask;
> > }
> >
> > here is the error:
> > if qualifier is null then there is no error and I get
> my report.
> >
> > Jan 25 18:15:00 TheWorkTracker[63447] DEBUG
> NSLog  - Waiting for requests...
> > Jan 25 18:15:09 TheWorkTracker[63447] INFO 
> NSLog  - printReport singleDateCondition called
> > Jan 25 18:15:09 TheWorkTracker[63447] INFO 
> NSLog  - fs = <class
> er.extensions.eof.ERXFetchSpecification(entityName=Invoice,
> > qualifier=(invoiceBookedDate =
> (com.webobjects.foundation.NSTimestamp)'2010-12-06 00:00:00
> Etc/GMT'),
> > isDeep=true, usesDistinct=false,
> > sortOrdering=(<class
> er.extensions.eof.ERXSortOrdering(invoiceBookedDate
> compareAscending)>),
> > hints=null,
> > _prefetchingRelationshipKeyPaths = null)>
> > Jan 25 18:15:09 TheWorkTracker[63447] INFO 
> NSLog  - reportDescription = A report on Invoices
> booked on: 2010-12-06 00:00:00 Etc/GMT
> > Jan 25 18:15:09 TheWorkTracker[63447] INFO 
> NSLog  - reportTask
> er.jasperreports.ERJRFetchSpecificationReportTask@54aa39d6
> > Jan 25 18:15:09 TheWorkTracker[63447] INFO 
> er.jrexample.controllers.AbstractPageController  -
> Controller named
> 'er.jrexample.controllers.FileTaskDownloadController' just
> instantiated in page named
> 'com.eltek.components.TWTBilling_DailyReportComponent'
> > Jan 25 18:15:09 TheWorkTracker[63447] INFO 
> NSLog  - FileTaskDownloadController called
> > Jan 25 18:15:09 TheWorkTracker[63447] INFO 
> NSLog  - nextPageController called = Billing List
> > Jan 25 18:15:09 TheWorkTracker[63447] INFO 
> er.extensions.components._private.ERXWOString  -
> Exception while formatting
> > NumberFormatException: Infinite or NaN
> >  at
> java.math.BigDecimal.<init>(BigDecimal.java:797)
> >  at
> com.webobjects.foundation.NSNumberFormatter.stringForObjectValue(NSNumberFormatter.java:1026)
> >  at
> com.webobjects.foundation.NSNumberFormatter.format(NSNumberFormatter.java:1654)
> >  at
> er.extensions.formatters.ERXNumberFormatter.format(ERXNumberFormatter.java:250)
> >  at java.text.Format.format(Format.java:140)
> >  ... skipped 31 stack elements
> > Jan 25 18:15:11 TheWorkTracker[63447] INFO 
> er.extensions.components._private.ERXWOString  -
> Exception while formatting
> > NumberFormatException: Infinite or NaN
> >  at
> java.math.BigDecimal.<init>(BigDecimal.java:797)
> >  at
> com.webobjects.foundation.NSNumberFormatter.stringForObjectValue(NSNumberFormatter.java:1026)
> >  at
> com.webobjects.foundation.NSNumberFormatter.format(NSNumberFormatter.java:1654)
> >  at
> er.extensions.formatters.ERXNumberFormatter.format(ERXNumberFormatter.java:250)
> >  at java.text.Format.format(Format.java:140)
> >     ... skipped 8 stack elements
> >  at
> er.ajax.AjaxUpdateContainer.handleRequest(AjaxUpdateContainer.java:263)
> >     ... skipped 16 stack elements
> >  at
> er.ajax.AjaxRequestHandler.handleRequest(AjaxRequestHandler.java:17)
> >  ... skipped 6 stack elements
> > Jan 25 18:15:11 TheWorkTracker[63447] INFO 
> er.extensions.components._private.ERXWOString  -
> Exception while formatting
> > NumberFormatException: Infinite or NaN
> >  at
> java.math.BigDecimal.<init>(BigDecimal.java:797)
> >  at
> com.webobjects.foundation.NSNumberFormatter.stringForObjectValue(NSNumberFormatter.java:1026)
> >  at
> com.webobjects.foundation.NSNumberFormatter.format(NSNumberFormatter.java:1654)
> >  at
> er.extensions.formatters.ERXNumberFormatter.format(ERXNumberFormatter.java:250)
> >  at java.text.Format.format(Format.java:140)
> >     ... skipped 8 stack elements
> >  at
> er.ajax.AjaxUpdateContainer.handleRequest(AjaxUpdateContainer.java:263)
> >     ... skipped 16 stack elements
> >  at
> er.ajax.AjaxRequestHandler.handleRequest(AjaxRequestHandler.java:17)
> >  ... skipped 6 stack elements
> > nextPage action fired
> >
> >
> >
>
> --
> Chuck Hill         
>    Senior Consultant / VP Development
>
> Practical WebObjects - for developers who want to increase
> their overall knowledge of WebObjects or who are trying to
> solve specific problems.   
> http://www.global-village.net/products/practical_webobjects
>
>
>
>
>
>
>
>



 _______________________________________________
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

  • Follow-Ups:
    • Re: what am i doing wrong with this qualifier
      • From: Ramsey Gurley <email@hidden>
    • Re: what am i doing wrong with this qualifier
      • From: Patrick Middleton <email@hidden>
References: 
 >Re: what am i doing wrong with this qualifier (From: Chuck Hill <email@hidden>)

  • Prev by Date: Re: java.lang.NoClassDefFoundError
  • Next by Date: Re: what am i doing wrong with this qualifier
  • Previous by thread: Re: what am i doing wrong with this qualifier
  • Next by thread: Re: what am i doing wrong with this qualifier
  • Index(es):
    • Date
    • Thread