Can't run the Eclipse plug-in labs

["A. Rick Anderson" <ar...@pobox.com>]

Is there a bug in the eclipse plug-in for ij?  I've installed the 
eclipse-plug-in and when attempting to run the labs, it fails with the 
following message.  I have installed the Derby Nature in the project 
DerbyLab.

ij> connect 
'jdbc:derby:net://localhost:1527/jayDB;create=true;user=APP;password=APP;';

ERROR 08001: No suitable driver found for 
jdbc:derby:net://localhost:1527/jayDB;create=true;user=APP;password=APP;

When I googled this error message, it showed that the URL is different 
then derby is expecting it to be, but this would imply that there is a 
bug in the ij.bat script, something that would never pass any form of 
regression test.

I've tried setting DERBY_HOME, and that didn't change the behavior.

When I did the derby getting_started activities from the command-line, 
they all worked fine.  It's just within Eclipse that I seem to be having 
this challenge.

The only JRE or JDK on my machine is 1.6.  But I have Java 1.6, derby 
10.2.2 and I downloaded the latest JavaDB from Sun.  But since they all 
fundamentally share the exact same code, I don't see where this should 
cause a problem.
-- 
A. Rick Anderson

Re: Can't run the Eclipse plug-in labs

[Andrew McIntyre <mc...@gmail.com>]

On 2/15/07, A. Rick Anderson <ar...@pobox.com> wrote:
> Bryan Pendleton wrote:
> >> 'jdbc:derby:net://localhost:1527/jayDB;create=true;user=APP;password=APP;';
> > Try taking the "net:" out. Having "net:" in there means to use
> > the IBM DB2 JDBC driver, also called the "JCC" driver. The Derby JDBC
> > driver just uses the prefix jdbc:derby:, so just say jdbc:derby://...
>
> Yeah, I saw this comment when I was googling.  However, it is not clear
> to me where and how would I "take out the 'net'" from the URL?  I,
> personally, am not creating, nor invoking, the connection URL directly.
>   I am calling ij from Eclipse via the plug-in.  I have not been able to
> locate where the URL is being defined in the ij.bat or the
> derby_common.bat files that presumably the Eclipse plug-in is calling.
> The only files where I can find that this string is found is in the
> administration manuals.
>
> What I am trying to do is follow the lab that comes with the Eclipse
> plugin.  After installing, you are supposed to invoke 'ij' on
> jay_tables.sql script using the menu option "Apache Derby->Run SQL
> script using 'ij'".  This is where I get the error message.

What lab did you get this script from? Have you tried following the
instructions on the Derby website?
http://db.apache.org/derby/integrate/plugin_help/start_toc.html

The connect statement is an ij command in the jay_tables.sql script.
You would need to edit that script to take the 'net:' out of the
connection URL.

HTH,
andrew

Re: Can't run the Eclipse plug-in labs

["A. Rick Anderson" <ar...@pobox.com>]

Bryan Pendleton wrote:
>> 'jdbc:derby:net://localhost:1527/jayDB;create=true;user=APP;password=APP;'; 
> Try taking the "net:" out. Having "net:" in there means to use
> the IBM DB2 JDBC driver, also called the "JCC" driver. The Derby JDBC
> driver just uses the prefix jdbc:derby:, so just say jdbc:derby://...

Yeah, I saw this comment when I was googling.  However, it is not clear 
to me where and how would I "take out the 'net'" from the URL?  I, 
personally, am not creating, nor invoking, the connection URL directly. 
  I am calling ij from Eclipse via the plug-in.  I have not been able to 
locate where the URL is being defined in the ij.bat or the 
derby_common.bat files that presumably the Eclipse plug-in is calling. 
The only files where I can find that this string is found is in the 
administration manuals.

What I am trying to do is follow the lab that comes with the Eclipse 
plugin.  After installing, you are supposed to invoke 'ij' on 
jay_tables.sql script using the menu option "Apache Derby->Run SQL 
script using 'ij'".  This is where I get the error message.

If it happens to me, in this context, then presumably, everyone that has 
ever tried to follow the lab for the eclipse plugin would have the same 
error message.

-- 
A. Rick Anderson

Re: Can't run the Eclipse plug-in labs

[Bryan Pendleton <bp...@amberpoint.com>]

> 'jdbc:derby:net://localhost:1527/jayDB;create=true;user=APP;password=APP;';

Try taking the "net:" out. Having "net:" in there means to use
the IBM DB2 JDBC driver, also called the "JCC" driver. The Derby JDBC
driver just uses the prefix jdbc:derby:, so just say jdbc:derby://...

thanks,

bryan