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.
>
