db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From babylonlion <sanlee...@hotmail.com>
Subject Re: No suitable driver found for jdbc:derby
Date Wed, 31 Mar 2010 18:55:20 GMT

I'm sorry but I'm really new to this and I'm not sure how or where to add
this piece of code. And what is "class.forName"?

ronchalant wrote:
> 
> 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.
>> 
> 
> 
> 

-- 
View this message in context: http://old.nabble.com/No-suitable-driver-found-for-jdbc%3Aderby-tp28099914p28100309.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message