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.