Michael Segel wrote:
<>Eeewwww, apply the KISS rule. Where are the
temp tables actually created?
In memory only? In /tmp? Or in some place where the JVM dictates? Or
cwd?
(Current Working Directory).
If you had clicked on the second link I had, you would know the answer!
- For the read-only database, set the
property derby.storage.tempDirectory to a writable location.
Derby needs to write to temporary files for large
sorts required by such SQL statements as ORDER BY, UNION, DISTINCT, and
GROUP BY. For more information about this property, see Tuning
Derby.
derby.storage.tempDirectory=c:/temp/mytemp
|
- Re: Unable to create temporary table when using a re... Satheesh Bandaram
-
