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/d80ea05f-7677-43dc-922a-22e2e38d7c36n%40googlegroups.com.

Reply via email to