use:new SchemaExport(cfg).Create(true,false); This will give you the script that NH is generating.
On Sat, Oct 4, 2008 at 7:49 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED] > wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
