| While trying to find out why some data did not get saved. I discovered in Debug mode that all kinds of fetches did return an exception, which in turn caused the ERXEC to not do it's thing and save the data in it's EOEditingContext. Removing the fetches that created the Exceptions in a RR-loop resulted in saving the data.
But I do not understand where these Exceptions come from.
Two Examples:
Here I am fetching some program settings, and the program creates an Exception (I assume) at nl.netsense.theater._ProgramSetting.isTest(_ProgramSetting.java:48). This is just an Integer, which is allowed to be empty (0 in the EOModeler setup).
NSMutableDictionary currentbindings = new NSMutableDictionary(); currentbindings.setObjectForKey( today,"currentdate");
// Get the programsettings: for use of (eg) VAT, name of theater, etc. NSDictionary settingsbindings = currentbindings; NSArray settingsList = EOUtilities.objectsWithFetchSpecificationAndBindings(myEc(),"ProgramSetting", "currentSetting", settingsbindings); setCurrentProgramSetting( (ProgramSetting)settingsList.objectAtIndex(0));
Why would ERXEC create an Eception on something like this?
Mar 09 22:39:37 kassa[60036] DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT t0.settings_test, t0.settings_epayment_timeout, t0.settings_id, t0.settings_invoice_external_id, t0.settings_order_check_url, t0.settings_organisation_name, t0.settings_printprogram_path, t0.settings_programhref, t0.settings_program_path, t0.settings_region, t0.settings_reservation_mail_from, t0.settings_reservation_mail_to_2, t0.settings_reservation_mail_to_1, t0.settings_reservation_tel, t0.settings_scriptprogram_path, t0.settings_startdate, t0.settings_stopdate, t0.settings_temp_path, t0.settings_ticket_check_url, t0.settings_ticket_external_id FROM programsettings t0 WHERE t0.settings_id = ?::int4" withBindings: 1:1(settingsId)> Mar 09 22:39:37 kassa[60036] DEBUG er.transaction.adaptor.FaultFiring - databaseContextDidSelectObjects <class com.webobjects.eocontrol.EOFetchSpecification(entityName=ProgramSetting,
qualifier=((settingsId = 1)),
isDeep=true, usesDistinct=false,
sortOrdering=null,
hints=null,
_prefetchingRelationshipKeyPaths = null)>
Exception
at er.extensions.eof.ERXDatabaseContextDelegate.databaseContextDidSelectObjects(ERXDatabaseContextDelegate.java:343)
... skipped 4 stack elements
at com.webobjects.foundation._NSDelegate._perform(_NSDelegate.java:223)
at com.webobjects.foundation._NSDelegate.perform(_NSDelegate.java:167)
... skipped 6 stack elements
at com.webobjects.eoaccess.EOAccessFaultHandler.completeInitializationOfObject(EOAccessFaultHandler.java:89)
at com.webobjects.eocontrol.EOCustomObject.willRead(EOCustomObject.java:1172)
at nl.netsense.theater._ProgramSetting.willRead(_ProgramSetting.java:50001)
at nl.netsense.theater.ProgramSetting.willRead(ProgramSetting.java:50001)
at com.webobjects.eocontrol._EOMutableKnownKeyDictionary$Initializer$_GenericRecordBinding.valueInObject(_EOMutableKnownKeyDictionary.java:570)
at com.webobjects.eocontrol.EOCustomObject.storedValueForKey(EOCustomObject.java:1634)
at nl.netsense.theater._ProgramSetting.storedValueForKey(_ProgramSetting.java:50001)
at nl.netsense.theater.ProgramSetting.storedValueForKey(ProgramSetting.java:50001)
at nl.netsense.theater._ProgramSetting.isTest(_ProgramSetting.java:48)
at nl.netsense.theater.ProgramSetting.isTest(ProgramSetting.java:50001)
... skipped 22 stack elements
at com.webobjects.appserver.WOAssociation.booleanValueInComponent(WOAssociation.java:276)
... skipped 26 stack elements
at nl.netsense.kassa.Application.dispatchRequestImmediately(Application.java:50001)
... skipped 1 stack elements
at nl.netsense.kassa.Application.dispatchRequest(Application.java:50001)
... skipped 3 stack elements
Second example:
I am fetching a bunch of tickets, based on the premisse that the person behind the cashregister is the one that sold the ticket, and that it is a ticket that has no creditcard affiiation:
NSMutableArray qualArray = new NSMutableArray(); qualArray.addObject( new EOKeyValueQualifier("ticketPaydeskSessionId", EOQualifier.QualifierOperatorEqual, currentPayDeskSession().paydeskSessionId() ) ); qualArray.addObject( new EOKeyValueQualifier("lineItem.order.cardtype", EOQualifier.QualifierOperatorEqual, null ) ); Object orderings[]={ EOSortOrdering.sortOrderingWithKey("ticketDateSold", EOSortOrdering.CompareAscending) }; EOQualifier andQualifier = new EOAndQualifier( qualArray ); EOFetchSpecification spec = new EOFetchSpecification("TicketSold", andQualifier, new NSArray(orderings) ); spec.setRefreshesRefetchedObjects(true); printedTicketList = ec.objectsWithFetchSpecification(spec); return printedTicketList;
This also results in a Exception.
Mar 09 22:38:27 kassa[60036] DEBUG NSLog - evaluateExpression: <com.webobjects.jdbcadaptor.PostgresqlExpression: "SELECT t0.ticket_lineitem_id, t0.ticket_adressen_id, t0.ticket_amount1, t0.ticket_amount2, t0.ticket_amount3, t0.ticket_date_printed, t0.ticket_date_sold, t0.ticket_employee_id, t0.ticket_external_id, t0.ticket_hash, t0.ticket_id, t0.ticket_lineitem_uid, t0.ticket_no_of_tickets1, t0.ticket_no_of_tickets2, t0.ticket_order_id, t0.ticket_paydesksession_id, t0.ticket_perf_id, t0.ticket_productid, t0.ticket_remarks, t0.ticket_showattendant_id FROM ticketssold t0 INNER JOIN lineitem T1 ON t0.ticket_lineitem_uid = T1.lineitem_uid INNER JOIN ORDERS T2 ON T1.order_id = T2.order_id WHERE (t0.ticket_paydesksession_id = ?::int4 AND T2.cardtype is NULL) ORDER BY t0.ticket_date_sold ASC" withBindings: 1:770(ticketPaydeskSessionId)> Mar 09 22:38:27 kassa[60036] DEBUG er.transaction.adaptor.FaultFiring - databaseContextDidSelectObjects <class com.webobjects.eocontrol.EOFetchSpecification(entityName=TicketSold, qualifier=((ticketPaydeskSessionId = 770) and (lineItem.order.cardtype = null)), isDeep=true, usesDistinct=false, sortOrdering=(<class com.webobjects.eocontrol.EOSortOrdering(ticketDateSold compareAscending)>), hints=null, _prefetchingRelationshipKeyPaths = null)> Exception at er.extensions.eof.ERXDatabaseContextDelegate.databaseContextDidSelectObjects(ERXDatabaseContextDelegate.java:343) ... skipped 4 stack elements at com.webobjects.foundation._NSDelegate._perform(_NSDelegate.java:223) at com.webobjects.foundation._NSDelegate.perform(_NSDelegate.java:167) ... skipped 5 stack elements 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:1211) at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4444) at nl.netsense.kassa.Session$$M$b532ffda.printedTicketList(Session.java:819) at nl.netsense.kassa.Session$$A$b532ffda.printedTicketList(<generated>:Unknown) at nl.netsense.kassa.Session.printedTicketList(Session.java:820) ... skipped 41 stack elements at nl.netsense.kassa.Application.dispatchRequestImmediately(Application.java:50001) ... skipped 1 stack elements at nl.netsense.kassa.Application.dispatchRequest(Application.java:50001) ... skipped 3 stack elements
|