Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of raykroeker@gmail.com
 designates 209.85.160.172 as permitted sender)
MIME-Version: 1.0
Reply-To: raykroeker@gmail.com
In-Reply-To: 
 <1187248881.385094.1312829228336.JavaMail.root@sz0138a.westchester.pa.mail.comcast.net>
References: 
 <CAKCPySHMcNnu-FeWfX_wZE1UoL+Ui=rhS=_RD5EkuVdMmykBiw@mail.gmail.com>
	<1187248881.385094.1312829228336.JavaMail.root@sz0138a.westchester.pa.mail.comcast.net>
Date: Mon, 8 Aug 2011 11:55:09 -0700
Message-ID: 
 <CAKCPySGfh7zjOfcRWB3KnOa0VbB2m-q1XVLw=HNaFEYEb6xR2w@mail.gmail.com>
Subject: Re: Can't Load Embedded Driver
From: Raymond Kroeker <raykroeker@gmail.com>
To: Roy.Minet@comcast.net
Cc: Derby Discussion <derby-user@db.apache.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Roy,

The fqcn, is the fully qualified class name of the driver.  So in your
code you're using the driver manager to grab a connection; however I
don't see a reference to loading the driver:
http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html#embedded_dri=
ver

Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();

Raymond

On Mon, Aug 8, 2011 at 11:47,  <Roy.Minet@comcast.net> wrote:
> I do not know what an "fqcn" is.=A0 I am running the latest Derby release=
,
> 10.8.1.2.=A0 The code pasted in below=A0works great=A0in the dev environm=
ent
> (IntelliJ Idea), but the same code packaged in a jar cannot find the driv=
er
> with CLASSPATH set correctly.
>
> =A0=A0 public static Connection getConnection()
> =A0=A0 {
> =A0=A0=A0=A0=A0 Connection c =3D null;
> =A0=A0=A0=A0=A0 try
> =A0=A0=A0=A0=A0 {=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 // The connectionUR=
L
> is=A0"jdbc:derby:EMDatabase;create=3Dtrue"
> =A0=A0=A0=A0=A0=A0=A0=A0 c =3D DriverManager.getConnection(connectionURL)=
;
> =A0=A0=A0=A0=A0=A0=A0=A0 c.setAutoCommit(false);
> =A0=A0=A0=A0=A0 }
> =A0=A0=A0=A0=A0 catch (Throwable e)
> =A0=A0=A0=A0=A0 {
> =A0=A0=A0=A0=A0=A0=A0=A0 log(3, "Unable to connect to " + dbName + ":=A0 =
" + e.getMessage());
> =A0=A0=A0=A0=A0=A0=A0=A0 stopDBMS();
> =A0=A0=A0=A0=A0=A0=A0=A0 System.exit(3);
> =A0=A0=A0=A0=A0 }
> =A0=A0=A0=A0=A0 return c;
> =A0=A0 }
>
>
>
> ________________________________
>
> From: "Raymond Kroeker" <raykroeker@gmail.com>
>
> To: "Derby Discussion" <derby-user@db.apache.org>
> Sent: Monday, August 8, 2011 10:08:11 AM
> Subject: Re: Can't Load Embedded Driver
>
> Can you try specifying the driver as a fqcn? If that doesn't solve the is=
sue
> please paste relevant code around how you load the driver and obtain a
> connection.
>
> Raymond
>
> On Aug 8, 2011 6:55 AM, <Roy.Minet@comcast.net> wrote:
>>
>>
>> Rick,
>>
>>
>>
>> Thank you very much for offering your help.=A0 Apparently my CLASSPATH i=
s
>> good.=A0 I=A0typed in=A0"java org.apache.derby.jdbc.EmbeddedDriver" and =
did indeed
>> get exactly the expected "Exception in thread "main"
>> java.lang.NoSuchMethodError: main" error message.=A0 What else=A0could b=
e
>> causing =A0my problem?
>>
>>
>>
>> Roy
>>
>>
>>
>>
>>
>> ----- Original Message -----
>>
>>
>> From: "Rick Hillegas" <rick.hillegas@oracle.com>
>> To: "Derby Discussion" <derby-user@db.apache.org>
>> Sent: Monday, August 8, 2011 9:00:58 AM
>> Subject: Re: Can't Load Embedded Driver
>>
>> On 8/7/11 9:54 AM, Roy.Minet@comcast.net wrote:
>>>
>>> I have been happily using Derby for two years within IntelliJ Idea,
>>> but have now hit a wall trying to deploy the application I developed.
>>> I have tried setting the path to derby.jar on the command line and/or
>>> in the CLASSPATH environment variable to no avail. =A0The embedded
>>> driver doesn't load; the error message is, "No suitable driver found
>>> for jdbc:derby:EMDatabase;create=3Dtrue". =A0I'm under Windows XP Pro.
>>> Any help would be appreciated.
>>>
>>> Roy Minet
>>>
>>>
>> Hi Roy,
>>
>> This is almost always a CLASSPATH problem. With the same CLASSPATH, try
>> the following experiment:
>>
>> java org.apache.derby.jdbc.EmbeddedDriver
>>
>> If the CLASSPATH is good, you should see this error:
>>
>> Exception in thread "main" java.lang.NoSuchMethodError: main
>>
>> Hope this helps,
>> -Rick
>


--=20
---------------------------------------------------------
Raymond Kroeker