Opened 14 years ago

Closed 13 years ago

#475 closed enhancement (fixed)

DB / H2 as default db

Reported by: fxp Owned by: fxp
Priority: major Milestone: v2.7.0
Component: General Version:
Keywords: DB Cc:

Description

GeoNetwork use Mckoi as default database. It set transaction isolation to TRANSACTION_SERIALIZABLE (only option for Mckoi cf. http://www.mckoi.com/database/Transactions.html) and TRANSACTION_READ_COMMITTED for other DB types which avoid the error:

com.mckoi.database.jdbc.MSQLException: Concurrent Serializable Transaction Conflict(4): Select from table that has committed changes: Metadata

This error happens when concurrent harvesters run at the same time, or when heavy editing.

Proposal : set H2 as the default database.

	  <resource enabled="true">
	    <name>main-db</name>
	    <provider>jeeves.resources.dbms.ApacheDBCPool</provider>
	    <config>
	      <user>admin</user>
	      <password>gnos</password>
	      <driver>org.h2.Driver</driver>
	      <url>jdbc:h2:geonetwork</url>
	      <poolSize>10</poolSize>
	      <reconnectTime>3600</reconnectTime>
	    </config>
	  </resource>

Comments:

  • Mckoi could still be used
  • A database named "geonetwork" with user "admin"/"gnos" is created at startup if it does not exist in user home folder.

Attachments (1)

h2.patch (2.4 KB ) - added by fxp 14 years ago.

Download all attachments as: .zip

Change History (2)

by fxp, 14 years ago

Attachment: h2.patch added

comment:1 by fxp, 13 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.