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
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?
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
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]
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
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
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
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
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
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
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 -
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
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
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
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
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
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
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
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
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
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
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!
22 matches
Mail list logo