[ 
https://issues.apache.org/jira/browse/DERBY-646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512711
 ] 

Dave Syer commented on DERBY-646:
---------------------------------

I would like to test this storage strategy, but I don't know how to set it up.  
I have compiled the code against 10.2.1.6, and now I want to obtain a 
connection (ideally through a DataSource).  This is what I tried

System.setProperty("derby.subSubProtocol.memory", 
    "org.apache.derby.impl.io.MemoryStorageFactory");

EmbeddedDataSource ds = new EmbeddedDataSource();
ds.setDatabaseName("memory:test");
ds.setCreateDatabase("create");
Connection connection = ds.getConnection();

It fails with 

java.sql.SQLException: Failed to start database 'memory:test', see the next 
exception for details.
        at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        ...

There is no "next exception" in the stack trace.

I also tried:

System.setProperty("derby.subSubProtocol.memory", 
    "org.apache.derby.impl.io.MemoryStorageFactory");
DriverManager.registerDriver(new org.apache.derby.jdbc.EmbeddedDriver());
Connection connection = DriverManager.getConnection("jdbc:derby:memory:test")

which fails the same way.



> In-memory backend storage support
> ---------------------------------
>
>                 Key: DERBY-646
>                 URL: https://issues.apache.org/jira/browse/DERBY-646
>             Project: Derby
>          Issue Type: New Feature
>          Components: Store
>         Environment: All
>            Reporter: Stephen Fitch
>         Attachments: derby-646-1a-raw-compiles.diff, 
> derby-646-1a-raw-compiles.stat, svn.diff
>
>
> To allow creation and modification of databases in-memory without requiring 
> disk access or space to store the database.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to