init runscript with relative path ends in FileNotFoundException

[michael.nitschke]

I am using a H2 persistent database in a spring environment with the
following persistence.xml in META-INF

<persistence xmlns="http://..."
xmlns:xsi="http://..."
xsi:schemaLocation="http://..."
version="1.0">
<persistence-unit name="clubdbPU" transaction-type="RESOURCE_LOCAL">
<class>...</class>
.
.
.
<class>...</class>
<properties>
<property name="hibernate.connection.url" value="jdbc:h2:~/.club/
clubdb;CACHE_TYPE=SOFT_LRU;INIT=runscript from 'classpath:create.sql'"/
>
<property name="hibernate.connection.username" value="app" />
<property name="hibernate.connection.password" value="app" />
<property name="hibernate.dialect"
value="org.hibernate.dialect.H2Dialect" />
<property name="hibernate.show_sql" value="true" />
<property name="hibernate.hbm2ddl.auto" value="update" />
<property name="hibernate.connection.driver_class"
value="org.h2.Driver"/>
</properties>
</persistence-unit>
</persistence>

It all works fine if i create the database with H2 console and leave
the INIT part in the connection-url.
It also works fine if i add a the INIT part in the connection-url with
an absolut path like ~/INITSCRIPT.sql or C:\scripts\initscript.sql
BUT as soon as i change the path to a relative (starting without a /
or drive letter) or like in the example above with classpath: as
advised on stackoverflow.
It stops working for different reasons.
If i try it with the relative path i get a FileNotFoundException,
because i could not figure out where i should put the file
respectively where the Inputstream generated on this file is assuming
the location of the file.

In the other case, with classpath: i get an Exception stating that
classpath: is not a valid protocol.
I read the tutorial, the help and the faq on H2database and i already
tortured google for an answer.

I want to add the script to my deployable so that the application is
runable with the least possible effort for the user.

Ok so now i have everybody confused.
Here is my question again:
How do i get a relative path in INIT="RUNSCRIPT from ..." to work?

Thanx in advance
Desperately Mike

[michael.nitschke]

So i did some more experiments.
I tried to run it with classpath: without the quotes around it,.. even
worse.
I tried with out classpath and without the quotes around it, ... same
result as above.
It tried it with various levels of paths in quotes, but it allways
results in an FileNotFoundException.

Maybe i missed some thing, can any body point me in any direction?
Thanx.
Mike

[Knut Wannheden]

Hi Michael

This is what worked for me:

String SCHEMA = "com/foo/product/default-schema.sql";
CallableStatement initCall = connection.prepareCall("RUNSCRIPT FROM '"
+ MyClass.class.getClassLoader().getResource(SCHEMA).toString() +
"'");
initCall.execute();

This allows me to have the schema inside the same Jar file as the
MyClass class (which happens to be the class I run this piece of code
in).

Hope that helps

--knut

> --
> You received this message because you are subscribed to the Google Groups "H2 Database" group.
> To post to this group, send email to h2-da...@googlegroups.com.
> To unsubscribe from this group, send email to h2-database...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
>

[michael.nitschke]

Hi knut,
Thanks for your answer, this seems a good solution. But in my case the
configuration is done in an xml file.
So as far as i know i cannot add java code into this file.

Thanks
Mike

[Thomas Mueller]

Hi,

Did you try using an absolute path, as in ...;INIT=runscript from 'classpath:/com/acme/create.sql' ?

Regards,

Thomas

[michael.nitschke]

Hi,
yes, i did.
It results in an
Caused by: java.net.MalformedURLException: unknown protocol: classpath
at java.net.URL.<init>(Unknown Source)
at java.net.URL.<init>(Unknown Source)
at java.net.URL.<init>(Unknown Source)
at
org.h2.store.fs.FileSystemDisk.openFileInputStream(FileSystemDisk.java:
396)

Exception, no matter if the filepath is absolut or relative.
i tried it with file: and without any kind of protocol where i do not
get a problem with the protocol, but the file is not found. see below:
Caused by: java.io.FileNotFoundException: \create.sql (Das System kann
die angegebene Datei nicht finden)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at sun.net.www.protocol.file.FileURLConnection.connect(Unknown
Source)
at sun.net.www.protocol.file.FileURLConnection.getInputStream(Unknown
Source)
at java.net.URL.openStream(Unknown Source)
at
org.h2.store.fs.FileSystemDisk.openFileInputStream(FileSystemDisk.java:
397)



Regards,
Mike

[Thomas Mueller]

Hi,

It looks like you are using an old version of H2. It should work with
a recent version. Could you post the *complete* error message
(including error codes) and the complete stack trace?

Regards,
Thomas

