It looks like a restart of FBExec did help. Quadruple weird: I thought as soon one connects successfully to a particular database, all the subsequent communication is managed by the separate FronBase processes (which I did restart multiple times without any gain), and FBExec has nothing to do with that, but well -- far as it works, I do not complain :)
All the best, OC On 22. 5. 2016, at 15:41, OC <[email protected]> wrote: > Hello there, > > my application runs well up to one fetch; I have added these logs > > === > println "AAAAAAAAAA fetching ${self.simpleName} $fs..." > found=editingContext.objectsWithFetchSpecification(fs) > println "... fetched $found.count objects: $found" > === > > and am getting this output: > > === > AAAAAAAAAA fetching DBRecord <class > com.webobjects.eocontrol.EOFetchSpecification(entityName=DBRecord, > qualifier=(uid < 100000), > isDeep=true, usesDistinct=false, > sortOrdering=null, > hints=null, > _prefetchingRelationshipKeyPaths = null)>... > 15:16:34.921 DEBUG === Begin Internal Transaction //log:NSLog [main] > 15:16:34.921 DEBUG evaluateExpression: > <com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression: "SELECT > t0."C_CREATION_DATE", t0."C_CREATOR_ID", t0."C_DF_CONTENT_DATA", > t0."C_IMPORT_ID", t0."C_UID" FROM "T_RECORD" t0 WHERE t0."C_UID" < 100000" > withBindings: > //log:NSLog [main] > === > > Now, the obvious reasons I have excluded: > > (a) this is by far not the first fetch; up to this point, a number of them > was made (with different entities/tables) and they worked perfectly > (b) if I copy/paste the SQL verbatim to FBManager, I get the result (which is > an empty rowset, which is the proper result) in about 300 us > > Nevertheless, although (a) and (b) look like it is not possible, still, it > _is_ blocked inside the communication with the server: if I go to FBManager > and stop the database, the blocking ends and my application immediately > reports > > === > 15:37:24.253 INFO Database Exception occured: Database - SBERDAT2 - is not > runningat com.frontbase.jdbc.FBJConnection.createConnection(Unknown Source) > at com.frontbase.jdbc.FBJConnection.reconnect(Unknown Source) > at com.frontbase.jdbc.FBJConnection.fbX(Unknown Source) > at com.frontbase.jdbc.FBJConnection.execute(Unknown Source) > ... > === > > I would be very grateful for any advice how to find and isolate the problem > -- myself, I am outta ideas :( > > Thanks and all the best, > OC > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/ocs%40ocs.cz > > This email sent to [email protected] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
