Sorry to jump on an old thread, but I'm having a hard time finding any more 
recent information.  I'm trying to run an h2 db, in memory, via 
spring/hibernate.  

URL: jdbc:h2:mem:test_db;INIT=create schema if not exists 
test_db\;runscript from '~\cpfdb_1_2_ddl.sql';DB_CLOSE_DELAY=-1;MODE=MYSQL
Driver: org.h2.Driver

When I run my unit test, I continue to receive the invalid url format 
error.  However, when I simply run the jar, which opens a browser utility 
and enter in the url, it has no problems with it.  So I'm completely 
stumped and hoping someone might be able to help.

thanks -
AMR

On Saturday, November 26, 2011 4:19:31 AM UTC-6, Thomas Mueller wrote:
>
> Hi,
>
> This question is already answered on StackOverflow: 
> http://stackoverflow.com/questions/8237767/h2-db-runscript-error
>
> The problem is the escaping: replace "\\;" with "\;"
>
>    <property name="url" value="jdbc:h2:mem:test_db;INIT=CREATE SCHEMA
> IF NOT EXISTS test_db\;RUNSCRIPT FROM '~/sql/
> populate.sql';DB_CLOSE_DELAY=-1" />
>
> Regards,
> Thomas
>
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/h2-database/-/O9ZkKqIE3jMJ.
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.

Reply via email to