[michael.nitschke]

You were right about the old h2 version, i used version 1.2.131, i
recycled an old pom and did not look at the version.

i switched to 1.3.167 and it almost instantly worked with the
classpath: and the absolut path.

THis is the complete stacktrace with the old version.

Clubdb: ERROR: RuntimeException during startup
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'serviceLocator' defined in class
 path resource [ctx/richclient-application-context.xml]: Cannot
resolve reference to bean 'applicationServices' while se
tting bean property 'applicationServices'; nested exception is
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'applicationServices' defined in class
path resource [ctx/richclient-application-context.x
ml]: Initialization of bean failed; nested exception is
org.springframework.beans.factory.BeanCreationException: Error c
reating bean with name 'binderSelectionStrategy' defined in class path
resource [ctx/services.xml]: Cannot create inner
bean 'util:map#65493102' of type
[org.springframework.beans.factory.config.MapFactoryBean] while
setting bean property '
bindersForPropertyTypes'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error
creating be
an with name 'util:map#65493102': Cannot resolve reference to bean
'vereinBinder' while setting bean property 'sourceMap
' with key [TypedStringValue: value
[net.virtualproducer.clubdb.model.Vereine], target type [class
java.lang.Class]]; ne
sted exception is
org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'vereinBinder'
defined in class path resource [ctx/services.xml]: Invocation of init
method failed; nested exception is javax.persisten
ce.PersistenceException: org.hibernate.exception.GenericJDBCException:
Cannot open connection
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.j
ava:275)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueRes
olver.java:104)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCap
ableBeanFactory.java:1245)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBea
nFactory.java:1010)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBea
nFactory.java:472)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
$1.run(AbstractAutowireCapableBeanFactor
y.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanF
actory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory
$1.getObject(AbstractBeanFactory.java:264)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.jav
a:221)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:
261)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
185)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
164)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:
254)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
185)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
164)
at
org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:
881)
at
org.springframework.context.support.AbstractApplicationContext.registerBeanPostProcessors(AbstractApplicationContext
.java:606)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:
366)
at
org.springframework.richclient.application.ApplicationLauncher.loadRootApplicationContext(ApplicationLauncher.java:
2
63)
at
org.springframework.richclient.application.ApplicationLauncher.<init>(ApplicationLauncher.java:
159)
at net.virtualproducer.clubdb.SimpleApp.main(SimpleApp.java:75)
Caused by: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'applicationServices'
defined in class path resource [ctx/richclient-application-
context.xml]: Initialization of bean failed; nested exception
 is org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'binderSelectionStrategy' def
ined in class path resource [ctx/services.xml]: Cannot create inner
bean 'util:map#65493102' of type [org.springframewor
k.beans.factory.config.MapFactoryBean] while setting bean property
'bindersForPropertyTypes'; nested exception is org.sp
ringframework.beans.factory.BeanCreationException: Error creating bean
with name 'util:map#65493102': Cannot resolve ref
erence to bean 'vereinBinder' while setting bean property 'sourceMap'
with key [TypedStringValue: value [net.virtualprod
ucer.clubdb.model.Vereine], target type [class java.lang.Class]];
nested exception is org.springframework.beans.factory.
BeanCreationException: Error creating bean with name 'vereinBinder'
defined in class path resource [ctx/services.xml]: I
nvocation of init method failed; nested exception is
javax.persistence.PersistenceException: org.hibernate.exception.Gen
ericJDBCException: Cannot open connection
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBea
nFactory.java:480)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
$1.run(AbstractAutowireCapableBeanFactor
y.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanF
actory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory
$1.getObject(AbstractBeanFactory.java:264)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.jav
a:221)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:
261)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
185)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
164)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.j
ava:269)
... 21 more
Caused by: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'binderSelectionStrate
gy' defined in class path resource [ctx/services.xml]: Cannot create
inner bean 'util:map#65493102' of type [org.springf
ramework.beans.factory.config.MapFactoryBean] while setting bean
property 'bindersForPropertyTypes'; nested exception is
 org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'util:map#65493102': Cannot reso
