hello,

i have tested the "Hibernate Quick Start Guide" (http://www.hibernate.org/362.html).

but i get an exception in my testproject (with MSAccess), when i want to write the data with transaction.Commit();

ADOException: could not insert: [NHibernateTest.User#joe_cool][SQL: INSERT INTO users (Name, Password, EmailAddress, LastLogon, LogonId) VALUES (?, ?, ?, ?, ?)]

can anyone help?

thanks

Firs thing to do is this:
1. Get the sql that NHibernate is producing
2. Rund the sql manually against the database.

does insert succeed this way?

hello DarkCloud,

thanks for answering.

i think this is the sql-statement, that nhibernate produces:
INSERT INTO users (Name, Password, EmailAddress, LastLogon, LogonId) VALUES (?, ?, ?, ?, ?)

the question is, why?

here my code (that is from the "quick start quide"):

// create a Configuration object...
Configuration cfg = new Configuration();
cfg.AddAssembly( "NHibernateTest" );

// create a session object...
ISessionFactory factory = cfg.BuildSessionFactory();
ISession session = factory.OpenSession();
ITransaction transaction = session.BeginTransaction();

// create an user
User newUser = new User();
newUser.Id = "joe_cool";
newUser.UserName = "Joseph Cool";
newUser.Password = "abc123";
newUser.EmailAddress = "joe@cool.com";
newUser.LastLogon = DateTime.Now;

// Tell NHibernate that this object should be saved
session.Save( newUser );


// commit all of the changes to the DB and close the ISession
transaction.Commit();

// close this Session
session.Close();

an idea?

thank you

NHibernate uses prepared statements to interact with the database. You are looking at where the prepared statement is being generated, like so:


If you look further down in the log file, you'll see where the actual insert takes place, like so:

Here you see there the actual insert takes place. This is the statement you would want to test directly against the DB. Does that help?

hello jlockwood,

thanks for answering.

unfortunately i don't know, where i can find this log-file.

can you help?

thanks

Hey! I've never seen those in my log files :)
I use log4net and Castle.ActiveRecord.

Did i forgot to tell nhibernate to log sql explicitly, or what?
:)[/quote]

Logging is managed by log4net library.

you should read log4net documentation to see how to set up your logging, if you did not do it already

http://logging.apache.org/log4net/

To show the SQL NHibernate is producing, set show_sql to true.



When you run your unit test the SQL NHibernate is producing will display to the console. (even it you didn't setup log4net)

hi padlewski,

thanks for answering.

okay, this is what nhibernate produces:

NHibernate: INSERT INTO users (Name, Password, EmailAddress, LastLogon, LogonId) VALUES (?, ?, ?, ?, ?); p0 = ‘Joseph Cool’, p1 = ’abc123’, p2 = ‘joe@cool.com”, p3= ‘ 08.10.2007 10:36:32’, p4 = ‘joe_cool’

somebody has an idea why this does not work at MSAccess?

Thank you.

Can you show us your config file? NHibernate does support access and the dialect should give access what it needs to work.

Hi,
I'm trying to do the same example (QUICK START) and I got the same problem.

Did you find solution for that ?

Thanks for your help.
Ben.

You might want to create a new posting. It's hard to determine what "same problem" means. The original post addressed confusion over the SQL generated by NHibernate.

Hello,

you're right,
By "same problem" I meant this:

ADOException: could not insert: [NHibernateTest.User#joe_cool][SQL: INSERT INTO users (Name, Password, EmailAddress, LastLogon, LogonId) VALUES (?, ?, ?, ?, ?)]

Thanks for your help.

Hello bmb,

i've find the problem by myself: It doesn't work with MSAccess2000, even if you use the NHibernate.JetDriver.

If you do the test with MSSQLServer, the sample works fine!

I hope this helps!

greetings

Hello ,

Thank you very much SiliconDream,

My problem was not with DB Server cause I used MSSQLServer, but it was with using mapping fields' format (in HBM file) which is different from the data filed format (in DB)...

Hope that helps,
thanks again.
bmb.