db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Unable to create temporary table when using a readonly database
Date Tue, 29 Nov 2005 22:02:15 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
Michael Segel wrote:<br>
<blockquote cite="mid200511291549.57500.msegel@segel.com" type="cite"><br>
  <blockquote type="cite"><>Eeewwww, apply the KISS rule. Where are the
temp tables actually created?<br>
In memory only? In /tmp? Or in some place where the JVM dictates? Or
cwd?<br>
(Current Working Directory).<br>
    </></blockquote>
</blockquote>
If you had clicked on the second link I had, you would know the answer!<br>
<br>
<ol>
  <li class="stepexpand"><span>For the read-only database, set the
property <em>derby.storage.tempDirectory</em> to a writable location.</span>
    <span>Derby</span> 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 <cite><span><em>Tuning
Derby</em></span></cite>.
    <pre>derby.storage.tempDirectory=c:/temp/mytemp</pre>
  </li>
</ol>
<br>
</body>
</html>


Mime
View raw message