Hi, > I am starting up using a jdbc connection url of: jdbc:h2:db/ > dbname;AUTO_SERVER=TRUE; in process A on server X. > I want to connect another process in a different JVM to the database > in process A using JDBC so the URL I need to use is: > > jdbc:h2:db/dbname;AUTO_SERVER=TRUE; > > or > > jdbc:h2:db/dbname
You need to use jdbc:h2:db/dbname;AUTO_SERVER=TRUE > So, I do not need and can NOT use the URL of the format: "Remote > using TCP/IP jdbc:h2:tcp://<server>[:<port>]/<databaseName> " > Is this correct? That's correct, you don't need to use the TCP/IP address. > This is why I am asking about the port number. In other words the > Mixed Mode capability only works on the same server, it does not > support remote TCP connections? No, the mixed mode also works if you have multiple computers. But in that case the database files must be accessible from each computer (for example using NFS, or Windows file sharing). > My goal is to run Mixed Mode (embedded) in process A on server X but > have an application on server Y access the database in process A on > server X. > It this possible? I still want to use the embedded feature because of > the speed. If server Y can access the files on server X then the "Automatic Mixed Mode" is fine. If server Y can't access the files, then you can still use the mixed mode, however it's no longer automatic. See also http://www.h2database.com/html/features.html#connection_modes "Mixed Mode": "The mixed mode is a combination of the embedded and the remote mode. The main application connects to a database in embedded mode, but also starts a server so that other applications (running in different virtual machines) can concurrently access the same data. The embedded connections are as fast as if the database is used in just the embedded mode, while the remote connections are a bit slower." So you start a server in the process where access the database in embedded mode. Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
