IJ ERROR: Unable to establish connection

[Les StJames <ls...@hotmail.com>]

Hello -

I am using Derby 10.1.3.1 in Network Server mode as bundled with Sun's Java 
System Applicaiton Server 9 on winXP Pro sp2.

It works fine as a black box with example applications but i need access to 
manipulate DDL.
Virtually all ij commands including CONNECT yield 'Unable to establish 
connection', while
NetworkServerControl ping reports a successful connection - 'connection 
obtained for host: localhost, port number 1527' and derby.log reports 
'Server is ready to accept connections on port 1527'.

Anyone have similar experience or otherwise know what the deal is or how to 
fix it?

Any suggestions/help very welcome.

Les

_________________________________________________________________
Scarica Windows Live Messenger e chiama gratis in tutto il mondo! 
http://www.messenger.it/connessione.html

Re: IJ ERROR: Unable to establish connection

[Francois Orsini <fr...@gmail.com>]

Les,

I take it you used a connection URL such as:

Such as in IJ:

D:> java org.apache.derby.tools.ij

ij> connect 'jdbc:derby://localhost:1527/TheDBName';
ij>

There should be some ij.ksh/bat files available as part of the application
server too...loading the appropriate classes to connect to a derby instance
running in server mode.

java -cp
"%DERBY_HOME%\lib\derbyclient.jar;%DERBY_HOME%\lib\derbytools.jar;%CLASSPATH%"
-Dij.driver=org.apache.derby.jdbc.ClientDriver -
Dij.protocol=jdbc:derby://localhost:1527/ org.apache.derby.tools.ij

If you could post the steps you're typing - might be able to help more...

On 5/6/07, Les StJames <ls...@hotmail.com> wrote:
>
> Hello -
>
> I am using Derby 10.1.3.1 in Network Server mode as bundled with Sun's
> Java
> System Applicaiton Server 9 on winXP Pro sp2.
>
> It works fine as a black box with example applications but i need access
> to
> manipulate DDL.
> Virtually all ij commands including CONNECT yield 'Unable to establish
> connection', while
> NetworkServerControl ping reports a successful connection - 'connection
> obtained for host: localhost, port number 1527' and derby.log reports
> 'Server is ready to accept connections on port 1527'.
>
> Anyone have similar experience or otherwise know what the deal is or how
> to
> fix it?
>
> Any suggestions/help very welcome.
>
> Les
>
> _________________________________________________________________
> Scarica Windows Live Messenger e chiama gratis in tutto il mondo!
> http://www.messenger.it/connessione.html
>
>