Hi,
first of all I`m new to nHibernate and Rhino.Tools, so forgive my lack
of knowledge.
I`m doing some little experiments with this great tools, and got to
point when
I want to speed-up my unit tests, and use in memory DB support.
So I changed DatabaseEngine to SQLite (it works as charm for
MSSQL2005, MSSQLCE).
Then got exception from schema export ->
"SQLite error\r\nunrecognized token: \"\"
(OrderID INTEGER not null, ProductID INTEGER not null, UnitPrice
NUMERIC not null, Quantity INTEGER not null, Discount NUMERIC not
null, primary key (OrderID, ProductID))\""

Bug, or maybe some limitation of SQLite for composite-id`s ?
Is it possible to log full info about schema export from my code
sample? (by enabling some logger?)

My code sample:
------
...
IntializeNHibernateAndIoC(PersistenceFramework.NHibernate,
                                      path,
                                      DatabaseEngine.SQLite,
                                      "",
 
MappingInfo.FromAssemblyContaining<Employee>());

CurrentContext.CreateUnitOfWork(); <- exception
...
------


Order detail def:
----------
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
assembly="Northwind.Core" namespace="Northwind.Core.Domain">
    <class lazy="false" name="OrderDetail" table="`Order Details`" >
    <composite-id name="ID"
class="Northwind.Core.Domain.DomainObjectID">
        <key-property type="System.Int32" name="OrderID"
column="OrderID" />
        <key-property type="System.Int32" name="ProductID"
column="ProductID" />
    </composite-id>
    <property name="UnitPrice" column="UnitPrice"
type="System.Decimal" not-null="true" />
    <property name="Quantity" column="Quantity" type="System.Int16"
not-null="true" />
    <property name="Discount" column="Discount" type="System.Double"
not-null="true" />
    <many-to-one name="Order" column="OrderID" class="Order"
update="false"  insert="false" />
    <many-to-one name="Product" column="ProductID" class="Product"
update="false"  insert="false" />
 </class>
</hibernate-mapping>
------------

Versions:
Rhino.Commons.NHibernate - 2.0
nHibernate - 2.1.0.1001

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Rhino Tools Dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/rhino-tools-dev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to