On Thu, May 14, 2009 at 08:42, Stuart Owen <[email protected]> wrote:
> Does anybody have any experience with supporting multiple > connections, including from other applications, to a Derby database? > To my knowledge, the only way to do this is to run it, and connect > to it, as a server instance, but its also been suggested to me that > running with row-level locking turned on also allows multiple > connections directly to the file. Yeah, I think the trick is to start one Derby server instance running separately on a specific port, in a separate JVM. Of course doing this takes a way half of the point of using an embedded database, but still there should be no installation requirement except Java. (compared to say mySQL) We could have a magic file in $HOME/.taverna to say what the port the server is listening to (there are ways to find an available port, so it should not be a problem with several users running Taverna on the same machine) - and possibly a magic table of who is 'connected' - so that we can shut down the database when the last client (ie. typically Taverna workbench) is quitting. -- Stian Soiland-Reyes, myGrid team School of Computer Science The University of Manchester ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ taverna-hackers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/taverna-hackers Developers Guide: http://www.mygrid.org.uk/usermanual1.7/dev_guide.html FAQ: http://www.mygrid.org.uk/wiki/Mygrid/TavernaFaq
