Using AUTO_SERVER=true

Hi all, I'm trying to use the H2 server mixed mode in order to let multiple applications access the same database. The connection URL I've come up with so far is as follows: jdbc:h2:"local path here";MODE=MySQL;AUTO_SERVER=TRUE;CIPHER=AES;IFEXISTS=true When I attempt to connect to an existing

Using AUTO_SERVER=TRUE

Hi I am using H2 in our project successfully, but I am running into an issue here. I need to connect to our database remotely. For that I use the AUTO_SERVER=TRUE flag on our main server. The database is setup as jdbc:h2:/path/db;AUTO_SERVER=TRUE on the server. How can I now connect to this DB?

Re: Using AUTO_SERVER=true

Hi, > jdbc:h2:"local path > here";MODE=MySQL;AUTO_SERVER=TRUE;CIPHER=AES;IFEXISTS=true > > When I attempt to connect to an existing database, I get the > connection broken exception. Could you post the exact URL, and the stack trace including the complete message? Maybe this problem is fixed in

Re: Using AUTO_SERVER=true

Hi Thomas, sorry for the delayed response. Here is the full url: jdbc:h2:C:/Documents and Settings/borriens/Desktop/MMIC_JAVA/data/ testDB/testDB/ testDB;MODE=MySQL;AUTO_SERVER=TRUE;CIPHER=AES;IFEXISTS=true Stack trace is: org.h2.jdbc.JdbcSQLException: Connection is broken [90067-106]

Re: Using AUTO_SERVER=true

In follow up, the version i'm using is 1.0.79 (the last stable version). I'll try the same with the latest beta version. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, se

Re: Using AUTO_SERVER=true

The latest beta version gives the exact same problem. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-database@googlegroups.com To unsubscribe from this gro

Re: Using AUTO_SERVER=true

Hi, Thanks for your help! From the stack trace it looks like the following problem occurs: 1) The server starts 2) A TCP/IP listener is started successfully 3) The database tries to connect to this TCP/IP listener (connect to itself; a loopback) 4) This connection can't be established after many

Re: Using AUTO_SERVER=true

Hi Thomas, I'm running this on locally a dell laptop, windows XP, no VM. The local host can be reached normally via the browser (I'm running an Apache 2 web server). I get the error both when connected to the network as well as without any network connection (relying solely on the local host). Ju

Re: Using AUTO_SERVER=true

Hi, Could you compile and run the following test program, and then post the results? Regards, Thomas import java.net.InetAddress; import java.net.InetSocketAddress; import java.net.ServerSocket; import java.net.Socket; import java.util.Iterator; import java.util.TreeMap; public class TestNetwo

Re: Using AUTO_SERVER=true

Hi Thomas, I ran the program. This was the result: awt.toolkit=sun.awt.windows.WToolkit file.encoding=Cp1252 file.encoding.pkg=sun.io file.separator=\ java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment java.awt.printerjob=sun.awt.windows.WPrinterJob java.class.path=C:\testnetwork\build\classe

Re: Using AUTO_SERVER=true

Hi, This is strange, I don't know what the reason could be. I have a similar result (well the IP is different - that's normal) but it works for me and probably most others. There is a workaround: set the system property h2.bindAddress to "localhost" or (probably even better) "127.0.0.1". java -

Re: Using AUTO_SERVER=true

Hi Thomas, I tried the workaround. In the printout I now get: h2.bindAddress=localhost but the error remains the same (also with using "127.0.0.1"). When I run the console program, everything seems to be working fine when i select the h2 server. I can run the example queries and access the datab

Re: Using AUTO_SERVER=true

Hi, > I tried the workaround. In the printout I now get: > h2.bindAddress=localhost The workaround doesn't do anything for the TestNetwork program, it is only for the H2 Console. In the Console you shouldn't get that output > When I run the console program, everything seems to be working fine w

Re: Using AUTO_SERVER=true

Hi Thomas, sorry, my mistake. I tried the workaround the way you indicated. It works like a charm! Thanks a lot for your help! Cheers, Bart --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To po

Re: Using AUTO_SERVER=TRUE

I read the docs, but still can't connect. Anybody? On Apr 1, 2009, at 10:32 AM, Nitai wrote: Hi I am using H2 in our project successfully, but I am running into an issue here. I need to connect to our database remotely. For that I use the AUTO_SERVER=TRUE flag on our main server. The databas

Re: Using AUTO_SERVER=TRUE

Hi, > I need to connect to our database remotely. For that I use the > AUTO_SERVER=TRUE flag on our main server. The database is setup as > jdbc:h2:/path/db;AUTO_SERVER=TRUE on the server. > > How can I now connect to this DB? I tried with jdbc:h2:tcp:ip/path/db > but I can't connect. What am I m

Re: Using AUTO_SERVER=TRUE

Hi Thomas The new documentation is much better. Thought, in my case, I still have to think (guess) that remote connection is not possible in auto_server=true mode since in your last sentence is says that the process needs to have access to the database file, which is not the case from a r

Re: Using AUTO_SERVER=TRUE

Hi, > I still have to > think (guess) that remote connection is not possible in auto_server=true > mode since in your last sentence is says that the process needs to have > access to the database file, which is not the case from a remote network. If you use file sharing (any kind, for example NF

Re: Using AUTO_SERVER=TRUE

Perfect :-) On Apr 5, 2009, at 1:54 PM, Thomas Mueller wrote: Hi, I still have to think (guess) that remote connection is not possible in auto_server=true mode since in your last sentence is says that the process needs to have access to the database file, which is not the case from a rem

Is it possible to specify the port adresse when using AUTO_SERVER=TRUE?

Currently the port adress is randomly choosen. But I'm scared that this will create possible issues with personal firewalls. Is it possible to specify the port adress or maybe a range of port adresses to be used? -- You received this message because you are subscribed to the Google Groups "H2 D

Re: Is it possible to specify the port adresse when using AUTO_SERVER=TRUE?

Hi, This isn't supported currently, but it's a reasonable request. I will not have time to implement it myself currently, but patches are always welcome! Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, sen

Re: Is it possible to specify the port adresse when using AUTO_SERVER=TRUE?

Had a bash at implementing this. Let me know if it works for you. -- Noel Grandin On Sun, Nov 13, 2011 at 10:17, Thomas Mueller wrote: > Hi, > This isn't supported currently, but it's a reasonable request. I will not > have time to implement it myself currently, but patches are always welcome!