On 21/10/09 2:56 PM, Eric Lazarus wrote:
About the meaning of 'embedded': I think that the 2nd option has a
server process running tcp on some port number in the 9000's. Does this
count as an 'embedded' database? I assume not.
Also, what happens in the
first case if the user opens two instances
Thanks, Folks!
What 'adapter' do I use for H2 in cayenne.xml? What 'adapter' do I use for H2
in cayenne.xml? I imagine it will be something like cayenne.dba.H2.H2Adapter?
About the meaning of 'embedded': I think that the 2nd option has a
server process running tcp on some port number in the 9000
If I recall, the "jdbc:h2:path" url will accept any username/password
you give it and create the database appropriately. You don't have to
use the default "sa"/(blank)
On Tue, Oct 20, 2009 at 8:15 PM, Michael Gentry wrote:
> An embedded database is one that runs internally instead of requiring
I implemented a DataSourceFactory to obtain this same functionality.
specifically around having a single executable JAR and derby not
finding its schema creation file. The DSF lets the system auto-detect
schema existence and use embedded ant to create it as required.
Your mileage may vary
John-
O
An embedded database is one that runs internally instead of requiring
a separate database server. This makes it convenient for standalone
applications.
For the database connection itself, though, you'd want something like:
JDBC URL: jdbc:h2:~/mydb
Username: sa
Password:
As for PostgreSQL suppo
Do you want the database to be a single-user resource which is
persisted between runs?
If so, it should be as simple as using jdbc:h2:~/test/testdatabase as
your jdbc url where "~/test/cistestdatabase" is the path to your
database (it will be a directory). Most likely, this is what you
want.
Usi
Folks
Thanks for you folks direction on using H2 as our database but we are a bit
stuck on how to do it. We are moving toward using Cayenne 3.0M6 and H2 for the
desktop version of an application that should be as idiot proof as possible. We
want for the end user to not have to understand that t
Hello,
If you're using Cayenne as the ORM in a thick desktop client (e.g.,
RCP), and executing a long-running query, is there a Cayenne
methodology for interrupting and canceling such a query, or would one
just use normal threading?
Thanks--Lawrence
