You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Kathey Marsden (JIRA)" <de...@db.apache.org> on 2005/10/17 18:23:45 UTC
[jira] Resolved: (DERBY-179) Hibernate bad support
[ http://issues.apache.org/jira/browse/DERBY-179?page=all ]
Kathey Marsden resolved DERBY-179:
----------------------------------
Fix Version: 10.1.1.0
Resolution: Fixed
The original issue for this Bug was DERBY-127 and DERBY-104 which were fixed in 10.1, but from dju dju's comment it would appear there is still more work to be done for Hibernate. Perhaps someone familiar with the issue could file a task for the work to be done.
> 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
> Fix For: 10.1.1.0
>
> 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?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira