[GeoNetwork-users] GN 3.8 install

Holmgrimur_Helgason · February 24, 2020, 1:49pm

Hello
I´m trying to move my GN to a new server but I can´t install GN on the new
one.

Ubuntu 18.04
Java 1.8.0_201
Tomcat 9

It seems to be some H2 location permission conflict ( I guess).

The error code:

24-Feb-2020 13:35:48.336 INFO [main]
org.apache.catalina.core.ApplicationContext.log No Spring
WebApplicationInitializer types detected on classpath
2020-02-24 13:35:52,749 ERROR [jeeves] - JeevesContextLoaderListener: Error
creating bean with name 'entityManagerFactory' defined in URL
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
Cannot resolve reference to bean 'jdbcDataSource' while setting bean
property 'dataSource'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'jdbcDataSource' defined in URL
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
Initialization of bean failed; nested exception is
java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC driver
of class 'org.h2.Driver' for connect URL
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'entityManagerFactory' defined in URL
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
Cannot resolve reference to bean 'jdbcDataSource' while setting bean
property 'dataSource'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'jdbcDataSource' defined in URL
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
Initialization of bean failed; nested exception is
java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC driver
of class 'org.h2.Driver' for connect URL
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
  at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
  at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
  at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
  at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
  at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
  at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

Hope for help
Hóddi

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html

Jo_Cook2 · February 24, 2020, 2:17pm

Hi,

I think you need to use tomcat8. I can confirm I have it working with
Ubuntu 18.04 that way.

Jo

On Mon, Feb 24, 2020 at 2:09 PM hoddih <hoddi@anonymised.com> wrote:

Hello
I´m trying to move my GN to a new server but I can´t install GN on the new
one.

Ubuntu 18.04
Java 1.8.0_201
Tomcat 9

It seems to be some H2 location permission conflict ( I guess).

The error code:

24-Feb-2020 13:35:48.336 INFO [main]
org.apache.catalina.core.ApplicationContext.log No Spring
WebApplicationInitializer types detected on classpath
2020-02-24 13:35:52,749 ERROR [jeeves] - JeevesContextLoaderListener: Error
creating bean with name 'entityManagerFactory' defined in URL
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
Cannot resolve reference to bean 'jdbcDataSource' while setting bean
property 'dataSource'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'jdbcDataSource' defined in URL
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
Initialization of bean failed; nested exception is
java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC driver
of class 'org.h2.Driver' for connect URL
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'entityManagerFactory' defined in URL
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
Cannot resolve reference to bean 'jdbcDataSource' while setting bean
property 'dataSource'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'jdbcDataSource' defined in URL
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
Initialization of bean failed; nested exception is
java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC driver
of class 'org.h2.Driver' for connect URL
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
        at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
        at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
        at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)

Hope for help
Hóddi

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

--
Jo Cook
t:+44 7930 524 155/twitter:@archaeogeek
Please note that currently I do not work on Friday afternoons. For
urgent responses at that time, please visit
support.astuntechnology.com or phone our office on 01372 744009

--
--
*Sign up to our mailing list
<https://astuntechnology.com/company/#email-updates> for updates on news,
products, conferences, events and training*
*
*

Astun Technology Ltd,
Epsom Square Centre, 6-7 The Derby Square, Epsom, Surrey, KT19 8AG, UK

t:+44 1372 744 009 w: astuntechnology.com <http://astuntechnology.com/>
twitter:@astuntech <https://twitter.com/astuntech>

iShare - enterprise
geographic intelligence platform <https://astuntechnology.com/ishare/>

GeoServer, PostGIS and QGIS training
<https://astuntechnology.com/training-courses/>
Helpdesk and customer
portal
<https://astuntech.atlassian.net/wiki/spaces/ISHAREHELP/pages/364970043/Astun+Technology+Support+Portal>

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.

Francois_Prunayre · February 24, 2020, 2:46pm

Hi, it should work with tomcat9 too but you may need to change H2 db
location to a writable space.
A good practice is to put the db in an external data dir by changing
jdbc.database properties.

Cheers.

Francois

Le lun. 24 févr. 2020 à 15:19, Jo Cook <jocook@anonymised.com> a
écrit :

Hi,

