Nader Mirzadeh wrote: > > Thanks for the reply, > and this gives raise to another question: if you've a pool of connections > managed by Database object; > - when you ask the Database object for a collection, then a connecting is > given to that collection. So, each collection has its own connection. Now, > you need transaction support, so you cannot have commit on both collections > because they DON'T share the same connection. The new question is how to get > around this kind of situation!?!
What are you mapping to a collection in your model? Perhaps the transaction service would need to move to the database level. Also there is nothing that says each collection has to have a seperate connection. Behind the scenes you can manage things however you need. If you want all collections on a single server to share the same connection then you should be able to do that. Right now transaction support is primative at best so overall I'm not sure what the best way to handle this is. I'd love some insight to help flesh this area of the API out a little better. BTW, this discussion should really move to the [EMAIL PROTECTED] mailing list. > > Regarding your question, we are developing our own tools for submitting > queries. The language is very simple, and has the SQL like syntax. > > Regards > Nader > > -----Messaggio originale----- > > Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] conto di > > Lars Martin > > Inviato: mercoledi 16 maggio 2001 17.42 > > A: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Oggetto: Re: Connection Pool > > > > > > > > On Wed, 16 May 2001 14:09:21 +0200 > > "Nader Mirzadeh" <[EMAIL PROTECTED]> wrote: > > > > > We are currently implementing XML:DB API for reusing a legacy relational > > > database. We use JDBC to connect to the database systems, and > > we would like > > > to use a connection pool. And the questions are: What object > > should hold the > > > connection: Collection or Database? Who (object) should manage > > the pool?, > > > and how the transactions are handled? > > > > Great. > > One question: Are you using an existing mapping tool to map from XML > > to SQL and back or are you using an self-made solution? > > > > Regards, > > Lars > > -- > > ______________________________________________________________________ > > Lars Martin mailto:[EMAIL PROTECTED] > > SMB GmbH http://www.smb-tec.com > > > > > > --------------------------------------------------------------------- > > Post a message: mailto:[EMAIL PROTECTED] > > Unsubscribe: mailto:[EMAIL PROTECTED] > > Contact adminstrator: mailto:[EMAIL PROTECTED] > > Read archived messages: http://archive.xmldb.org/ > > --------------------------------------------------------------------- > > > > --------------------------------------------------------------------- > Post a message: mailto:[EMAIL PROTECTED] > Unsubscribe: mailto:[EMAIL PROTECTED] > Contact adminstrator: mailto:[EMAIL PROTECTED] > Read archived messages: http://archive.xmldb.org/ > --------------------------------------------------------------------- -- Kimbro Staken The dbXML Project http://www.dbxml.org/ ---------------------------------------------------------------------- Post a message: mailto:[EMAIL PROTECTED] Unsubscribe: mailto:[EMAIL PROTECTED] Contact adminstrator: mailto:[EMAIL PROTECTED] Read archived messages: http://archive.xmldb.org/ ----------------------------------------------------------------------
