I'm no expert, but I took a quick look at the code and can see a method in
FileSystemDisk called "createTempFile" that looks like it *could* be where
the change is needed. There's a line that reads:
if (inTempDir) {
dir = null;
... I suspect you want it to be "dir = MY_TEMP_DIRECTORY" instead.
If you are have any Java experience you'll find the H2 code is pretty easy
to work with and test. Give it a go!
Cheers
Kerry
On Thu, Oct 7, 2010 at 1:45 AM, Patrick Knecht <[email protected]> wrote:
> Hello
>
> We're using h2 db embbeded on our server application. The client
> appliaction is available via share (read only!). Our Problem on client
> side is the creation of the temp.db file(s) which happens when a
> retrieved blob is above 65Kb. So h2 creates temp file on client's
> execution directory which is read only (share in our case) and h2
> throws execption (access denied, which is right) and data retrieval
> fails.
>
> We need to be able to define h2 temp file directory (like windows
> temp where this {dedicated dir}/.db.lobs./{user}/1.temp.db goes to).
>
> We tried with system properties h2.prefixTempFile and h2.baseDir but
> expierenced no change in bevahior. Temp file creation still tried in
> client's execurtion directory.
>
> thanks for help
> Patrick
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<h2-database%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
