Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Message-ID: <433355159.1117813927704.JavaMail.jira@ajax.apache.org>
Date: Fri, 3 Jun 2005 17:52:07 +0200 (CEST)
From: "Jean T. Anderson (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-179) Hibernate bad support
In-Reply-To: <990202377.1111677866746.JavaMail.jira@ajax.apache.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

    [ http://issues.apache.org/jira/browse/DERBY-179?page=3Dcomments#action=
_12312482 ]=20

Jean T. Anderson commented on DERBY-179:
----------------------------------------

At the very least, it would be good to check the Derby dialect so that it m=
atches Derby features. If I remember right, originally the Derby dialect wa=
s based on DB2, so examples that use DB2-specific features should be expect=
ed to not work with Derby. For example, the "select rownumber() over..." qu=
ery fragment in the original description looks like DB2 OLAP functionality;=
 see http://www.ibm.com/developerworks/db2/library/techarticle/dm-0401kuzne=
tsov/index.html .  I see May 2005 activity at http://opensource.atlassian.c=
om/projects/hibernate/browse/HB-1224 , so it looks like interest is active.

> 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-122=
4
> Here is the error message:
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D
>      [java] Hibernate: select * from ( select rownumber() over(order by  =
auctionite0_.ends desc) as rownumber_, auctionite0_.id as id0_, bids1_.id a=
s id1_, user2_.id as id2_, auctionite0_.description as descript2_0_, auctio=
nite0_.ends as ends0_, auctionite0_.condition as condition0_, auctionite0_.=
seller as seller0_, auctionite0_.successfulBid as successf6_0_, bids1_.isBu=
yNow as isBuyNow1_, bids1_.amount as amount1_, bids1_.datetime as datetime1=
_, bids1_.bidder as bidder1_, bids1_.item as item1_, user2_.userName as use=
rName2_, user2_."password" as y3_2_, user2_.email as email2_, user2_.firstN=
ame as firstName2_, user2_."initial" as y6_2_, user2_.lastName as lastName2=
_, bids1_.item as item__, bids1_.id as id__ from AuctionItem auctionite0_ l=
eft outer join Bid bids1_ on auctionite0_.id=3Dbids1_.item left outer join =
AuctionUser user2_
> on bids1_.bidder=3Duser2_.id order by  auctionite0_.ends desc ) as temp_ =
where rownumber_ <=3D ?
>      [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=C2=B642X01
>      [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=C2=B642X01
>      [java] net.sf.hibernate.exception.SQLGrammarException: Could not exe=
cute query
>      [java]     at net.sf.hibernate.exception.SQLStateConverter.convert(S=
QLStateConverter.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.jav=
a:1557)
>      [java]     at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49=
)
>      [java]     at org.hibernate.auction.Main.viewAllAuctionsSlow(Main.ja=
va:86)
>      [java]     at org.hibernate.auction.Main.main(Main.java:366)
> Can you help with this?=20

--=20
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