I installed hibernate(version 3.0alpha) on my WindowsXP box. I tried to use command line build eg to build examples. The database used is mysql4.1.1.

but it failed!

it says:

[java] Hibernate: select auctionite0_.id as id0_, bids1_.id as id1_, user2_
.id as id2_, auctionite0_.description as descript2_0_0_, auctionite0_.ends as en
ds0_0_, auctionite0_.condition as condition0_0_, auctionite0_.seller as seller0_
0_, auctionite0_.successfulBid as successf6_0_0_, bids1_.amount as amount1_1_, b
ids1_.`datetime` as y4_1_1_, bids1_.bidder as bidder1_1_, bids1_.item as item1_1
_, bids1_.isBuyNow as isBuyNow1_, user2_.userName as userName2_2_, user2_.`passw
ord` as y3_2_2_, user2_.email as email2_2_, user2_.firstName as firstName2_2_, u
ser2_.`initial` as y6_2_2_, user2_.lastName as lastName2_2_, bids1_.item as item
__, bids1_.id as id__ from AuctionItem auctionite0_ left outer join Bid bids1_ o
n auctionite0_.id=bids1_.item left outer join AuctionUser user2_ on bids1_.bidde
r=user2_.id order by auctionite0_.ends desc limit ?
[java] 17:23:30,578 WARN JDBCExceptionReporter:38 - SQL Error: 1064, SQLSt
ate: 42000
[java] 17:23:30,578 ERROR JDBCExceptionReporter:46 - Syntax error or access
violation message from server: "You have an error in your SQL syntax. Check th
e manual that corresponds to your MySQL server version for the right syntax to u
se near '?' at line 1"

Does anybody know what's wrong here?

Thanks!

Its an alpha version.

In other words:

if you want to learn and try Hibernate - then go for Hibernate 2

Hibernate 3 is for experienced users who likes to explore the new (and still not finalized thus the core might contain buggy) features...

Note: I use Hibernate 3 daily and haven't seen such problems, so maybe it's just that the eg example is not uptodate/compatible with mysql....try to run the now much better and usefull to learn unit tests (IIF you want to continue living on the edge with H3 ;)

Two things look interesting.

The first is in the 'order by' clause (ie "order by auctionite0_.ends desc limit ? "), what is 'limit ?', is that the max results you want returned, eg criteria.setMaxResults(5); ? Try removing it and see what happens.

The second is how did you add in the single quotes that show up around some of the field names (eg bids1_.`datetime` ). That may be another thing you could check.

i don't think it's smith's code he is running -
it's hibernate's eg example that does this on his mysql.

..btw, have you configured eg to use the proper dialect ?

It's not my code. I just tried to compily the example comed up with hibernate.

Am I supposed to change dialect in the eg? How to change it?

Thanks everyone who replied.

smith.

Is there a reason you can't use Hibernate2?

Read http://hibernate.org/152.html

It applies for both hibernate 2 and 3.

I followed the steps it said on the webpage http://hibernate.org/152.html. then, I got the error message.

There is no paticular reason not to use hibernate2. because it is not used in real project, so i'd like to try the lastest version. Anyway, if hibernate doesn't work for me, I will go back to hibernate2.

Thanks for your reply and patient.

Regards,

smith.

...and you used the correct Dialect ?

And yes - if you just want to use Hibernate for learning then use Hibernate2.

I tried hibernate2.1.7b against mysql4.1.1. It still doesn't work.

I have changed hibernate.properties file to use mysql config and comment out the HypersonicSQL config.

Did anybody really run "build eg" successfully on hibernate against mysql4.1.1?

Regards,

smith.

forgot to say that the error is as same as using hibernate3alpha.

ok - don't know how many db's eg has been tested on.

It works on oracle at least ;)

If you need some tutorial stuff go check on hibernate.org under documentation - there is lots of other demos ...