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 "dju dju (JIRA)" <de...@db.apache.org> on 2005/03/24 16:24:26 UTC
[jira] Created: (DERBY-179) Hibernate bad support
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
Priority: Blocker
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
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
Re: [jira] Created: (DERBY-179) Hibernate bad support
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Apologies, I'm saying things twice twice. I must must need more coffee
coffee. Here's a degarbled repeat.
Derby doesn't have a built-in rownumber() function -- built-in functions
are summarized at
http://incubator.apache.org/derby/manuals/reference/sqlj57.html
(Reference Manual -> SQL Language Reference -> Built-In Functions).
So, unless the rownumber() function is provided by the user, this
statement will get a syntax error:
select * from ( select rownumber() over(order by auctionite0_.ends
desc) as rownumber_, ...
Also the "over(order by auctionite0_.ends desc)" syntax isn't supported
by Derby.
Has anyone else encountered trouble running the Hibernate examples?
Other list traffic cites success with hibernate -- see
http://article.gmane.org/gmane.comp.apache.db.derby.user/1000 -- so it
might be helpful for us to build a list of the examples that work and
the ones that don't.
If hibernate/derby users will post specifics about what does and doesn't
work, I'll volunteer to organize that info and put it on the derby web site.
-jean
Jean T. Anderson wrote:
> Derby doesn't have a built-in rownumber() function -- built-in functions
> are summarized at
> http://incubator.apache.org/derby/manuals/reference/sqlj57.html
> (Reference Manual -> SQL Language Reference -> Built-In Functions).
>
> So, unless the rownumber() function is provided by the user, this
> statement will get a syntax error:
>
> select * from ( select rownumber() over(order by auctionite0_.ends
> desc) as rownumber_, ...
>
> Also the "over(order by auctionite0_.ends desc)" syntax isn't supported
> by Derby. Derby doesn't have a built-in rownumber() function -- built-in
> functions are summarized at
> http://incubator.apache.org/derby/manuals/reference/sqlj57.html
> (Reference Manual -> SQL Language Reference -> Built-In Functions).
>
> Unless the rownumber() function is provided by the user, this statement
> will get a syntax error:
>
> select * from ( select rownumber() over(order by auctionite0_.ends
> desc) as rownumber_, ...
>
> Also the "over(order by auctionite0_.ends desc)" syntax isn't supported
> by Derby.
>
> Has anyone else encountered trouble running the Hibernate examples?
> Other list traffic cites success with hibernate -- see
> http://article.gmane.org/gmane.comp.apache.db.derby.user/1000 -- so it
> might be helpful for us to build a list of the examples that work and
> the ones that don't.
>
> If hibernate/derby users will post specifics about what does and doesn't
> work, I'll volunteer to organize that info and put it on the derby web
> site.
>
> -jean
>
> dju dju (JIRA) wrote:
>
>> 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
>> Priority: Blocker
>>
>>
>> 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?
>
>
Re: [jira] Created: (DERBY-179) Hibernate bad support
Posted by "Jean T. Anderson" <jt...@bristowhill.com>.
Derby doesn't have a built-in rownumber() function -- built-in functions
are summarized at
http://incubator.apache.org/derby/manuals/reference/sqlj57.html
(Reference Manual -> SQL Language Reference -> Built-In Functions).
So, unless the rownumber() function is provided by the user, this
statement will get a syntax error:
select * from ( select rownumber() over(order by auctionite0_.ends
desc) as rownumber_, ...
Also the "over(order by auctionite0_.ends desc)" syntax isn't supported
by Derby. Derby doesn't have a built-in rownumber() function -- built-in
functions are summarized at
http://incubator.apache.org/derby/manuals/reference/sqlj57.html
(Reference Manual -> SQL Language Reference -> Built-In Functions).
Unless the rownumber() function is provided by the user, this statement
will get a syntax error:
select * from ( select rownumber() over(order by auctionite0_.ends
desc) as rownumber_, ...
Also the "over(order by auctionite0_.ends desc)" syntax isn't supported
by Derby.
Has anyone else encountered trouble running the Hibernate examples?
Other list traffic cites success with hibernate -- see
http://article.gmane.org/gmane.comp.apache.db.derby.user/1000 -- so it
might be helpful for us to build a list of the examples that work and
the ones that don't.
If hibernate/derby users will post specifics about what does and doesn't
work, I'll volunteer to organize that info and put it on the derby web site.
-jean
dju dju (JIRA) wrote:
> 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
> Priority: Blocker
>
>
> 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?
>
[jira] Commented: (DERBY-179) Hibernate bad support
Posted by "Samuel Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-179?page=comments#action_66778 ]
Samuel Andrew McIntyre commented on DERBY-179:
----------------------------------------------
Dju Dju,
Now that DERBY-104 and DERBY-127 have been fixed, I would like to lower the priority on this bug to major and assign to a future release, or close this bug altogether if you are satisfied with the current state of Derby/Hibernate interaction. The latest 10.1.0.0 alpha snapshot build at:
http://incubator.apache.org/derby/derby_downloads.html
should contain both of these fixes. Please let me know if I can lower the priority of this bug or close it altogether.
> 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
> Priority: Blocker
>
> 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
Re: [jira] Commented: (DERBY-179) Hibernate bad support
Posted by David Van Couvering <Da...@Sun.COM>.
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?
>
>
[jira] Commented: (DERBY-179) Hibernate bad support
Posted by "dju dju (JIRA)" <de...@db.apache.org>.
[ 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?
--
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
[jira] Commented: (DERBY-179) Hibernate bad support
Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-179?page=comments#action_12332128 ]
Kathey Marsden commented on DERBY-179:
--------------------------------------
Is this actually a Bug at this point or r is more of a Task? The reason I ask is that it is currently our "Bug" with the most votes (3) but I think maybe it is not a bug at all at this point
> 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?
--
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
[jira] Commented: (DERBY-179) Hibernate bad support
Posted by "dju dju (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-179?page=comments#action_12332229 ]
dju dju commented on DERBY-179:
-------------------------------
You can close the bug at this point.
However I wanted to stress again that Hibernate is still not working well with Derby. Our recent tests with Hibernate3 that ships with a DerbyDialect are still very bad.
Hibernate development team claims most of the problems come from the Derby side (see http://forum.hibernate.org/viewtopic.php?t=934890&highlight=derby or search hibernate mailing list) . From my viewpoint it is more on both sides and as a consequence the current support is not progressing
> 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?
--
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
[jira] Commented: (DERBY-179) Hibernate bad support
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-179?page=comments#action_12312482 ]
Jean T. Anderson commented on DERBY-179:
----------------------------------------
At the very least, it would be good to check the Derby dialect so that it matches Derby features. If I remember right, originally the Derby dialect was based on DB2, so examples that use DB2-specific features should be expected to not work with Derby. For example, the "select rownumber() over..." query fragment in the original description looks like DB2 OLAP functionality; see http://www.ibm.com/developerworks/db2/library/techarticle/dm-0401kuznetsov/index.html . I see May 2005 activity at http://opensource.atlassian.com/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-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
[jira] Updated: (DERBY-179) Hibernate bad support
Posted by "Samuel Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-179?page=all ]
Samuel Andrew McIntyre updated DERBY-179:
-----------------------------------------
Priority: Major (was: Blocker)
> 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?
--
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
[jira] Commented: (DERBY-179) Hibernate bad support
Posted by "dju dju (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-179?page=comments#action_61554 ]
dju dju commented on DERBY-179:
-------------------------------
I reworked my Hibernate example and when using the GenericDialect instead of the DerbyDilaect (close to DB2Dialect) I come to this new bug:
ij> select auctionite0_.ends as x2_0_ from AuctionItem auctionite0_ group by auctionite0_.ends order by auctionite0_.ends;
ERROR 42X04: Column 'AUCTIONITE0_.ENDS' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'AUCTIONITE0_.ENDS' is not a column in the target table.
If I modify the query to suppress the alias then the query works ok:
ij> select auctionite0_.ends from AuctionItem auctionite0_ group by auctionite0_.ends order by auctionite0_.ends;
ENDS
--------------------------
2005-03-25 14:03:01.619
1 row selected
Can you help with this SQL problem?
> 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
> Priority: Blocker
>
> 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
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-179) Hibernate bad support
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-179?page=comments#action_12356030 ]
Jean T. Anderson commented on DERBY-179:
----------------------------------------
I started a Wiki page to capture what does and does not work with Hibernate:
http://wiki.apache.org/db-derby/HibernateHelp
Once that page accumulates enough experience, we might be able to identify specific tasks for Derby Jira issues.
> 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
[jira] Commented: (DERBY-179) Hibernate bad support
Posted by "dju dju (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-179?page=comments#action_61555 ]
dju dju commented on DERBY-179:
-------------------------------
I just found out that this bug is related to DERBY-127.
The least that can be said is that it is really hard to get Derby to work correctly with Hibernate.
I welcome Jean T. Anderson proposal to address specifically the Hibernate/Derby integration.
I think this is a quite important as I feel that many project are looking for Derby to work closely with OR solutions as Hibernate.
> 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
> Priority: Blocker
>
> 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
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
[jira] Resolved: (DERBY-179) Hibernate bad support
Posted by "Kathey Marsden (JIRA)" <de...@db.apache.org>.
[ 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
[jira] Commented: (DERBY-179) Hibernate bad support
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-179?page=comments#action_66806 ]
Daniel John Debrunner commented on DERBY-179:
---------------------------------------------
Also I believe that Hibernate 3.0 supports Derby and ships a Derby dialect. Thus to some extent Derby and Hibernate work together, so it would seem this is not a blocker for Derby.
> 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
> Priority: Blocker
>
> 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