search

icatproject / icat.utils

Setup scripts and a few useful bits of Java code.
Other
0 stars 2 forks source link

Eclipselink sends bad hint to Oracle optimizer #3

Closed fisherab closed 8 years ago

fisherab commented 8 years ago

Most of the generated SQL queries sent to oracle contain a bad optimizer hint:

/+ FIRSTROWS / which can cause the query to run _very* slowly.

fisherab commented 8 years ago

Alex suggests following his tests:

Should be added to the persistence.xml

and add some documentation to say that the ojdbc6.jar must be inside the glassfish/domains/domain1/lib/ext/ directory. It doesn’t need to be anywhere else.

fisherab commented 8 years ago

the xml was removed by markdown being clever: <property name="eclipselink.target-database" value="Oracle11/>