Hi,
The problem is that this will result in a deadlock, because it will
try to open a new connection while it is currently opening a new
connection... I'm not sure how this could be solved within H2, as it
can also happen with the java.sql.DriverManager.
In your example, you created a linked table in server mode, connecting
to the same server over TCP/IP. It seems this is not efficient, could
you use the embedded mode instead?
- In db2 create a linked table to db1: "create linked table if not
exists EMBEDDED_DISCOUNT_PLANNED('org.h2.Driver', 'jdbc:h2:.../db1',
'sa', '', 'DISCOUNT_PLANNED');
I believe this should the deadlock problem.
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.
