Re: Just getting started

On 12/5/06, Bill Slack <wslack@xxxxxxx> wrote:
> Rob thanks for your response.
>
> When I first got Squirrel up and running, I assumed Squirrel started the
> database for me.  I guess I thought wrong: I must have had Netbeans start
> the database and  both were running when I first started Squirrel.
>
> The assumption was reinforced by the fact that I hadn't noticed a mechanism
> for Squirrel to start the database, because it doesn't have one -- as far as
> I have seen so far.  Is that right?  If this is a dumb question, remember
> I'm new to this :-).
>
I believe, it depends on the jdbc url that you use.  Some forms
specify a file path to the actual database files, and in that mode,
the database is running "in-memory" or "embedded".  Usually, only one
JVM can access the database files at a time in this mode.  The
exception to this is the "Network Server" mode which has a JVM listen
for requests on a port, allowing connections from multiple other JVMs.
 It, however, must be the only JVM that accesses the database files
"in-memory".  Here is a nice write-up contributed by Susan Cline on
the Apache Derby website, that talks about using SQuirreL with Derby:

http://db.apache.org/derby/integrate/SQuirreL_Derby.html

Rob

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV