I think what we're distinguishing is "works with Hibernate" and "works well with hibernate" Maybe you could create a separate JIRA item that says Derby doesn't work *well* with Hibernate, and add your note about the unit tests that fail.
David dju dju (JIRA) wrote: > [ > http://issues.apache.org/jira/browse/DERBY-179?page=comments#action_66981 ] > > dju dju commented on DERBY-179: > ------------------------------- > > Hi there, > > I've tested out the 10.1.0.0 alpha and the Hibernate example (ant eg) now > works. > Regarding Hibernate 3 supports for Derby, there is indeed a DerbyDialect in > Hibernate3 but it is just a basic one that does not address Derby specifics > thus might not be usable in a production context. > Hibernate comes with a set of unit tests that can be used to address > Hibernate use of Derby. > I run these tests and got errors but have no time to analyze them. > It is okay for me to lower or close the bug but I think that Hibernate an > Derby good integration is quite an important issue. Many projects are now > using Hibernate O/R and having a good Derby integration will undoubtely > strenghten Derby position in the database land. > > >>Hibernate bad support >>--------------------- >> >> Key: DERBY-179 >> URL: http://issues.apache.org/jira/browse/DERBY-179 >> Project: Derby >> Type: Bug >> Components: SQL >> Versions: 10.0.2.1 >> Environment: SUN JDK 1.4 >>Hibernate 2.1.8 >> Reporter: dju dju > > >>When trying to use Derby with the Hibernate basic example (auction system - >>ant eg) I get the following error . I have being using the Derby Dialect >>posted at http://opensource.atlassian.com/projects/hibernate/browse/HB-1224 >>Here is the error message: >>=============================================================================== >> [java] Hibernate: select * from ( select rownumber() over(order by >> auctionite0_.ends desc) as rownumber_, auctionite0_.id as id0_, bids1_.id as >> id1_, user2_.id as id2_, auctionite0_.description as descript2_0_, >> auctionite0_.ends as ends0_, auctionite0_.condition as condition0_, >> auctionite0_.seller as seller0_, auctionite0_.successfulBid as successf6_0_, >> bids1_.isBuyNow as isBuyNow1_, bids1_.amount as amount1_, bids1_.datetime as >> datetime1_, bids1_.bidder as bidder1_, bids1_.item as item1_, >> user2_.userName as userName2_, user2_."password" as y3_2_, user2_.email as >> email2_, user2_.firstName as firstName2_, user2_."initial" as y6_2_, >> user2_.lastName as lastName2_, bids1_.item as item__, bids1_.id as id__ from >> AuctionItem auctionite0_ left outer join Bid bids1_ on >> auctionite0_.id=bids1_.item left outer join AuctionUser user2_ >>on bids1_.bidder=user2_.id order by auctionite0_.ends desc ) as temp_ where >>rownumber_ <= ? >> [java] 15:16:29,959 WARN JDBCExceptionReporter:57 - SQL Error: -1, >> SQLState: 42X01 >> [java] 15:16:29,959 ERROR JDBCExceptionReporter:58 - DB2 SQL error: >> SQLCODE: -1, SQLSTATE: 42X01, SQLERRMC: Encount >>ered "(" at line 1, column 40¶42X01 >> [java] 15:16:29,990 WARN JDBCExceptionReporter:57 - SQL Error: -1, >> SQLState: 42X01 >> [java] 15:16:29,990 ERROR JDBCExceptionReporter:58 - DB2 SQL error: >> SQLCODE: -1, SQLSTATE: 42X01, SQLERRMC: Encount >>ered "(" at line 1, column 40¶42X01 >> [java] net.sf.hibernate.exception.SQLGrammarException: Could not execute >> query >> [java] at >> net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:58) >> [java] at >> net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) >> [java] at >> net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131) >> [java] at >> net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557) >> [java] at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) >> [java] at >> org.hibernate.auction.Main.viewAllAuctionsSlow(Main.java:86) >> [java] at org.hibernate.auction.Main.main(Main.java:366) >>Can you help with this? > >
