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.
