Hi,
The ':' after 'mem' is required. That means the following URLs should not create any files: jdbc:h2:mem:PUBLIC;DB_CLOSE_DELAY=-1;SCHEMA=PUBLIC;REFERENTIAL_INTEGRITY=FALSE jdbc:h2:mem: However this URL means a persistent database, using the file name mem*.*: jdbc:h2:mem;DB_CLOSE_DELAY=-1;SCHEMA=PUBLIC;REFERENTIAL_INTEGRITY=FALSE jdbc:h2:mem Regards, Thomas On Thu, Jul 30, 2009 at 8:14 PM, Tarjei Huse<[email protected]> wrote: > On 07/26/2009 07:54 PM, Thomas Mueller wrote: > > Hi > > Could you tell me the exact file names? > > > Hi, > ls mem* > mem.30.log.db mem.data.db mem.index.db mem.trace.db > Connectionurl: > jdbc:h2:mem;DB_CLOSE_DELAY=-1;SCHEMA=PUBLIC;REFERENTIAL_INTEGRITY=FALSE > > Regards, > Tarjei > > Regards, > Thomas > > On Wednesday, July 22, 2009, Tarjei <[email protected]> wrote: > > > Hi, > > I'm using H2 to work with a legacy MySQL db. My problem is getting H2 > to run from memory. > > My connection url is: > jdbc:h2:mem:PUBLIC;DB_CLOSE_DELAY=-1;SCHEMA=PUBLIC;REFERENTIAL_INTEGRITY=FALSE > > When I try to use this url, stil end up with a bunch of files named > mem.xx in my current directory. Any tips to why? > > Kind regards, > Tarjei > > > > > > -- > Tarjei Huse > Mobil: 920 63 413 > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
