HSQLDB

From: Pirola Davide (davide.pirol..tin.it)
Date: Fri Feb 24 2006 - 05:48:17 EST

  • Next message: Andrus Adamchik: "Re: SingleObjectQuery & ObjectID"

    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.

    My "cayenne.xml" file is :

    <?xml version="1.0" encoding="utf-8"?>
    <domains project-version="1.1">
            <domain name="rtstat">
                    .... OTHER node to Oracle db ....
                   
                    <map name="DataMapHsqldb" location="DataMapHsqldb.map.xml" />
                    <node name="hsqldb-local-jndi"datasource="hsqldb-local.driver.xml" adapter="org.objectstyle.cayenne.dba.hsqldb.HSQLDBAdapter"
                            factory="org.objectstyle.cayenne.conf.DriverDataSourceFactory">
                            <map-ref name="DataMapHsqldb" />
                    </node>
            </domain>
    </domains>

    my "...driver.xml" file is :

    <?xml version="1.0" encoding="utf-8"?>
    <driver project-version="1.1" class="org.hsqldb.jdbcDriver">
            <url value="jdbc:hsqldb: <file://...../rtstat-1.0/rtstat/db/rtstat> file:/........................./db/rtstat"/>
            <connectionPool min="1" max="500" />
            <login userName="sa" password=""/>
    </driver>

    You can confirm me that is possible to connect to this kind of database?

    You find some error in the xml files above?

    Thank's
    Davide
     

    This archive was generated by hypermail 2.0.0 : Fri Feb 24 2006 - 05:48:20 EST