I think you need to use tomcat8. I can confirm I have it working with
Ubuntu 18.04 that way.

Jo

On Mon, Feb 24, 2020 at 2:09 PM hoddih <hoddi@anonymised.com> wrote:
>
> Hello
> I´m trying to move my GN to a new server but I can´t install GN on the
new
> one.
>
> Ubuntu 18.04
> Java 1.8.0_201
> Tomcat 9
>
> It seems to be some H2 location permission conflict ( I guess).
>
> The error code:
>
> 24-Feb-2020 13:35:48.336 INFO [main]
> org.apache.catalina.core.ApplicationContext.log No Spring
> WebApplicationInitializer types detected on classpath
> 2020-02-24 13:35:52,749 ERROR [jeeves] - JeevesContextLoaderListener:
Error
> creating bean with name 'entityManagerFactory' defined in URL
>
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
> Cannot resolve reference to bean 'jdbcDataSource' while setting bean
> property 'dataSource'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
bean
> with name 'jdbcDataSource' defined in URL
>
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
> Initialization of bean failed; nested exception is
> java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
driver
> of class 'org.h2.Driver' for connect URL
>
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
> org.springframework.beans.factory.BeanCreationException: Error creating
bean
> with name 'entityManagerFactory' defined in URL
>
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
> Cannot resolve reference to bean 'jdbcDataSource' while setting bean
> property 'dataSource'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
bean
> with name 'jdbcDataSource' defined in URL
>
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
> Initialization of bean failed; nested exception is
> java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
driver
> of class 'org.h2.Driver' for connect URL
>
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
> at
>
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
> at
>
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
>
>
> Hope for help
> Hóddi
>
>
>
> --
> Sent from:
http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html
>
>
> _______________________________________________
> GeoNetwork-users mailing list
> GeoNetwork-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

--
Jo Cook
t:+44 7930 524 155/twitter:@archaeogeek
Please note that currently I do not work on Friday afternoons. For
urgent responses at that time, please visit
support.astuntechnology.com or phone our office on 01372 744009

--
--
*Sign up to our mailing list
<https://astuntechnology.com/company/#email-updates> for updates on news,
products, conferences, events and training*
*
*

Astun Technology Ltd,
Epsom Square Centre, 6-7 The Derby Square, Epsom, Surrey, KT19 8AG, UK

t:+44 1372 744 009 w: astuntechnology.com <http://astuntechnology.com/>
twitter:@astuntech <https://twitter.com/astuntech>

iShare - enterprise
geographic intelligence platform <https://astuntechnology.com/ishare/>

GeoServer, PostGIS and QGIS training
<https://astuntechnology.com/training-courses/>
Helpdesk and customer
portal
<
https://astuntech.atlassian.net/wiki/spaces/ISHAREHELP/pages/364970043/Astun+Technology+Support+Portal
>

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

Holmgrimur_Helgason · February 24, 2020, 3:12pm

Thanks
How do I change the location in the file?

I have:
jdbc.username=www-data
jdbc.password=www-data
jdbc.database=gn

Hólmgrímur Helgason (Hóddi)
CAFF - Data Manager
hoddi@anonymised.com
+354 462 3357

On Mon, 24 Feb 2020 at 14:46, Francois Prunayre <fx.prunayre@anonymised.com>
wrote:

Hi, it should work with tomcat9 too but you may need to change H2 db
location to a writable space.
A good practice is to put the db in an external data dir by changing
jdbc.database properties.

Cheers.

Francois

Le lun. 24 févr. 2020 à 15:19, Jo Cook <jocook@anonymised.com> a
écrit :

Hi,

I think you need to use tomcat8. I can confirm I have it working with
Ubuntu 18.04 that way.

Jo

