system is used for scheduled jobs or services that are not initiated by a user.
Vince Clark sent the following on 8/4/2009 7:59 AM: > Was able to track down the query causing the deadlock. Apparently has nothing > to do with quickShipEntireOrder: > > SELECT CURRENT_PASSWORD, PASSWORD_HINT, IS_SYSTEM, ENABLED, HAS_LOGGED_OUT, > REQUIRE_PASSWORD_CHANGE, LAST_CURRENCY_UOM, LAST_LOCALE, LAST_TIME_ZONE, > DISABLED_DATE_TIME, SUCCESSIVE_FAILED_LOGINS, EXTERNAL_AUTH_ID, USER_LDAP_DN, > LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, > PARTY_ID FROM dbo.USER_LOGIN WHERE USER_LOGIN_ID= > > When I schedule the job I am logged in as myself. Also, I am not doing > anything in my simple method to specify a logged in user. I've seen other > instances in the code where system user is explicitly set as the "logged in > user". Should I be doing this? > > > > Vince Clark > www.globalera.com > vcl...@globalera.com > (303) 493-6723 office > (303) 523-4843 cell > > > ----- Original Message ----- > From: "BJ Freeman" <bjf...@free-man.net> > To: user@ofbiz.apache.org > Sent: Monday, August 3, 2009 8:35:44 PM GMT -07:00 US/Canada Mountain > Subject: Re: database deadlocks > > goes to show how far behind I am. > thanks for the update > > > Scott Gray sent the following on 8/3/2009 7:25 PM: >> They aren't temporary stored procedures on MS unless you're talking 10 >> years ago: http://msdn.microsoft.com/en-us/library/aa197533(SQL.80).aspx >> And Postgresql makes no mention of functions: >> http://www.postgresql.org/docs/8.1/interactive/sql-prepare.html >> In both cases they just compile and cache the statement which is what >> people call prepared statements. >> >> Regards >> Scott >> >> On 4/08/2009, at 2:03 PM, BJ Freeman wrote: >> >>> I meant storeproceedure that are temporary from MS side anyway. >>> you may mean the prepared statements that create stored proceedures >>> for MS. >>> they are Functions for postgresql. >>> >>> Scott Gray sent the following on 8/3/2009 4:18 PM: >>>> I think you meant prepared statements rather than stored procedures >>>> there. >>>> >>>> Regards >>>> Scott >>>> >>>> On 4/08/2009, at 10:59 AM, BJ Freeman wrote: >>>> >>>>> since ofbiz creates and send a Stored procedure see if it creating more >>>>> than one for the same operation. >>> -- >>> BJ Freeman >>> http://www.businessesnetwork.com/automation >>> http://bjfreeman.elance.com >>> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro >>> >>> Systems Integrator. >>> > -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro Systems Integrator.
