Re: new EOObjectStoreCoordinator and closing database connection afterwards
Re: new EOObjectStoreCoordinator and closing database connection afterwards
- Subject: Re: new EOObjectStoreCoordinator and closing database connection afterwards
- From: Chuck Hill <email@hidden>
- Date: Wed, 2 Jul 2008 16:50:43 -0700
On Jul 1, 2008, at 2:41 PM, Klaus Berkling wrote:
Hi all.
In my application I'm trying to use independent access layer stacks
to open multiple database connections to the database.
I use this code:
EOObjectStoreCoordinator parentObjectStore = new
EOObjectStoreCoordinator();
EOEditingContext editingContext = new
EOEditingContext(parentObjectStore);
setDefaultEditingContext(editingContext);
This looks like it's working in that it opens two new connection to
the database when I start a new session. As expected.
If it is opening two, I'd expect one to be to get the JDBC2 Info and
the other for EOF to use to fetch data. As Mike noted earlier,
getting EOF to close the JDBC 2 Info connection is tricky. Can you
get the DB to log what is sent over each connection? That should
indicate if I am right or not.
Chuck
When I'm terminate the session I use this code to close the
connection to the database:
'editingContext' is the session 'defaultEditingContext()'
EOObjectStoreCoordinator parentObjectStore =
(EOObjectStoreCoordinator)(editingContext.parentObjectStore());
NSArray databaseContexts =
parentObjectStore.cooperatingObjectStores();
int contextCount = databaseContexts.count();
for (int i = 0; i < contextCount; i++) {
NSArray channels =
((EODatabaseContext
)databaseContexts.objectAtIndex(i)).registeredChannels();
int channelCount = channels.count();
for (int j = 0; j < channelCount; j++) {
//Make sure the channel you're trying to close isn't
performing a transaction.
if (!
((EODatabaseChannel
)channels
.objectAtIndex
(j)).adaptorChannel().adaptorContext().hasOpenTransaction()) {
((EODatabaseChannel
)channels.objectAtIndex(j)).adaptorChannel().closeChannel();
}
}
}
This closes one of the two database connection, not both.
Is there a way to detect the one extra connection or not open the
extra connection in the first place?
WOnder may have resolved this issue but adding WOnder is a bigger
undertaking then I originally expected.
Paraphrasing Lou Reed, I just want some of it, not all of it.
Thanks
kib
"Success is not final, failure is not fatal: it is the courage to
continue that counts.”
- Winston Churchill
Klaus Berkling
Systems Administrator
DynEd International, Inc.
www.dyned.com | www.eskimo.com/~kiberkli
_______________________________________________
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
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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