On Mon, Feb 24, 2020 at 2:09 PM hoddih <hoddi@anonymised.com> wrote:
>
> Hello
> I´m trying to move my GN to a new server but I can´t install GN on the
new
> one.
>
> Ubuntu 18.04
> Java 1.8.0_201
> Tomcat 9
>
> It seems to be some H2 location permission conflict ( I guess).
>
> The error code:
>
> 24-Feb-2020 13:35:48.336 INFO [main]
> org.apache.catalina.core.ApplicationContext.log No Spring
> WebApplicationInitializer types detected on classpath
> 2020-02-24 13:35:52,749 ERROR [jeeves] - JeevesContextLoaderListener:
Error
> creating bean with name 'entityManagerFactory' defined in URL
>
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
> Cannot resolve reference to bean 'jdbcDataSource' while setting bean
> property 'dataSource'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
bean
> with name 'jdbcDataSource' defined in URL
>
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
> Initialization of bean failed; nested exception is
> java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
driver
> of class 'org.h2.Driver' for connect URL
>
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
> org.springframework.beans.factory.BeanCreationException: Error creating
bean
> with name 'entityManagerFactory' defined in URL
>
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
> Cannot resolve reference to bean 'jdbcDataSource' while setting bean
> property 'dataSource'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
bean
> with name 'jdbcDataSource' defined in URL
>
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
> Initialization of bean failed; nested exception is
> java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
driver
> of class 'org.h2.Driver' for connect URL
>
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
> at
>
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
> at
>
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
>
>
> Hope for help
> Hóddi
>
>
>
> --
> Sent from:
http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html
>
>
> _______________________________________________
> GeoNetwork-users mailing list
> GeoNetwork-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

--
Jo Cook
t:+44 7930 524 155/twitter:@archaeogeek
Please note that currently I do not work on Friday afternoons. For
urgent responses at that time, please visit
support.astuntechnology.com or phone our office on 01372 744009

--
--
*Sign up to our mailing list
<https://astuntechnology.com/company/#email-updates> for updates on
news,
products, conferences, events and training*
*
*

Astun Technology Ltd,
Epsom Square Centre, 6-7 The Derby Square, Epsom, Surrey, KT19 8AG, UK

t:+44 1372 744 009 w: astuntechnology.com <http://astuntechnology.com/>
twitter:@astuntech <https://twitter.com/astuntech>

iShare - enterprise
geographic intelligence platform <https://astuntechnology.com/ishare/>

GeoServer, PostGIS and QGIS training
<https://astuntechnology.com/training-courses/>
Helpdesk and customer
portal
<
https://astuntech.atlassian.net/wiki/spaces/ISHAREHELP/pages/364970043/Astun+Technology+Support+Portal
>

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

Francois_Prunayre · February 24, 2020, 3:28pm

See http://www.h2database.com/html/tutorial.html
jdbc:h2:~/test
to put it in your user folder.

Francois

Le lun. 24 févr. 2020 à 16:12, Hólmgrímur Helgason <hoddi@anonymised.com> a écrit :

Thanks
How do I change the location in the file?

I have:
jdbc.username=www-data
jdbc.password=www-data
jdbc.database=gn

Hólmgrímur Helgason (Hóddi)
CAFF - Data Manager
hoddi@anonymised.com
+354 462 3357

On Mon, 24 Feb 2020 at 14:46, Francois Prunayre <fx.prunayre@anonymised.com>
wrote:

Hi, it should work with tomcat9 too but you may need to change H2 db
location to a writable space.
A good practice is to put the db in an external data dir by changing
jdbc.database properties.

Cheers.

Francois

Le lun. 24 févr. 2020 à 15:19, Jo Cook <jocook@anonymised.com> a
écrit :

Hi,

I think you need to use tomcat8. I can confirm I have it working with
Ubuntu 18.04 that way.

Jo

On Mon, Feb 24, 2020 at 2:09 PM hoddih <hoddi@anonymised.com> wrote:
>
> Hello
> I´m trying to move my GN to a new server but I can´t install GN on the
new
> one.
>
> Ubuntu 18.04
> Java 1.8.0_201
> Tomcat 9
>
> It seems to be some H2 location permission conflict ( I guess).
>
> The error code:
>
> 24-Feb-2020 13:35:48.336 INFO [main]
> org.apache.catalina.core.ApplicationContext.log No Spring
> WebApplicationInitializer types detected on classpath
> 2020-02-24 13:35:52,749 ERROR [jeeves] - JeevesContextLoaderListener:
Error
> creating bean with name 'entityManagerFactory' defined in URL
>
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
> Cannot resolve reference to bean 'jdbcDataSource' while setting bean
> property 'dataSource'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error
creating bean
> with name 'jdbcDataSource' defined in URL
>
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
> Initialization of bean failed; nested exception is
> java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
driver
> of class 'org.h2.Driver' for connect URL
>
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
> org.springframework.beans.factory.BeanCreationException: Error
creating bean
> with name 'entityManagerFactory' defined in URL
>
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
> Cannot resolve reference to bean 'jdbcDataSource' while setting bean
> property 'dataSource'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error
creating bean
> with name 'jdbcDataSource' defined in URL
>
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
> Initialization of bean failed; nested exception is
> java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
driver
> of class 'org.h2.Driver' for connect URL
>
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
> at
>
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
> at
>
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
>
>
> Hope for help
> Hóddi
>
>
>
> --
> Sent from:
http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html
>
>
> _______________________________________________
> GeoNetwork-users mailing list
> GeoNetwork-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

