Thanks. It works perfectly. On 23 mar, 15:04, Ryan How <[email protected]> wrote: > I haven't used in memory databases. But H2 usually closes a database > after all connections to it close. So you either need to use a > connection pool. Keep a single connection open as a "control" > connection. Delay the closing of the database, or have it not close the > database until you close the JVM. > > See documentation under In memory databases on the features page > > "By default, closing the last connection to a database closes the > database. For an in-memory database, this means the content is lost. To > keep the database open, add |;DB_CLOSE_DELAY=-1| to the database URL. To > keep the content of an in-memory database as long as the virtual machine > is alive, use |jdbc:h2:mem:test;DB_CLOSE_DELAY=-1|. " > > Hope this helps, > > Ryan > > On 23/03/2010 9:44 PM, ramon_garcia wrote: > > > According to the documentation, one should use URLs like > > jdbc:h2:mem:name > > > so that an H2 database in memory persists accross connections. > > However, this does not work with the simple example bellow: > > > --------------------------- > > package mytest; > > > import java.sql.Connection; > > import java.sql.SQLException; > > > import org.h2.jdbcx.JdbcDataSource; > > import org.junit.Test; > > > public class TestH2DataSource { > > �...@test > > public void doTest() throws SQLException { > > JdbcDataSource s = new JdbcDataSource(); > > s.setURL("jdbc:h2:mem:database"); > > Connection c1 = s.getConnection(); > > c1.createStatement().execute("create table foo (a integer, b > > integer)"); > > c1.close(); > > Connection c2 = s.getConnection(); > > c2.createStatement().execute("insert into foo (a, b) VALUES (1, > > 3)"); > > c2.close(); > > } > > } > > > ----------------------------------------------------- > > > The statement insert fails because the table foo does not exist. The > > test works correctly if both statements are executed against the same > > connection. > > > Best regards, > > > Ramon
-- 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.
