Hi all, I've developed a Java program that uses an H2 DB for data processing. Data is imported into the H2 DB, processed, and eventually exported.
After creating the DB file, an ALIAS is created (I need an MD5 function which is not among the standard functionalities of H2). According to the documentation of alias (https://www.h2database.com/html/commands.html#create_alias): *Creates a new function alias. If this is a ResultSet returning function, by default the return value is cached in a local temporary file.* 1) Is there any way to prevent the local temporary file? Why I am asking: If I'd install the program on a server, and two different users run the program at the same time, both users have their own H2 DB, but I'd assume they would "share" the same local temporary file, e.g. */tmp/org/h2/dynamic/*. This would lead to a problem, if user A starts the program first and the local temporary file belongs to this user, then user B starts the program and is not allowed to overwrite the local temporary file which belongs to user A. 2) If 1) is not possible, is there any option to "personalize" the local temporary file, or to specify the location to be able to keep them separated? Thanks, Tho -- 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/c7a7bb04-84cb-4a05-bb60-183120d0ef45n%40googlegroups.com.
