• 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: Duplicate Database accesses...
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Duplicate Database accesses...

  • Subject: Re: Duplicate Database accesses...
  • From: "Les Vogel" <email@hidden>
  • Date: Sun, 25 Nov 2007 14:46:12 -1000
Well, I still get duplicates, but I no longer crash when I added:

er.extensions.ERXApplication
.useEditingContextUnlocker=true
er.extensions.ERXEC.defaultAutomaticLockUnlock=true
er.extensions.ERXEC.useSharedEditingContext=false
er.extensions.ERXEC.defaultCoalesceAutoLocks=true

to my Properties file.  I'd still like an idea about the duplicates.

Thanks,

Les


On 11/25/07, Les Vogel <email@hidden> wrote:
I've got ERExtensions, ERJars, ERPrototypes, FrontBasePlugin installed.  I'm calling these two lines from the Application constructor after super():

        eContext = ERXEC.newEditingContext(false);
        customers = Customer.fetchAllCustomers(eContext);

I've changed my _Entity template to use ERXGenericRecord as suggested in http://wiki.objectstyle.org/confluence/display/WONDER/Integrate+Wonder+Into+an+Existing+Application

The database seems to be invoked twice.  I'm using 5.4 on leopard.

Two questions:

1. Why am I getting duplicate DBMS actions?
2. Bonus if you suggest why I'm crashing.

Thanks,

Les


