I just attempted to create the database on an empty Oracle schema. I then
received the following error.
2012-06-04 12:14:11,514 INFO [jeeves.apphand] - - SQL data
file:/var/lib/tomcat6/webapps/geonetwork-branch-2012-05-31/WEB-INF/classes/setup/sql/data
prefix:loc-ara- ...
2012-06-04 12:14:11,539 WARN [geonetwork.database] - SQL failure for:
INSERT INTO Languages VALUES ('ara','???', 'n', 'n'), error
is:ORA-00917: missing comma
It seems that this was the statement causing the issue. If I replace the
Arabic text by English text, then the script executed correctly.
INSERT INTO Languages VALUES ('ara','العربية', 'n', 'n');
Environment
- Tomcat on Linux
- JNDIPool provider in config.xml
- oracle config in tomcat/conf/context.xml
- Oracle character set WE8MSWIN1252
The database should not be complaining about a missing comma even though,
the database character set is not correct. Here is the insert statement
executed using SQL Developer. The data is not inserted correctly however the
statement does not fail - which in this case is a database character set
issue.
--
View this message in context: http://osgeo-org.1560.n6.nabble.com/loc-ara-default-sql-generates-ORA-00917-missing-comma-tp4978971.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.