Opened 14 years ago
Closed 14 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)
Change History (2)
by , 14 years ago
comment:1 by , 14 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
r7794