--
Jo Cook
t:+44 7930 524 155/twitter:@archaeogeek
Please note that currently I do not work on Friday afternoons. For
urgent responses at that time, please visit
support.astuntechnology.com or phone our office on 01372 744009

--
--
*Sign up to our mailing list
<https://astuntechnology.com/company/#email-updates> for updates on
news,
products, conferences, events and training*
*
*

Astun Technology Ltd,
Epsom Square Centre, 6-7 The Derby Square, Epsom, Surrey, KT19 8AG, UK

t:+44 1372 744 009 w: astuntechnology.com <http://astuntechnology.com/>
twitter:@astuntech <https://twitter.com/astuntech>

iShare - enterprise
geographic intelligence platform <https://astuntechnology.com/ishare/>

GeoServer, PostGIS and QGIS training
<https://astuntechnology.com/training-courses/>
Helpdesk and customer
portal
<
https://astuntech.atlassian.net/wiki/spaces/ISHAREHELP/pages/364970043/Astun+Technology+Support+Portal
>

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT no.
864201149.

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

Holmgrimur_Helgason · February 24, 2020, 3:51pm

OK
It's in the h2.xml file:
<bean id="jdbcURL" class="java.lang.String">
<constructor-arg
value="jdbc:h2:/path/to/database/

Thanks.

It works, but still error.
The database is created but GN will not start. Maybe Tomacat vs Apache2
conflict?
2020-02-24 15:49:57,076 ERROR [jeeves] - JeevesContextLoaderListener: Error
creating bean with name 'entityManagerFactory' defined in URL
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
Cannot resolve reference to bean 'jdbcDataSource' while setting bean
property 'dataSource'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'jdbcDataSource' defined in URL
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
Initialization of bean failed; nested exception is
java.lang.RuntimeException: java.sql.SQLException: Cannot create
PoolableConnectionFactory (Syntax error in SQL statement "SELECT1";
expected "SELECT, SET, SAVEPOINT, SCRIPT, SHUTDOWN, SHOW, {"; SQL statement:
SELECT1 [42001-174])
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'entityManagerFactory' defined in URL
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
Cannot resolve reference to bean 'jdbcDataSource' while setting bean
property 'dataSource'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating
bean with name 'jdbcDataSource' defined in URL
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
Initialization of bean failed; nested exception is
java.lang.RuntimeException: java.sql.SQLException: Cannot create
PoolableConnectionFactory (Syntax error in SQL statement "SELECT1";
expected "SELECT, SET, SAVEPOINT, SCRIPT, SHUTDOWN, SHOW, {"; SQL statement:
SELECT1 [42001-174])
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)

Hóddi

Hólmgrímur Helgason (Hóddi)
CAFF - Data Manager
hoddi@anonymised.com
+354 462 3357

On Mon, 24 Feb 2020 at 15:28, Francois Prunayre <fx.prunayre@anonymised.com>
wrote:

See http://www.h2database.com/html/tutorial.html
jdbc:h2:~/test
to put it in your user folder.

Francois

Le lun. 24 févr. 2020 à 16:12, Hólmgrímur Helgason <hoddi@anonymised.com> a
écrit :

Thanks
How do I change the location in the file?

I have:
jdbc.username=www-data
jdbc.password=www-data
jdbc.database=gn

Hólmgrímur Helgason (Hóddi)
CAFF - Data Manager
hoddi@anonymised.com
+354 462 3357

