The GeoNetwork opensource geospatial catalog v2.2.0 is out!
Document Actions
MySQL: can't call commit when autocommit=true
Up to Table of ContentsThis FAQ applies to: 2.0.0
I have installed Apache Tomcat 5, J2RE 1.4.2 and MySQL 5.
I have created a new schema "geonetwork" in MySQL. During the installation of GeoNetwork 2.0.0 I have specified the connection url jdbc:mysql://localhost/geonetwork", then I have saved the jdbc driver file
"mysql-connector-java-3.1.11-bin.jar" in the folder "..\geonetwork\web\WEB-INF\lib".
Finally, I received the following error message: "can't call commit when autocommit = true".
I have continued the installation; the tables are created in the schema geonet2, but I cannot login as administrator.
During the installation process, use the following URL for MySQL:
jdbc:mysql://localhost/geonetwork?useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8
After the installation process, open the config.xml file with a text editor. The config.xml file is located in the ..\web\WEB-INF folder.
Make the following changes:
- in the
<resources>section (around line 60), set<resource enabled="true">to false for mckoi and to true for mysql; - type the correct user and password in the MySQL section;
- change the connection url to
jdbc:mysql://localhost/geonetwork?useUnicode=true&characterEncoding=utf-8&mysqlEncoding=utf8. This is very important in order to allow multi-language support.
You can now start the GeoNetwork web server (Jetty or Tomcat) and the problem should be solved.
by
Jeroen Ticheler
—
last modified
2007-08-21 01:37
Contributors:
Stefano Giaccio
Creative Commons - http://creativecommons.org/licenses/by/2.5/
