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
|