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 h2-database+unsubscr...@googlegroups.com.
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