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
Tim Kliewer
WWBI Software Engineering
Apple, Sacramento Operations
MS: 204-50 Tel: (916) 399-5101
2911 Laguna Blvd Cell: (916) 717-8748