RE: HSQLDB

From: Pirola Davide (davide.pirol..tin.it)
Date: Mon Feb 27 2006 - 05:04:44 EST

  • Next message: Dave Merrin: "RE: SingleObjectQuery & ObjectID"

    Hi Andrus,
    you are right... the xml file is not well formed.
    Thank you!
    Another question..
    I have different node in my cayenne.xml file.
    2 node point to Oracle database, and the last point to HSQLDb.
    I want to read some data from Oracle and write it to HSQLDb.
    Each nodes have the same datamap.xml file.. so i am trying to use the same obj-enity and db-entity for read data from Oracle and write to HSQLDB.
    Is this possible or i must create different datamap.xml file for each db?
    I use this code for write data:

            ...dataContext.registerNewObject(mycayennedataobject);
            ...dataContext.commitChanges();

    ..so how cayenne know which database is the one that have the table where write data?

    Thank's
    Davide

    -----Original Message-----
    From: Andrus Adamchik [mailto:andru..bjectstyle.org]
    Sent: sabato 25 febbraio 2006 6.44
    To: cayenne-use..bjectstyle.org
    Subject: Re: HSQLDB

    I can confirm that Cayenne works with HSQLDB. For instance Modeler
    preferences subsystem is based on HSQLDB, also our default unit test
    setup uses it.

    > basically, this happens when the datamap.xml or driver.xml or other
    > configuration files have errors.

    But Cayenne is not expected to work if configuration has errors. And
    I would also expect an exception on startup if this is the case. From
    a quick glance, it looks like you XML is not well formed - there is
    no space after before "datasource":

    name="hsqldb-local-jndi"datasource=

    Andrus

    On Feb 24, 2006, at 1:48 PM, Pirola Davide wrote:

    > Hi Andrus,
    > i want to use Cayenne with HSQLDB database. I have read on your
    > site that is supported, but when i try to use it, this call return
    > a Null value:
    >
    > Configuration.getSharedConfiguration().getDomain()
    >
    > basically, this happens when the datamap.xml or driver.xml or other
    > configuration files have errors.



    This archive was generated by hypermail 2.0.0 : Mon Feb 27 2006 - 05:04:57 EST