Re: [OS-JIRA] Created: (CAY-183) Adapter for Clouscape/Derby DB

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue May 03 2005 - 23:07:12 EDT

  • Next message: jira-norepl..bjectstyle.org: "[OS-JIRA] Created: (CAY-313) Cayenne does not build with JDK 1.5"

    Just checked in Derby DbAdapter contributed by Tore Halset (see
    CAY-183). I made a few minor tweaks to make it run on Mac OS X (had to
    add System.setProperty("derby.storage.fileSyncTransactionLog", "true")
    to the DerbyStackAdapter) ...

    Here is the settings I used in connection.properties (note the database
    name is "testrun/testdb" to force its creation in the unit tests temp
    dir, and preventing it from appearing in the root project tree):

    derby.cayenne.adapter = org.objectstyle.cayenne.dba.derby.DerbyAdapter
    derby.jdbc.url = jdbc:derby:testrun/testdb;create=true
    derby.jdbc.driver = org.apache.derby.jdbc.EmbeddedDriver

    I got stuck when attempting to test Derby in the client/server mode
    (can't connect from JDBC and get some driver errors in "ij" tool), but
    I guess I simply need to read the manual.

    Another thing that I noticed is that even in embedded mode Derby was
    fairly slow compared to HSQL... But then HSQL does most of its work in
    memory, while Derby writes to disk (and not just to a single flat file,
    but to a number of binary files... I hope this overhead is justified
    (can it handle bigger datasets?)

    Andrus

    On Aug 17, 2004, at 11:19 AM, jir..bjectstyle.org wrote:
    >
    > http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-183
    >
    >
    > Here is an overview of the issue:
    > ---------------------------------------------------------------------
    > Key: CAY-183
    > Summary: Adapter for Clouscape/Derby DB
    > Type: New Feature
    >
    > Status: Assigned
    > Priority: Major
    >
    > Project: Cayenne
    > Components:
    > Cayenne Core Library
    > Fix Fors:
    > AFTER 1.1
    > Versions:
    > AFTER 1.1
    >
    > Assignee: Andrus Adamchik
    > Reporter: Andrus Adamchik
    >
    > Created: Tue, 17 Aug 2004 11:19 AM
    > Updated: Tue, 17 Aug 2004 11:19 AM
    >
    > Description:
    > As Cloudscape DB is now donated to Apache by IBM, the database will
    > become more relevant than it used to be up till now. It is likely that
    > Cayenne will support 99.9% of it without any changes, still it should
    > be nice to have a complete and tested adapter for Cloudscape.

    This archive was generated by hypermail 2.0.0 : Tue May 03 2005 - 23:07:53 EDT