db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Russell Bateman <r...@windofkeltia.com>
Subject Re: java.sql.SQLException: No suitable driver found for jdbc:derby:memory:sampledb;create=true
Date Thu, 25 Jun 2020 23:01:54 GMT
Thank you; that's very kind. It now works. (I'm not using DataSources 
for now.) I greatly appreciate your help.

Best regards,
Russ

On 6/25/20 4:48 PM, Rick Hillegas wrote:
> The 10.15 family of releases introduced a JPMS modularization of 
> Derby. That re-factored the code a bit. You will need to add 
> derbyshared.jar to the classpath and build dependencies. If you are 
> using DataSources, then you will also need to add derbytools.jar. 
> Please see the detailed release note for DERBY-6945 on the 10.15.1.3 
> download page: http://db.apache.org/derby/releases/release-10.15.1.3.html
>
> Hope this helps,
> -Rick
>
> On 6/25/20 1:28 PM, Russell Bateman wrote:
>> I have very recent code that works in a JUnit test case.
>>
>>    @Test
>>    public void test()
>>    {
>>       final String DATABASE = "jdbc:derby:memory:sampledb;create=true";
>>       final String USERNAME = "sa";
>>       final String PASSWORD = "sa";
>>
>>       final String CREATE_TABLE = "CREATE TABLE names ( oid INT
>>    GENERATED ALWAYS AS IDENTITY, name VARCHAR( 20 ) )";
>>       final String INSERT_NAME1 = "INSERT INTO names ( name ) VALUES (
>>    'Jack' )";
>>       final String QUERY        = "SELECT oid, name FROM names";
>>
>>       Connection connection = null;
>>
>>       try
>>       {
>>         connection = DriverManager.getConnection( DATABASE, USERNAME,
>>    PASSWORD );
>>
>>         Statement statement = connection.createStatement();
>>         ...
>>
>> In /pom.xml/, I have the following:
>>
>>    <dependency>
>>       <groupId>org.apache.derby</groupId>
>>       <artifactId>*derby*</artifactId>
>>       <version>10.15.2.0</version>
>>       <scope>test</scope>
>>    </dependency>
>>
>> I only want to use Derby _in-memory_ backing some unit test cases 
>> that need a database (not requiring a running server or dæmon, etc.). 
>> It all works perfectly inside IntelliJ IDEA.
>>
>> However, when I build from the command line (mvn clean package), I 
>> see this and can find no solution:
>>
>>    java.sql.SQLException: No suitable driver found for
>>    jdbc:derby:memory:sampledb;create=true
>>         at java.sql.DriverManager.getConnection(DriverManager.java:689)
>>         at java.sql.DriverManager.getConnection(DriverManager.java:247)
>>         at
>> com.imatsolutions.database.ApacheDerbyTest.testDirectlyToDerby(ApacheDerbyTest.java:78)

>>
>>
>> In /pom.xml/, I have tried adding the following, and I have tried 
>> many other solutions, some of which are supposed to be obsolete ( 
>> Class.for(...), DriverManager.registerDriver( ... ), etc. ), but 
>> cannot find a happy solution.
>>
>>    <dependency>
>>       <groupId>org.apache.derby</groupId>
>>       <artifactId>*derbyclient*</artifactId>
>>       <version>10.15.2.0</version>
>>       <scope>test</scope>
>>    </dependency>
>>
>> Any comment would be welcome.
>>
>> Thanks.
>>
>>
>


Mime
View raw message