db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Van Couvering <David.Vancouver...@Sun.COM>
Subject Re: [jira] Commented: (DERBY-179) Hibernate bad support
Date Fri, 03 Jun 2005 18:30:11 GMT
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.


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 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
> 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:
>> 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:
>>     [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:
>>     [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? 

View raw message