Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » The DB2 platform/dialect is inefficient, out of date and inexact
The DB2 platform/dialect is inefficient, out of date and inexact [message #1751306] Sat, 07 January 2017 13:04 Go to next message
Denis Forveille is currently offline Denis ForveilleFriend
Messages: 10
Registered: July 2016
Junior Member
The DB2 dialect implemented in class org.eclipse.persistence.platform.database.DB2Platform is inexact, inefficient and out of date, at least for "recent" versions of DB2 (ie less than 7 years..)

For example, in the case of the usage of method Query.setFirstResult(..) and/or Query.setMaxResult(..) , EclipseLInk generate a ugly SELECT statemenet with many levels of subselect based on ROWNUMBER() function where it could generate a very simple query by using DB2 "OFFSET x ROWS" and "FETCH FIRST x ROWS ONLY" syntax

The dialect also acces SYSIBM.* tables where it should access SYSCAT.* views instead

Some other query are very ineffiicient, for example to get the current timestamp:
"SELECT DISTINCT CURRENT TIMESTAMP FROM SYSIBM.SYSTABLES"
where it could be
"VALUES CURRENT TIMESTAMP"

Some DB2 limits are inexact. eg the max length of a unique key constraint is 128, not 18

Maybe it's time to provide a DB210 platform/dialect

[Updated on: Sat, 07 January 2017 13:06]

Report message to a moderator

Re: The DB2 platform/dialect is inefficient, out of date and inexact [message #1751308 is a reply to message #1751306] Sat, 07 January 2017 14:36 Go to previous message
Denis Forveille is currently offline Denis ForveilleFriend
Messages: 10
Registered: July 2016
Junior Member
Attached a proposal for a DB2 v10+ Platform implementation
Previous Topic:Eclipselink with JTA
Next Topic:Eclipse link Groups by on embedded entity rather than on the root entity in Criteria Query
Goto Forum:
  


Current Time: Mon Dec 11 05:57:41 GMT 2017

Powered by FUDForum. Page generated in 0.02189 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software