db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "john miltone" <miltone.milt...@gmail.com>
Subject RE: DriverManager.getConnection error with JDK 7
Date Sat, 23 Feb 2013 15:47:15 GMT
Hi John English and thank you for help.

I caught SQLException and he said that : "No suitable driver found for
jdbc:derby:MoneyBack1;create=true;user=miltone;password=password"

I have corrected the comma in my string for create table in Derby but this
error coming back. However I created database in Derby with ij tool with
this command :"connect 'jdbc:derby:MoneyBack1;create=true';
I have inserted value in table and try access those value with select
statement. All is good in derby ij.

My derby path is in jdk 7 db directory.

In my code I tested lot with different connection string but always the same
error hereabove.

Like as :
- String connectionURL = "jdbc:derby:" + dbName + ";create=true;user=" +
user + ";password=" + password ;
- String connectionURL2 = "jdbc:derby:" + dbName + ";create=true;user=" +
user;
- String connectionURL3 = "jdbc:derby:" + dbName + ";user=" + user;
- String connectionURL4 = "jdbc:derby:" + dbName;


-----Message d'origine-----
De : John English [mailto:john.foreign@gmail.com] 
Envoyé : samedi 23 février 2013 14:50
À : derby-user@db.apache.org
Objet : Re: DriverManager.getConnection error with JDK 7

On 23/02/2013 13:21, john miltone wrote:
>          String connectionURL = "jdbc:derby:" + dbName + 
> ";create=true;user=" + user + ";password=" + password ;
>              Connection connexion = 
> DriverManager.getConnection(connectionURL);

Oops, replied too hastily... didn't notice this:

> DriverManager.getConnection throw a exeception always.

Difficult to say unless you provide details of the error message for the
exception. Does the connectionURL work if you connect with IJ? Is the dbname
a relative or absolute directory name? If it's relative, are you in the
correct current directory when you try and connect?

HTH,
--
John English


Mime
View raw message