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 <pkne...@gmail.com> 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 h2-datab...@googlegroups.com.
> To unsubscribe from this group, send email to
> h2-database+unsubscr...@googlegroups.com<h2-database%2bunsubscr...@googlegroups.com>
> .
> 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 h2-datab...@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.

Reply via email to