On Mon, 24 Feb 2020 at 14:46, Francois Prunayre <fx.prunayre@anonymised.com>
wrote:

Hi, it should work with tomcat9 too but you may need to change H2 db
location to a writable space.
A good practice is to put the db in an external data dir by changing
jdbc.database properties.

Cheers.

Francois

Le lun. 24 févr. 2020 à 15:19, Jo Cook <jocook@anonymised.com> a
écrit :

Hi,

I think you need to use tomcat8. I can confirm I have it working with
Ubuntu 18.04 that way.

Jo

On Mon, Feb 24, 2020 at 2:09 PM hoddih <hoddi@anonymised.com> wrote:
>
> Hello
> I´m trying to move my GN to a new server but I can´t install GN on
the new
> one.
>
> Ubuntu 18.04
> Java 1.8.0_201
> Tomcat 9
>
> It seems to be some H2 location permission conflict ( I guess).
>
> The error code:
>
> 24-Feb-2020 13:35:48.336 INFO [main]
> org.apache.catalina.core.ApplicationContext.log No Spring
> WebApplicationInitializer types detected on classpath
> 2020-02-24 13:35:52,749 ERROR [jeeves] - JeevesContextLoaderListener:
Error
> creating bean with name 'entityManagerFactory' defined in URL
>
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
> Cannot resolve reference to bean 'jdbcDataSource' while setting bean
> property 'dataSource'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error
creating bean
> with name 'jdbcDataSource' defined in URL
>
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
> Initialization of bean failed; nested exception is
> java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
driver
> of class 'org.h2.Driver' for connect URL
>
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
> org.springframework.beans.factory.BeanCreationException: Error
creating bean
> with name 'entityManagerFactory' defined in URL
>
[jar:file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/lib/domain-3.8.1-0.jar!/config-spring-geonetwork.xml]:
> Cannot resolve reference to bean 'jdbcDataSource' while setting bean
> property 'dataSource'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error
creating bean
> with name 'jdbcDataSource' defined in URL
>
[file:/opt/tomcat/apache-tomcat-9.0.31/webapps/geonetwork/WEB-INF/config-db/defaultJdbcDataSource.xml]:
> Initialization of bean failed; nested exception is
> java.lang.RuntimeException: java.sql.SQLException: Cannot create JDBC
driver
> of class 'org.h2.Driver' for connect URL
>
'/opt/tomcat/apache-tomcat-9.0.31/jdbc:h2:gn;LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE'
> at
>
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
> at
>
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
> at
>
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
>
>
> Hope for help
> Hóddi
>
>
>
> --
> Sent from:
http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html
>
>
> _______________________________________________
> GeoNetwork-users mailing list
> GeoNetwork-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

--
Jo Cook
t:+44 7930 524 155/twitter:@archaeogeek
Please note that currently I do not work on Friday afternoons. For
urgent responses at that time, please visit
support.astuntechnology.com or phone our office on 01372 744009

--
--
*Sign up to our mailing list
<https://astuntechnology.com/company/#email-updates> for updates on
news,
products, conferences, events and training*
*
*

Astun Technology Ltd,
Epsom Square Centre, 6-7 The Derby Square, Epsom, Surrey, KT19 8AG, UK

t:+44 1372 744 009 w: astuntechnology.com <http://astuntechnology.com/
>
twitter:@astuntech <https://twitter.com/astuntech>

iShare - enterprise
geographic intelligence platform <https://astuntechnology.com/ishare/>

GeoServer, PostGIS and QGIS training
<https://astuntechnology.com/training-courses/>
Helpdesk and customer
portal
<
https://astuntech.atlassian.net/wiki/spaces/ISHAREHELP/pages/364970043/Astun+Technology+Support+Portal
>

Company registration no. 5410695. Registered in England and Wales.
Registered office: 120 Manor Green Road, Epsom, Surrey, KT19 8LN VAT
no.
864201149.

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork

Holmgrimur_Helgason · February 25, 2020, 10:40am

Hi Jo

I switched to tomcat 8.5 and everything works great then. It seems to be
some "bugs" with GN on Tomcat 9!
Thanks Jo for your advice.

And thanks to you to Francois, for helping with H2 db location issue.

You are great.
Hóddi

--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoNetwork-users-f3860293.html