Hi Jose & Christian
Thanks for that news
Unfortunately PostgreSQL is not a viable option for our organisation
(yes, I have development access to PG but no production instances)
Makes 3.2 a real risk!
BLEYS Evert Mr
Data Manager
Australian Bureau of Agricultural and Resource Economics and Sciences
Department of Agriculture and Water Resources
GPO Box 858 Canberra City ACT Australia 2601
Ph: +61 (0)2 6272 5627
Email: Evert.Bleys@...1564...
-----Original Message-----
From: Schigl Christian [mailto:christian.schigl@…1097…]
Sent: 2017-02-03 02:45
To: Jose Garcia *EXTERN* <jose.garcia@...444...>
Cc: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] GN 3.2.0 Database schema - Oracle [SEC=UNCLASSIFIED]
Thanks, Jose,
so it looks like i have to give PostgreSQL a try...
Any news on the Oracle-issue will be welcome !
Cheers,
Christian
Von: Jose Garcia *EXTERN* [mailto:jose.garcia@…444…]
Gesendet: Donnerstag, 02. Februar 2017 16:23
An: Schigl Christian
Cc: geonetwork-users@lists.sourceforge.net
Betreff: Re: [GeoNetwork-users] GN 3.2.0 Database schema - Oracle
Hi
Oracle doesn't really work with Geonetwork 3.2.x, see related issue: https://github.com/geonetwork/core-geonetwork/issues/1720
The problem is that the fix breaks also other features. Will re-check with Emmanuel Tajariol to verify if any progress on it.
Regards,
Jose García
On Thu, Feb 2, 2017 at 2:41 PM, Schigl Christian <christian.schigl@...1097...<mailto:christian.schigl@…1097…>> wrote:
hello list,
i'm trying to setup a new instance of GeoNetwork 3.2.0 (Linux RedHat, TomCat 7, Oracle 11.2) and ran into two problems :
a)
When I connect to a new, empty database scheme the database objects are not created & filled correctly :
There are, at least, tables & a sequence created but they are empty.
When I try to fill the tables with the sql-statement under \web\geonetwork\WEB-INF\classes\setup\sql\data (i even added the commit; statement 
) the application comes up with an error :
Is there a SQL-Script that creates and fills the required database objects correctly ??
b)
to check that the installation itself is working i connect to an database schema that holds an older version of gn (3.0.2 i.e.).
this will work at the first glimpse, i am able to import a MEF File an see the data.
When i try to delete a metadata item nothing happens but in geonetwork.log I get the following messages :
2017-02-02 14:18:52,591 WARN [org.springframework.context.support.ResourceBundleMessageSource] - ResourceBundle [messages] not found for MessageSource: Can't find bundle for base name messages, locale de
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/host but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/port but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/username but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/password but null value found. Check the settings table.
2017-02-02 14:19:13,116 WARN [geonetwork.settings] - Requested setting with name: system/proxy/ignorehostlist but null value found. Check the settings table.
b.1 : How can i solve the ResourceBundleMessageSource - thing ?
b.2 : How can a proxy be involved in deleting a record in my database ?
thanks in advance ,
cheers
Christian
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net<mailto:GeoNetwork-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
--
Vriendelijke groeten / Kind regards,
Jose García
[https://www.geocat.net/wp-content/uploads/2015/07/GeoCat_small1.png\]<http://www.geocat.net/>
Veenderweg 13
6721 WD Bennekom
The Netherlands
T: +31 (0)318 416664<tel:+31318416664>
[https://www.geocat.net/wp-content/uploads/2015/07/facebook_24.png\]<https://www.facebook.com/geocatbv> [https://www.geocat.net/wp-content/uploads/2015/07/Twitter_icon.png\] <https://twitter.com/geocat_bv> [https://www.geocat.net/wp-content/uploads/2015/07/Google-plus-icon.png\] <https://plus.google.com/u/1/+GeocatNetbv/posts>
Please consider the environment before printing this email.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________
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
------
IMPORTANT - This email and any attachments have been issued by the Australian Government Department of Agriculture and Water Resources. The material transmitted is for the use of the intended recipient only and may contain confidential, legally privileged, copyright or personal information. You should not copy, use or disclose it without authorisation from the Department. It is your responsibility to check any attachments for viruses and defects before opening or forwarding them.
If you are not an intended recipient, please contact the sender of this email at once by return email and then delete both messages. Unintended recipients must not copy, use, disclose, rely on or publish this email or attachments. The Department of Agriculture and Water Resources is not liable for any loss or damage resulting from unauthorised use or dissemination of, or any reliance on, this email or attachments.
If you have received this e-mail as part of a valid mailing list and no longer want to receive a message such as this one, advise the sender by return e-mail accordingly. This notice should not be deleted or altered
------