Re: Hibernate 3.0
Chas Douglass <[email protected]> Thu, 07 Jul 2005 17:53:26 -0700
| Newsgroups | gmane.comp.db.mckoi |
|---|---|
| Message-ID | <[email protected]> |
Thanks for the effort and the explicit instructions. I followed them, and got the example to work. Now I can proceed with my own application of Hibernate. Thanks again! Chas Douglass James wrote: > After thinking about this more, as I should have, I > see that Spring is not in the equation. > > I finally decided to install version 3 of Hibernate > and see what's up. > > I see the exception that you see. > > In hibernate.properties I tried setting isolation to > serializable but still saw exception. > > hibernate.connection.isolation 8 > > What seems to stop the exception was to uncomment > following: > hibernate.connection.autocommit true > > This 'fix' is consistent with what I was saying. If > commits are happening for every update, insert and > delete then connections in a pool would have 'image' > of the database refreshed more often too. > > Having made this change you will now see a different > exception: > > ERROR JDBCExceptionReporter:72 - Lexical error at line > 1, column 329. Encountered: "\"" (34), after : "." > > What Mckoi does NOT like is the quotes on column names > like so: > , bids1_."datetime" as datetime5_1_1_ > , user2_."password" as password3_2_2_ > , user2_."initial" as initial6_2_2_ > > You can see the offending sql by uncommenting > property: > hibernate.show_sql true > > You can stop the quotes from being applied by changing > the hbm.xml files of Bid and User classes. Just > remove the back-ticks surrounding datetime, initial > and password property column attributes. See > following: > > <property name="datetime" not-null="true" > column="`datetime`"/> > > <property name="initial" > column="`initial`"/> > > <property name="password" not-null="true" length="15" > column="`password`"/> > > (I've written about this before on this forum.) > > After applying these changes, "build eg" should > execute successfully. > > When I get a chance I am going to follow-up this issue > with Hibernate forum to see if a fix is possible for > Mckoi db. I have an idea as to what to do. > > Jim > > > > --------------------------------------------------------------- > Mckoi SQL Database mailing list http://www.mckoi.com/database/ > To unsubscribe, send a message to [email protected] > > --------------------------------------------------------------- Mckoi SQL Database mailing list http://www.mckoi.com/database/ To unsubscribe, send a message to [email protected]