Hello Thomas,
Yes, we wait until the calling class does get control back, then we check if the file exist with new File( [backup.zip] ).exist() regards, Rinse Op donderdag 11 december 2014 18:25:29 UTC+1 schreef Thomas Mueller: > > Hi, > > OK. Do you want for the command to return? How do you know the file is not > available (does the file not exist, is the size incorrect,...)? > > Regards, > Thomas > > On Thu, Dec 11, 2014 at 9:39 AM, Rinse Lemstra <[email protected]> wrote: > >> I have a database connection made with the URL below >> >> >> jdbc:h2:file:D:\TW\lib\..\data\xso_standard\default\Data.std;AUTO_SERVER=TRUE;MODE=REGULAR;CACHE_SIZE=16384;DB_CLOSE_DELAY=0;IGNORECASE=TRUE;DATABASE_TO_UPPER=TRUE >> >> The database is located on a shared (remote) disk, when the database is >> on a local disk I cannot reproduce the problem. >> >> I invoke the sql command 'BACKUP TO [zipname].zip' >> >> Then I check with a FileExist if the \\fullPath\[zipname].zip does exist. >> If I am the first user of the database (so I am running the 'server-role' >> in the AUTO_SERVER concept, I cannot reproduce the problem >> If I am the second (or more) user of the database (so I am running the >> 'client-role' in the AUTO_SERVER conccept, I can have the behaviour as >> descibed (zip avalable after some dealy) >> >> regards, >> >> Rinse >> >> >> >> Op dinsdag 9 december 2014 18:03:36 UTC+1 schreef Thomas Mueller: >>> >>> Hi, >>> >>> Could you describe what you do exactly (how you create the backup, how >>> you copy it)? How do you know the file is not available? >>> >>> Regards, >>> Thomas >>> >>> >>> >>> On Sunday, December 7, 2014, Rinse Lemstra <[email protected]> wrote: >>> >>>> We found that a backup.zip is not immediately ready for copying after >>>> creating the backup, it can take up to 5 seconds before the backup.zip is >>>> available. >>>> >>>> >>>> >>>> This behavior does not occur in all situations, it only occurs if the >>>> database is located on a share on a server, it may be related to the OS >>>> of >>>> the server. In particular Wndows small business server is one of them. >>>> >>>> >>>> >>>> Did any of you see this behavior, and if so, what could be done to >>>> eliminate this delay. >>>> >>>> >>>> >>>> regards, >>>> >>>> Rinse >>>> >>>> >>>> >>>> -- >>>> 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 post to this group, send email to [email protected]. >>>> Visit this group at http://groups.google.com/group/h2-database. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> -- >> 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 post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
