Re: Can't open more than one connection to database?

[Dag H. Wanvik]

On 01. feb. 2014 18:20, Paul Linehan wrote:

Hi again all,



I normally connect to derby using either ij or SQuirreL SQL
or both.


Found it!

Using connect 'jdbc:derby://localhost:1527/pdata/firstdb';

I can use multiple connections - I was using a different connection string

CONNECT 'jdbc:derby:firstdb';

which obviously picks up the embedded driver in some shape or form!


Yes, the above syntax is for the embedded driver, which would be a 
second JVM trying the boot firstDB (illegal).


Dag




Sorry about the panic!


Paul...

Re: Can't open more than one connection to database?

[Paul Linehan]

Hi again all,


 I normally connect to derby using either ij or SQuirreL SQL
 or both.


Found it!

Using connect 'jdbc:derby://localhost:1527/pdata/firstdb';

I can use multiple connections - I was using a different connection string

CONNECT 'jdbc:derby:firstdb';

which obviously picks up the embedded driver in some shape or form!


Sorry about the panic!


Paul...



-- 

lineh...@tcd.ie

Mob: 00 353 86 864 5772