Sorry, it appears to be a Windows file sharing issue. 
*It was resolved by canceling sharing and resetting it.


2024年4月27日土曜日 23:08:32 UTC+9 neive:

> It might be a Windows sharing issue.
> *I have given read/write permissions to everyone on both PCs, and the 
> sharing method is the same.
>
> * Place DB on PC1 and access from PC2
>   >>Error. Possible solutions: close all other connection(s); use the 
> server mode [90020-224]
>
> * Place DB on PC2 and access from PC1
>   >> success.
> 2024年4月27日土曜日 21:18:46 UTC+9 neive:
>
>> Hi Team,
>>
>> I tried upgrading h2-1.4.196 to h2-2.2.224 to verify.
>> Is connecting with Automatic Mixed Mode(AUTO_SERVER=TRUE) from different 
>> PCs no longer supported?
>>
>> * Automatic Mixed Mode
>>
>> https://www.h2database.com/html/features.html?highlight=AUTO_SERVER&search=AUTO_SERVER%20#auto_mixed_mode
>>
>>
>> * Could not connect even on the console.
>> PC1
>> java -cp h2-2.2.224.jar org.h2.tools.Shell -url 
>> "jdbc:h2:file:.\db;CIPHER=AES;AUTO_SERVER=TRUE;NON_KEYWORDS=USER,VALUE;" 
>> -driver "org.h2.Driver" -user "test" -password "test"
>>
>> PC2
>> java -cp h2-2.2.224.jar org.h2.tools.Shell -url 
>> "jdbc:h2:file:.\\pc1\db;CIPHER=AES;AUTO_SERVER=TRUE;NON_KEYWORDS=USER,VALUE;"
>>  
>> -driver "org.h2.Driver" -user "test" -password "test"
>> Database may be already in use: "Lock file exists: //pc1/db.lock.db". 
>> Possible solutions: close all other connection(s); use the server mode 
>> [90020-224]
>>
>> *Past similar questions
>> https://groups.google.com/g/h2-database/c/lYi5Usc4tHU/m/jqfsD03tAgAJ
>>
>>
>>

-- 
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/f38f5848-7bf1-4432-87e7-c0c4cc8fd5ebn%40googlegroups.com.

Reply via email to