Re: How to propoerly close context db connection

From: Colin Bankier (colinbankie..otmail.com)
Date: Fri Apr 18 2008 - 22:01:56 EDT

  • Next message: Andrus Adamchik: "Re: Mysql and usernames"

    Thanks to everyone who posted to help me out. Sorry I was pulled away from
    working on this for a while and only now got the time to finally solve it.
    It turned out that, as Andrus mentioned, the problem was with the DB itself
    - which is Derby in this case - and reading the docs on how to properly
    shutdown the Derby database solved the problem.
    A simple DriverManager.getConnection("jdbc:derby:;shutdown=true") did the
    trick.
    Cheers,
    Colin.

    Andrus Adamchik wrote:
    >
    > Embedded DB's add a whole other dimension to that by keeping committed
    > data in memory at the driver level - something Cayenne is not aware
    > of. So anything you do with "clearCache" or RefreshQuery, etc.,
    > affects Cayenne cache, and not the embedded DB JDBC layer. So here
    > you'd need to read the embedded DB docs (is that Derby, HSQL, H2?) and
    > see what they recommend to do in such situation. There maybe a SQL
    > query that would shutdown/reopen the file, or something else (like
    > restarting the DataSource).
    >
    > Andrus
    >

    -- 
    View this message in context: http://www.nabble.com/How-to-propoerly-close-context-db-connection-tp16392733p16767462.html
    Sent from the Cayenne - User mailing list archive at Nabble.com.
    



    This archive was generated by hypermail 2.0.0 : Fri Apr 18 2008 - 22:02:30 EDT