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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/9f20bd3c-20af-4bb0-ac76-1d1e879cf416n%40googlegroups.com.
