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

Duplicate Database accesses...


  • Subject: Duplicate Database accesses...
  • From: "Les Vogel" <email@hidden>
  • Date: Sun, 25 Nov 2007 13:18:27 -1000

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
 _______________________________________________
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

  • Follow-Ups:
    • Re: Duplicate Database accesses...
      • From: Mike Schrag <email@hidden>
    • Re: Duplicate Database accesses...
      • From: "Les Vogel" <email@hidden>
  • Prev by Date: Re: Webobjects-dev Digest, Vol 4, Issue 866
  • Next by Date: Re: WebObjects Survey: Marketplace
  • Previous by thread: Derby Database front end
  • Next by thread: Re: Duplicate Database accesses...
  • Index(es):
    • Date
    • Thread