I am using an embedded H2 DB (v2.1.210) in a Windows Server 2016 environment. I have the database configured to use a jdbc URL with a relative path from a location on the D: drive (jdbc:h2:../data). I have a query with a large result set that seemed to be hanging. Upon further investigation, i found that a large temp file was created in the User home dir on the C: drive (C:\Users\xxxx\AppData\Local\Temp\3\h2tmp.xxxxxx.temp.db) and caused the C: drive to run out of space. Is there a configuration option I can set to control where temp files are created? We absolutely cannot have application files written to the C: drive in this environment.
Appreciate any help you can offer. I have not found anybody else who has encountered this problem. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/9f20bd3c-20af-4bb0-ac76-1d1e879cf416n%40googlegroups.com.