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:58:12 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"? By the way, my instructore
has the same exact code and it's working fine. I did everything the way he
has on his computer but no luck. It's weird

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-tp28099914p28100339.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message