ofbiz 代码:
http://svn.apache.org/repos/asf/ofbiz/branches/release11.04
切换到oracle,创建自己的数据库账户,脚本如下。请修改自己的用户名和密码
create user ofbiz identified by knet default tablespace users;
alter user ofbiz quota unlimited on users;
grant connect, resource to ofbiz;
Grant create any view to ofbiz;
1.使用oracle数据库,启动后报错
ORA-01843: not a valid month
解决方法
使用dba账户,创建trigger
create or replace TRIGGER ON_CONNECT
AFTER LOGON ON DATABASE
DECLARE
guser varchar2(30);
begin
SELECT sys_context('USERENV', 'SESSION_USER') into guser FROM dual;
if guser = 'ofbiz' THEN
EXECUTE IMMEDIATE 'alter session set nls_timestamp_format = ''YYYY-MM-DD HH24:MI:SS.FF''';