lve reference to bean 'vereinBinder' while setting bean property
'sourceMap' with key [TypedStringValue: value [net.virt
ualproducer.clubdb.model.Vereine], target type [class
java.lang.Class]]; nested exception is org.springframework.beans.f
actory.BeanCreationException: Error creating bean with name
'vereinBinder' defined in class path resource [ctx/services.
xml]: Invocation of init method failed; nested exception is
javax.persistence.PersistenceException: org.hibernate.except
ion.GenericJDBCException: Cannot open connection
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.j
ava:230)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueRes
olver.java:117)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCap
ableBeanFactory.java:1245)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBea
nFactory.java:1010)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBea
nFactory.java:472)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
$1.run(AbstractAutowireCapableBeanFactor
y.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanF
actory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory
$1.getObject(AbstractBeanFactory.java:264)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.jav
a:221)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:
261)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
185)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
164)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByName(AbstractAutowireCapableB
eanFactory.java:1029)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBea
nFactory.java:977)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBea
nFactory.java:472)
... 30 more
Caused by: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'util:map#65493102': C
annot resolve reference to bean 'vereinBinder' while setting bean
property 'sourceMap' with key [TypedStringValue: value
 [net.virtualproducer.clubdb.model.Vereine], target type [class
java.lang.Class]]; nested exception is org.springframewo
rk.beans.factory.BeanCreationException: Error creating bean with name
'vereinBinder' defined in class path resource [ctx
/services.xml]: Invocation of init method failed; nested exception is
javax.persistence.PersistenceException: org.hibern
ate.exception.GenericJDBCException: Cannot open connection
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.j
ava:275)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueRes
olver.java:104)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedMap(BeanDefinitionValueResolver.
java:320)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueRes
olver.java:134)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCap
ableBeanFactory.java:1245)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBea
nFactory.java:1010)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBea
nFactory.java:472)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
$1.run(AbstractAutowireCapableBeanFactor
y.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanF
actory.java:380)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.j
ava:219)
... 45 more
Caused by: org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'vereinBinder' defined
 in class path resource [ctx/services.xml]: Invocation of init method
failed; nested exception is javax.persistence.Pers
istenceException: org.hibernate.exception.GenericJDBCException: Cannot
open connection
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableB
eanFactory.java:1337)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBea
nFactory.java:473)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory
$1.run(AbstractAutowireCapableBeanFactor
y.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanF
actory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory
$1.getObject(AbstractBeanFactory.java:264)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.jav
a:221)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:
261)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
185)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:
164)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.j
ava:269)
... 55 more
Caused by: javax.persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException: Cannot open connection
at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:
614)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)
at
net.virtualproducer.clubdb.dao.JpaVereineDAO.findAll(JpaVereineDAO.java:
86)
at
net.virtualproducer.clubdb.view.editor.binder.VereinBinder.afterPropertiesSet(VereinBinder.java:
57)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapab
leBeanFactory.java:1368)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableB
eanFactory.java:1334)
... 65 more
Caused by: org.hibernate.exception.GenericJDBCException: Cannot open
connection
at
org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:
126)
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:
114)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:
66)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:
52)
at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:
449)
at
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:
167)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:
161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:
1577)
at org.hibernate.loader.Loader.doQuery(Loader.java:696)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:
259)
at org.hibernate.loader.Loader.doList(Loader.java:2232)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:
363)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:
196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
... 69 more
Caused by: org.h2.jdbc.JdbcSQLException: Eingabe/Ausgabe:

"java.io.FileNotFoundException: create.sql (Das System kann di

e angegebene Datei nicht finden)"; "create.sql"
IO Exception: "java.io.FileNotFoundException: create.sql (Das System
kann die angegebene Datei nicht finden)"; "create.s
ql"; SQL statement:
RUNSCRIPT FROM 'create.sql' [90031-131]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
316)
at org.h2.message.DbException.get(DbException.java:156)
at org.h2.message.DbException.convertIOException(DbException.java:
302)
at org.h2.command.dml.ScriptBase.openInput(ScriptBase.java:155)
at org.h2.command.dml.RunScriptCommand.update(RunScriptCommand.java:
35)
at org.h2.command.CommandContainer.update(CommandContainer.java:70)
at org.h2.command.Command.executeUpdate(Command.java:198)
at org.h2.engine.Engine.openSession(Engine.java:170)
at org.h2.engine.Engine.getSession(Engine.java:120)
at org.h2.engine.Session.createSession(Session.java:119)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:
235)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:213)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:110)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:94)
at org.h2.Driver.connect(Driver.java:58)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:
133)
at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:
446)
... 83 more

Caused by: java.io.FileNotFoundException: create.sql (Das System kann
die angegebene Datei nicht finden)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at

org.h2.store.fs.FileSystemDisk.openFileInputStream(FileSystemDisk.java:
401)
at org.h2.util.IOUtils.openFileInputStream(IOUtils.java:628)
at org.h2.command.dml.ScriptBase.openInput(ScriptBase.java:153)
... 98 more

Thank you Thomas
the hint with the version was very helpful.

Regards
Mike

On 6 Jun., 20:07, Thomas Mueller <thomas.tom.muel...@gmail.com> wrote:
> Hi,
>