Using WO 5.4.3
Project Wonder - HEAD as of Feb 3
Setting and console out below:
I'm attempting to enable connection pooling in one of my groups applications.
We are successfully using OSC pooling. We need other connections for (Oracle)
stored procedures and I would prefer to use connections we already have from
the pool, if we can turn that feature on.
I have set the properties according to notes I have seen on this list and
documents on the wiki.
I have ensured that every editing context we request uses the
ERXEC.newEditingContext method, but I am checking yet again.
My trouble is an exception thrown when attempting to use the checked-out
connection. I have traced this to a call on a null Connection object. When I
have seen this before, it was because the EC was generated by "new
EOEditingContext()".
Does anyone have another tip to find this "disconnect"?
TNK
Property settings:
# Implement database connection pooling
# Testing ERXObjectStoreCoordinatorPool at 3 connections
er.extensions.ERXObjectStoreCoordinatorPool.maxCoordinators = 3
er.extensions.ERXJDBCAdaptor.className=er.extensions.jdbc.ERXJDBCAdaptor
er.extensions.ERXJDBCAdaptor.useConnectionBroker = true
IndigoDB.DBMinConnections=1
IndigoDB.DBMaxConnections=5
dbMinConnectionsGLOBAL=1
dbMaxConnectionsGLOBAL=5
console output:
68830 [To /0:0:0:0:0:0:0:1%0:60086] DEBUG NSLog - === Begin Internal
Transaction
68830 [To /0:0:0:0:0:0:0:1%0:60086] DEBUG NSLog - evaluateExpression:
<com.webobjects.jdbcadaptor.OraclePlugIn$OracleExpression: "SELECT
Product_SEQ.NEXTVAL FROM DUAL" withBindings: >
68830 [To /0:0:0:0:0:0:0:1%0:60086] INFO er.transaction.adaptor.Exceptions -
Database Exception occured: java.lang.NullPointerException
68834 [To /0:0:0:0:0:0:0:1%0:60086] DEBUG NSLog - === Rollback Internal
Transaction
E. 2011/02/03 13:51:00. null
java.lang.NullPointerException
at
com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:268)
at
com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337)
at
com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296)
at
er.extensions.jdbc.ERXJDBCAdaptor$Channel.evaluateExpression(ERXJDBCAdaptor.java:236)
at
com.webobjects.jdbcadaptor.JDBCChannel._fetchRowsForSQLExpressionAndAttributes(JDBCChannel.java:562)
at
com.webobjects.jdbcadaptor.OraclePlugIn._newPrimaryKey(OraclePlugIn.java:472)
at
com.webobjects.jdbcadaptor.OraclePlugIn.newPrimaryKeys(OraclePlugIn.java:438)
at
er.extensions.jdbc.ERXJDBCAdaptor$Channel.primaryKeysForNewRowsWithEntity(ERXJDBCAdaptor.java:214)
at
com.webobjects.eoaccess.EODatabaseContext._batchNewPrimaryKeysWithEntity(EODatabaseContext.java:5728)
at
com.webobjects.eoaccess.EODatabaseContext.prepareForSaveWithCoordinator(EODatabaseContext.java:5711)
at
com.webobjects.eocontrol.EOObjectStoreCoordinator.saveChangesInEditingContext(EOObjectStoreCoordinator.java:370)
at
com.webobjects.eocontrol.EOEditingContext.saveChanges(EOEditingContext.java:3192)
at er.extensions.eof.ERXEC._saveChanges(ERXEC.java:1085)
at er.extensions.eof.ERXEC.saveChanges(ERXEC.java:1007)
Tim Kliewer
WWBI Software Engineering
Apple, Sacramento Operations
MS: 204-50 Tel: (916) 399-5101
2911 Laguna Blvd Cell: (916) 717-8748
Elk Grove, CA 95758 E-mail: [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:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
