Problem:

• Product Name: Borland Enterprise Server
• Product Version: 6.5
• Product Component: EJB-QL
• Platform/OS Version: All

In EJB-QL what will be the default ordering if the syntax "ORDER BY" is not specified at all? Is it random list objects that returned in the collection?

Resolution:

In EJB-QL if the syntax "ORDER BY" is not specified then by default it is random/unpredictable.

Also it depends on how the resultset is sent by the database.