squirrel-sql-users

[Squirrel-sql-users] Just getting started

[Bill S. <ws...@sh...>]

I am just looking over Squirrel for the first time.
I am working with Netbeans and javaDB (Derby).
I created a database (pre Squirrel installation) with Netbeans, which =
runs fine.
After successfully installing Squirrel, I created an alias to the =
database and  connected OK using the alias.
The problem is that Squirrel won't connect to javaDB "after" I have made =
a connection from Netbeans again.
But if I start javaDB with Netbeans and then try to make a connection =
with Sqirrel, everything is OK.

Is this usual behaviour?

Thanks,
Bill

Re: [Squirrel-sql-users] Just getting started

[Robert M. <rob...@gm...>]

On 12/1/06, Bill Slack <ws...@sh...> wrote:
>
>
> I am just looking over Squirrel for the first time.
> I am working with Netbeans and javaDB (Derby).
> I created a database (pre Squirrel installation) with Netbeans, which runs
> fine.
> After successfully installing Squirrel, I created an alias to the database
> and  connected OK using the alias.
> The problem is that Squirrel won't connect to javaDB "after" I have made a
> connection from Netbeans again.
> But if I start javaDB with Netbeans and then try to make a connection with
> Sqirrel, everything is OK.

Bill,

What is the jdbc url that you use from SQuirreL to connect and how do
you start the database?  I start mine up in "Network Server" mode
using startNetworkServer.bat
(comes with Derby) and then use the following url to connect:

jdbc:derby://localhost:1527/<databasename>

Is it possible that you are running the DB in the same JVM as SQuirreL
(embedded) but with NetBeans it is starting it in "server" mode?  I
don't know much about the JavaDB that is provided with NetBeans and
how it is started, but my guess would be that it's running in embedded
mode in SQuirreL (only when NetBeans hasn't already started it)

Rob

Re: [Squirrel-sql-users] Just getting started

[Robert M. <rob...@gm...>]

On 12/5/06, Bill Slack <ws...@sh...> 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