You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by "A. Rick Anderson" <ar...@pobox.com> on 2007/02/15 19:51:37 UTC
Wrong ULR in Eclipse Plug-in Lab
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: Fixed: Wrong ULR in Eclipse Plug-in Lab
Posted by Andrew McIntyre <mc...@gmail.com>.
On 2/15/07, A. Rick Anderson <ar...@pobox.com> wrote:
> That fixed it. A grep/search on the Java tree didn't show this
> connection URL anywhere and it never occurred to me that the URL would
> be embedded in the SQL script itself.
>
> I appreciate your help.
>
> Should I submit this to Jira as a bug, or did you already do that?
Funny, I had never noticed that presentation and lab on the website
before. I've fixed the URL in the lab, the update should be visible on
the Derby website in about an hour, no need to file a bug. Thanks for
noticing that and letting us know!
cheers,
andrew
Re: Fixed: Wrong ULR in Eclipse Plug-in Lab
Posted by Rajesh Kartha <ka...@gmail.com>.
A. Rick Anderson wrote:
> That fixed it. A grep/search on the Java tree didn't show this
> connection URL anywhere and it never occurred to me that the URL would
> be embedded in the SQL script itself.
>
> I appreciate your help.
>
> Should I submit this to Jira as a bug, or did you already do that?
>
Please submit a JIRA bug, will help in tracking and fixing it. In case
you need, here is some info on creating a JIRA bug.
-Rajesh
Fixed: Wrong ULR in Eclipse Plug-in Lab
Posted by "A. Rick Anderson" <ar...@pobox.com>.
That fixed it. A grep/search on the Java tree didn't show this
connection URL anywhere and it never occurred to me that the URL would
be embedded in the SQL script itself.
I appreciate your help.
Should I submit this to Jira as a bug, or did you already do that?
Rajesh Kartha wrote:
> A. Rick Anderson wrote:
>
>> 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.
>
> Hi Rick,
>
>
> http://db.apache.org/derby/integrate/plugin_slides.html
>
> Looks like the url in the jay_tables.sql file needs a minor fix and change
>
> connect
> 'jdbc:derby:net://localhost:1527/jayDB;create=true;user=APP;password=APP;';
>
> to
>
> connect
> 'jdbc:derby://localhost:1527/jayDB;create=true;user=APP;password=APP;';
>
> The other sql files show the correct url. The above url uses the Derby
> client driver to connect
> to the server.
--
A. Rick Anderson
Re: Wrong ULR in Eclipse Plug-in Lab
Posted by Rajesh Kartha <ka...@gmail.com>.
A. Rick Anderson wrote:
> 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.
Hi Rick,
http://db.apache.org/derby/integrate/plugin_slides.html
Looks like the url in the jay_tables.sql file needs a minor fix and change
connect
'jdbc:derby:net://localhost:1527/jayDB;create=true;user=APP;password=APP;';
to
connect
'jdbc:derby://localhost:1527/jayDB;create=true;user=APP;password=APP;';
The other sql files show the correct url. The above url uses the Derby
client driver to connect
to the server.
Do post to the mail should come across any other issues.
-Rajesh