db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ronald Rudy <ronchal...@gmail.com>
Subject Re: No suitable driver found for jdbc:derby
Date Wed, 31 Mar 2010 18:45:20 GMT
Before attempting to make the connection in your ExecSQL.getConnection() method by the looks
of it.

You can also add it anywhere in that class statically like this:

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


On Mar 31, 2010, at 2:43:23 PM, babylonlion wrote:

> 
> Where do I need to add it?
> 
> ronchalant wrote:
>> 
>> Try adding this first:
>> 
>> Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
>> 
>> Adjust the classname for whichever driver you're using.
>> 
>> -Ron
>> 
>> On Mar 31, 2010, at 2:26:11 PM, babylonlion wrote:
>> 
>>> 
>>> Hi experts,
>>> 
>>> I'm using JCreater to run a java program but after the program compiles
>>> successfully, I get this error message:
>>> 
>>> java.sql.SQLException: No suitable driver found for
>>> jdbc:derby:COREJAVA;create=true
>>>   at java.sql.DriverManager.getConnection(DriverManager.java:602)
>>>   at java.sql.DriverManager.getConnection(DriverManager.java:185)
>>>   at ExecSQL.getConnection(ExecSQL.java:86)
>>>   at ExecSQL.main(ExecSQL.java:22)
>>> 
>>> I'm using an emdedded driver. And I'm creating a database called COREJAVA
>>> 
>>> My environment variables are as follows: 
>>> CLASSPATH: .;C:\Apache\db-derby-10.5.3.0-bin\lib\derby.jar
>>> HOME_DERBY: C:\Apache\db-derby-10.5.3.0-bin
>>> Path: %DERBY_HOME%\bin
>>> 
>>> I've been working on it since Monday but couldn't get anywhere. Please
>>> help
>>> me
>>> -- 
>>> View this message in context:
>>> http://old.nabble.com/No-suitable-driver-found-for-jdbc%3Aderby-tp28099914p28099914.html
>>> Sent from the Apache Derby Users mailing list archive at Nabble.com.
>>> 
>> 
>> 
>> 
> 
> -- 
> View this message in context: http://old.nabble.com/No-suitable-driver-found-for-jdbc%3Aderby-tp28099914p28100127.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
> 


Mime
View raw message