Nov 25 13:08:08 SalesRotor[54797] (ERXModelGroup.java:110) WARN  er.extensions.ERXModelGroup   - Clearing previous class descriptions
Nov 25 13:08:08 SalesRotor[54797] (ERXModelGroup.java:725) WARN  er.extensions.ERXModelGroup  - The EOModel 'erprototypes' does not have a connection dictionary, providing an empty one
Nov 25 13:08:09 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  - Using JDBCPlugIn 'com.webobjects.jdbcadaptor.FrontbasePlugIn' for JDBCAdaptor@3483042
Nov 25 13:08:09 SalesRotor[54797] (ERXNSLogLog4jBridge.java :44) DEBUG NSLog  - Didn't find any JNDI data source.
Nov 25 13:08:09 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  - Using JDBCPlugIn 'com.webobjects.jdbcadaptor.FrontbasePlugIn' for JDBCAdaptor@16391045
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver: driver[className=com.frontbase.jdbc.FBJDriver,com.frontbase.jdbc.FBJDriver@ae8542]
Nov 25 13:08:09 SalesRotor[54797] ( ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  connecting with dictionary: {password = "<password deleted for log>"; username = "SalesRotor"; URL = "" }
DriverManager.getConnection("jdbc:frontbase://127.0.0.1/SalesRotor/isolation=read_committed/locking=optimistic")
    trying driver[className=com.frontbase.jdbc.FBJDriver,com.frontbase.jdbc.FBJDriver@ae8542 ]
getConnection returning driver[className=com.frontbase.jdbc.FBJDriver,com.frontbase.jdbc.FBJDriver@ae8542]
Nov 25 13:08:09 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  - fetching JDBC Info with JDBCContext@2591303
Nov 25 13:08:09 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  - Didn't find any JNDI data source.
Nov 25 13:08:09 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  connecting with dictionary: {password = "<password deleted for log>"; username = "SalesRotor"; URL = "" }
DriverManager.getConnection("jdbc:frontbase://127.0.0.1/SalesRotor/isolation=read_committed/locking=optimistic")
    trying driver[className=com.frontbase.jdbc.FBJDriver,com.frontbase.jdbc.FBJDriver@ae8542 ]
getConnection returning driver[className=com.frontbase.jdbc.FBJDriver,com.frontbase.jdbc.FBJDriver@ae8542]
Nov 25 13:08:09 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  === Begin Internal Transaction
Nov 25 13:08:09 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression: "SELECT t0."customerID", t0."customerName", t0."customerShortName", t0."largeImage", t0."lastUpdated" FROM "Customer" t0" withBindings: >
Nov 25 13:08:09 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  - 1 row(s) processed
Nov 25 13:08:09 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  === Commit Internal Transaction
Nov 25 13:08:10 SalesRotor[54797] ( ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  === Begin Internal Transaction
Nov 25 13:08:10 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression: "SELECT DISTINCT t0."customerID", t0."customerName", t0."customerShortName", t0."largeImage", t0."lastUpdated" FROM "Customer" t0" withBindings: >
Nov 25 13:08:10 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  - 1 row(s) processed
Nov 25 13:08:10 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  === Commit Internal Transaction
Nov 25 13:08:10 SalesRotor[54797] ( ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  === Begin Internal Transaction
Nov 25 13:08:10 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression: "SELECT t0."accountAccess", t0."cellPhone", t0."customerID", t0."lastUpdated", t0."line", t0."manager", t0."nameFirst", t0."nameLast", t0."p1Line", t0."p1RPosition", t0."p1Status", t0."p2Line", t0."p2RPosition", t0."p2Status", t0."p3Line", t0."p3RPosition", t0."p3Status", t0."p4Line", t0."p4RPosition", t0."pagerEmail", t0."passphrase", t0."rotorPosition", t0."status", t0."timeCreated", t0."userid" FROM "Users" t0" withBindings: >
Nov 25 13:08:10 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  - 63 row(s) processed
Nov 25 13:08:10 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  === Commit Internal Transaction
Nov 25 13:08:10 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  === Begin Internal Transaction
Nov 25 13:08:10 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  evaluateExpression: <com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression: "SELECT DISTINCT t0."accountAccess", t0."cellPhone", t0."customerID", t0."lastUpdated", t0."line", t0."manager", t0."nameFirst", t0."nameLast", t0."p1Line", t0."p1RPosition", t0."p1Status", t0."p2Line", t0."p2RPosition", t0."p2Status", t0."p3Line", t0."p3RPosition", t0."p3Status", t0."p4Line", t0."p4RPosition", t0."pagerEmail", t0."passphrase", t0."rotorPosition", t0."status", t0."timeCreated", t0."userid" FROM "Users" t0" withBindings: >
Nov 25 13:08:10 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  - 63 row(s) processed
Nov 25 13:08:10 SalesRotor[54797] (ERXNSLogLog4jBridge.java:44) DEBUG NSLog  -  === Commit Internal Transaction
Nov 25 13:08:10 SalesRotor[54797] (ERXNSLogLog4jBridge.java:41) WARN  NSLog  - A fatal exception occurred: null
[2007-11-25 23:8:10 HST] <main> java.lang.IllegalMonitorStateException
    at java.util.concurrent.locks.ReentrantReadWriteLock$Sync.tryRelease (ReentrantReadWriteLock.java:259)
    at java.util.concurrent.locks.AbstractQueuedSynchronizer.release(AbstractQueuedSynchronizer.java:1137)
    at java.util.concurrent.locks.ReentrantReadWriteLock$WriteLock.unlock ( ReentrantReadWriteLock.java:821)
    at com.webobjects.eocontrol.EOSharedEditingContext.unlock(EOSharedEditingContext.java:787)
    at com.webobjects.eocontrol.EOEditingContext.unlockObjectStore(EOEditingContext.java :4670)
    at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4057)
    at er.extensions.ERXEC.objectsWithFetchSpecification(ERXEC.java:1068)
    at com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification (EOEditingContext.java:4428)
    at com.pacifictechnologies._Customer.fetchCustomers(_Customer.java:243)
    at com.pacifictechnologies._Customer.fetchAllCustomers(_Customer.java:237)
    at com.pacifictechnologies._Customer.fetchAllCustomers (_Customer.java:233)
    at Application.<init>(Application.java:42)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance ( NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
    at java.lang.Class.newInstance0(Class.java:350)
    at java.lang.Class.newInstance(Class.java:303)
    at com.webobjects.appserver.WOApplication.main(WOApplication.java:546)
    at er.extensions.ERXApplication.main (ERXApplication.java:362)
    at Application.main(Application.java:22)

--
Les Vogel
808 870-0418



--
Les Vogel
808 870-0418 
 _______________________________________________
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
References: 
 >Duplicate Database accesses... (From: "Les Vogel" <email@hidden>)

  • Prev by Date: Re: Strange WOLips importing error (was Re: Webobjects-dev Digest, Vol 4, Issue 866)
  • Next by Date: Re: NSTimestampFormatter and WOString dateformat
  • Previous by thread: Duplicate Database accesses...
  • Next by thread: Re: Duplicate Database accesses...
  • Index(es):
    • Date
    • Thread