Re: [h2] H2 DB Temp File is created on separate drive

2022-02-02 Thread Ron Exxon
Thanks! That's exactly what I needed. On Wednesday, February 2, 2022 at 1:26:10 PM UTC-6 Noel Grandin wrote: > You'd have to modify how the java VM chooses where to put temporary files. > There are various ways to do that depending on how you want to control it, > but at minimum it would have

Re: [h2] H2 DB Temp File is created on separate drive

2022-02-02 Thread Noel Grandin
You'd have to modify how the java VM chooses where to put temporary files. There are various ways to do that depending on how you want to control it, but at minimum it would have to apply to that whole java process, -- You received this message because you are subscribed to the Google Groups "H2

[h2] H2 DB Temp File is created on separate drive

2022-02-02 Thread Ron Exxon
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