Re: Connection in embeded McKoi database
John Zoetebier <[email protected]>
| Newsgroups | gmane.comp.db.mckoi |
|---|---|
| Organization | Transparent Systems |
| Message-ID | <[email protected]> |
On Thu, 18 Nov 2004 11:34, Tobias Downer wrote: > John, > > You can connect to an embedded database with multiple users and > establish multiple JDBC connections safely, provided you ensure that all > the connections to the database are from the same JVM instance. If > client applications running in different JVMs are required to connect to > a database source then using the database server is necessary. > > Toby. I have a JDBC connection pool running regardless of embedded or server mode. This makes it completely transparent from an application point of view in which mode the server runs, apart from performance enhancements. But in embedded mode the server is not listening on a port. So, how can more than one user connect to a database in embedded mode ? Normally each user is on their own PC, so will run the client in a different JVM. Sharing McKoi on the same PC by sharing the JVM does not look a common scenario to me. -- John Zoetebier Web site: http://www.transparent.co.nz > > John Zoetebier wrote: > > On Thu, 18 Nov 2004 05:09, ruta kadhe wrote: > >>I have two doubts: > >>1. Can more than one clients connect and talk to the > >>McKoi database which is embeded in the application at > >>the same time? > > > > When you run McKoi in embedded mode both client and database server run > > in the same JVM. > > In embeded mode you have 1 user accessing the database. > > If you want to have more than 1 user acessing the database, you have to > > run McKoi in server mode. > > In TS Client (http://sourceforge.net/projects/ts-client) I use a > > configuration file to determine in which mode McKoi is running. > > For end-user testing is is very handy to run in embedded mode as it does > > not require any setup to run. > > In production environment the database runs in server mode. > > All the administrator need to do is a change to the configuration file. > > > >>2. Can we use the McKoi database within commercial > >>application, retaining the copywright notice? > > > > The GPL states that the GPL code should not be a statically linken into > > your application. > > If you follow my method described above the link is dynamic and you > > should be allowed to use McKoi in a commercial application. > > --------------------------------------------------------------- > Mckoi SQL Database mailing list http://www.mckoi.com/database/ > To unsubscribe, send a message to [email protected] --------------------------------------------------------------- Mckoi SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to [email protected]