windows server 2008 64 位 上安装 postgreSQL 、 openbravo 报错如下:
C:\Users\Administrator>cd C:\java\Openbravo3
C:\java\Openbravo3>ant install.source
Buildfile: C:\java\Openbravo3\build.xml
set.code.rev:
code.rev:
init:
cleanSubfolders:
clean:
[delete] Deleting directory C:\java\Openbravo3\src-core\build\classes
[delete] Deleting directory C:\java\Openbravo3\src-core\docs
[delete] Deleting: C:\java\Openbravo3\src-core\lib\openbravo-core.jar
clean:
clean:
core.lib:
init:
[mkdir] Created dir: C:\java\Openbravo3\src-core\build\classes
[mkdir] Created dir: C:\java\Openbravo3\src-core\docs
compile:
[javac] Compiling 124 source files to C:\java\Openbravo3\src-core\build\clas
ses
build.jar:
[jar] Building jar: C:\java\Openbravo3\src-core\lib\openbravo-core.jar
build:
copy.core.lib:
[copy] Copying 1 file to C:\java\Openbravo3\lib\runtime
database.lib:
init:
compile:
build.jar:
jar:
create.database:
create.database:
clean.database.POSTGRE:
[sql] Executing commands
[sql] Failed to execute: DROP DATABASE openbravo
[sql] org.postgresql.util.PSQLException: ERROR: database "openbravo" does
not exist
[sql] 0 of 1 SQL statements executed successfully
[sql] Executing commands
[sql] 1 of 1 SQL statements executed successfully
prepare.database:
POSTGRE.structure:
[sql] Executing commands
[sql] 2 of 2 SQL statements executed successfully
[sql] Executing commands
[sql] 1 of 1 SQL statements executed successfully
create.database.all:
Database connection: jdbc:postgresql://localhost:5432/openbravo. User: tad
Executing default prescript
SQL Command failed with: ERROR: could not load library "C:/Program Files (x86)/PostgreSQL/9.2/lib/uuid-ossp.dll": The application has failed to start because it
s side-by-side configuration is incorrect. Please see the application event log
for more detail.
-- END
CREATE OR REPLACE FUNCTION uuid_generate_v4()
RETURNS uuid
AS '$libdir/uuid-ossp', 'uuid_generate_v4'
VOLATILE STRICT LANGUAGE C;
CREATE OR REPLACE FUNCTION get_uuid()
RETURNS varchar AS
$BODY$ DECLARE
/*************************************************************************
* The contents of this file are subject to the Openbravo Public License
* Version 1.1 (the "License"), being the Mozilla Public License
* Version 1.1 with a permitted attribution clause; you may not use this
* file except in compliance with the License. You may obtain a copy of
* the License at http://www.openbravo.com/legal/license.html
* Software distributed under the License is distributed on an "AS IS"
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
* License for the specific language governing rights and limitations
* under the License.
* The Original Code is Openbravo ERP.
* The Initial Developer of the Original Code is Openbravo SLU
* All portions are Copyright (C) 2008-2009 Openbravo SLU
* All Rights Reserved.
* Contributor(s): ______________________________________.
************************************************************************/
var VARCHAR:=uuid_generate_v4();
BEGIN
WHILE var=uuid_generate_v4()::varchar LOOP
END LOOP;
return replace(upper(uuid_generate_v4()::varchar),'-','');
END; $BODY$
LANGUAGE 'plpgsql' VOLATILE
Executed 116 SQL command(s) with 1 error(s)
Executing creation script
for the complete database
解决方法如下:
1.安装windows 64位的jdk 和tomcat 配置环境变量
2.安装 windows 64 位的VC++ 2005运行库
3.安装.net framework 3.5
4.安装postgreSQL后再安装jdbc插件