Cayenne itself works with a DataSource. All connection management and
starting and stopping the embedded DB is deferred to the DataSource
and is beyond Cayenne scope. The default DataSource implementation
pools connections. If you need a different policy, you need to provide
a DataSource that does whatever is appropriate in your environment.
Custom DataSource is installed by providing a special
DataSourceFactory for a give DataNode in the Modeler.
Andrus
On Mar 31, 2008, at 9:58 AM, Colin Bankier wrote:
> Hi,
> I can't seem to find any examples of how to properly close a database
> connection and clear any related cache.
>
> My app is using an embedded database, of which it can download a new
> version
> and overwrite the old one.
>
> At the moment I try to clear any cache using
> context.getQueryCache().clear()
> (context is my DataContext instance).
> And then set the context to null (for want of anything better to do).
>
> The app then downloads and copies a new version of the database over
> the
> old, and connects using context = DataContext.createDataContext()
> etc etc.
>
> However - the data displayed STILL is the old data - until the app is
> shutdown and re-started when it correctly reads the new data.
>
> Any help on how to properly close the database connection would be
> greatly
> appreciated.
> Cheers,
> Colin Bankier.
> --
> View this message in context: http://www.nabble.com/How-to-propoerly-close-context-db-connection-tp16392733p16392733.html
> Sent from the Cayenne - User mailing list archive at Nabble.com.
>
>
This archive was generated by hypermail 2.0.0 : Mon Mar 31 2008 - 04:52:30 EDT