META-INF连接到:
OracleDatabase10gExpressEditionRelease10.2.0.1.0-Production
经由常规路径由EXPORT:
V10.02.01创建的导出文件
警告:
这些对象由REFERENCE导出,而不是当前用户
已经完成ZHS16GBK字符集和AL16UTF16NCHAR字符集中的导入
导入服务器使用AL32UTF8字符集(可能的字符集转换)
导出客户机使用WE8MSWIN1252字符集(可能的字符集转换)
.正在将REFERENCE的对象导入到COMPIERE
..正在导入表"AD_ACCESSLOG"导入了0行
..正在导入表"AD_ALERT"导入了1行
..正在导入表"AD_ALERTPROCESSOR"导入了1行
..正在导入表"AD_ALERTPROCESSORLOG"导入了0行
..正在导入表"W_STORE"导入了1行
"SUM(LineOverLimitAmt)ASLineOverLimitAmt,"
"CASEWHENSUM(LineNetAmt)=0THEN0ELSE"
"100-ROUND((SUM(LineNetAmt)-SUM(LineOverLimitAmt))/SUM(LineNetAmt)*100,
2)"
"ENDASLineOverLimit,"
"SUM(QtyInvoiced)ASQtyInvoiced,IsSOTrx"
"FROMRV_C_InvoiceLineil"
"GROUPBYil.AD_Client_ID,il.AD_Org_ID,il.M_Product_ID,"
"firstOf(il.DateInvoiced,'Q'),IsSOTrx"
即将启用约束条件...
成功终止导入,但出现警告。
-------------------------------------
-------------------------------------
--------========--------========--------========--------
SystemCheck-TheImportphaseshowedwarnings.
ThisisOKaslongasthefollowingdoesnotshowerrors
--------========--------========--------========--------
SQL*Plus:
Release10.2.0.1.0-Productionon星期一11月2711:
34:
082006
Copyright(c)1982,2005,Oracle.Allrightsreserved.
连接到:
OracleDatabase10gExpressEditionRelease10.2.0.1.0-Production
DBInfo
--------------------------------------------------------------------------------
DB_Name=XE,Language=SIMPLIFIEDCHINESE_CHINA.AL32UTF8,Host=WORKGROUP\MYPC,IP
192.168.0.10,User=COMPIERE,ID=36,Session=122
DBA_Cleanup
Allvalid
Statisticscomputed:
596
PL/SQL过程已成功完成。
PL/SQL过程已成功完成。
未选定行
未选定行
未选定行
未选定行
提交完成。
从OracleDatabase10gExpressEditionRelease10.2.0.1.0-Production断开
Pressanykeytocontinue...
接下来,配置Oracle本地NET服务名
备注:
安装设置:
1)这里的全局数据库名即为你创建的数据库名,以后在访问数据,创建“本地Net服务名”时用到;
2)数据库口令在登录和创建“本地Net服务名”等地方会用到。
2、创建“本地Net服务名”
1)通过【程序】-》【Oracle-OraDb10g_home1】-》【配置和移植工具】-》【NetConfigurationAssistant】,运行“网络配置助手”工具:
2)选择“本地Net服务名配置”:
3)这里的“Net服务名”我们输入安装数据库时的“全局数据库名”:
4)主机名我们输入本机的IP地址:
5)测试数据库连接,用户名/密码为:
System/数据库口令(安装时输入的“数据库口令”):
默认的用户名/密码错误:
更改登录,输入正确的用户名/密码:
测试成功:
四.启动Compiere应用服务器
您现在可在$COMPIERE_HOME/utils目录中通过RUN_Server2脚本,启动Compiere应用服务器(JBoss4)。
RUN_Server2操作系统日志
SettingmyEnvironment....
StartCompiereAppsServerC:
\Compiere2(xe)
===========================================================.
JBossBootstrapEnvironment
.
JBOSS_HOME:
C:
\Compiere2\jboss\bin\\..
.
JAVA:
C:
\jdk1.5.0_11\bin\java
.
JAVA_OPTS:
-server-Xms64M-Xmx512M-DCOMPIERE_HOME=C:
\Compiere2-Dprogram.na
me=run.bat-Xms128m-Xmx512m
.
CLASSPATH:
C:
\jdk1.5.0_11\lib\tools.jar;C:
\Compiere2\jboss\bin\\run.jar
.
===========================================================.
18:
53:
35,781INFO[Server]StartingJBoss(MXMicroKernel)...
18:
53:
35,812INFO[Server]ReleaseID:
JBoss[Zion]4.0.2(build:
CVSTag=JBoss_
4_0_2date=200505022023)
18:
53:
35,812INFO[Server]HomeDir:
C:
\Compiere2\jboss
18:
53:
35,812INFO[Server]HomeURL:
file:
/C:
/Compiere2/jboss/
18:
53:
35,812INFO[Server]LibraryURL:
file:
/C:
/Compiere2/jboss/lib/
18:
53:
35,812INFO[Server]PatchURL:
null
18:
53:
35,812INFO[Server]ServerName:
compiere
18:
53:
35,812INFO[Server]ServerHomeDir:
C:
\Compiere2\jboss\server\compiere
18:
53:
35,812INFO[Server]ServerHomeURL:
file:
/C:
/Compiere2/jboss/server/com
piere/
18:
53:
35,812INFO[Server]ServerDataDir:
C:
\Compiere2\jboss\server\compiere\
data
18:
53:
35,812INFO[Server]ServerTempDir:
C:
\Compiere2\jboss\server\compiere\
tmp
18:
53:
35,812INFO[Server]ServerConfigURL:
file:
/C:
/Compiere2/jboss/server/c
ompiere/conf/
18:
53:
35,812INFO[Server]ServerLibraryURL:
file:
/C:
/Compiere2/jboss/server/
compiere/lib/
18:
53:
35,812INFO[Server]RootDeploymentFilename:
jboss-service.xml
18:
53:
35,812INFO[Server]StartingGeneralPurposeArchitecture(GPA)...
18:
53:
36,906INFO[ServerInfo]Javaversion:
1.5.0_11,SunMicrosystemsInc.
18:
53:
36,906INFO[ServerInfo]JavaVM:
JavaHotSpot(TM)ServerVM1.5.0_11-b03
SunMicrosystemsInc.
18:
53:
36,906INFO[ServerInfo]OS-System:
Windows20035.2,x86
18:
53:
39,062INFO[Server]Coresysteminitialized
18:
53:
44,843INFO[Log4jService$URLWatchTimerTask]ConfiguringfromURL:
resour
ce:
log4j.xml
18:
53:
45,609INFO[WebService]UsingRMIservercodebase:
http:
//mypc:
8083/
18:
53:
46,078INFO[NamingService]StartedjndibootstrapjnpPort=1099,rmiPort=
1098,backlog=50,bindAddress=mypc/192.168.0.13,ClientSocketFactory=null,Serv
erSocketFactory=.sockets.DefaultSocketFactory@ad093076
18:
53:
52,906INFO[Embedded]Catalinanamingdisabled
18:
53:
53,671INFO[Http11Protocol]InitializingCoyoteHTTP/1.1onhttp-mypc%2F
192.168.0.13-80
18:
53:
56,078INFO[Http11Protocol]Initializ