... or for any operation that the system does automatically based on a
user's actions or some other trigger, especially when you would not
want to allow the user to do that operation manually or have control
over that operation (ie have permissions related to it).
-David
On Aug 4, 2009, at 11:16 AM, BJ Freeman wrote:
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.
