Hi All, I have no solution to this issue yet. Let me give some more details.
The sequence does exist. It works fine when the connection broker is not enabled. In either case, there are several select statements that work fine, as expected, before a new EO needs to be created. Its only when the connection broker is enabled that a null connection is used when performing the SQL: SELECT Product_SEQ.NEXTVAL FROM DUAL. My example only shows it for Product, but I have noticed it with other Entities. I suspect this is an ORACLE specific WO code issue when getting new primary keys. I have implemented another connectionPooling solution using the stock ProjectWonder connectionBroker, but I would prefer getting this working properly! I will continue to investigate on my own as time permits, but if someone has a solution, I'll gladly learn from their knowledge! TNK On Feb 3, 2011, at 3:06 PM, Tim Kliewer wrote: > 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/tkliewer%40apple.com > > This email sent to [email protected] 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]
