我在测试用jsp调用linux脚本来导出数据库,调用倒是成功了,但是导出数据不完整,中途断掉了,请各位帮忙看看是什么问题,谢谢<%@ page language="java" pageEncoding="GBK" %>
<%@ page import="java.util.*,java.io.*,test.*"%>
<%
Runtime.getRuntime().exec("/home/weblogic/bankI/bak/manual_exp.sh");
%>
很简单,就一句话。
以下是 manual_exp.sh 的内容:#/bin/bash#set Variable
backDir=/home/weblogic/bankI/bak/exp
ora_user=bank
ora_passwd=netsky
service_name=netsky_pms
DATE=`date +"%Y%m%d"`#set env
ORACLE_BASE=/oradata/ora10g
ORACLE_HOME=/home/ora10g/10.2.0/db_1
ORACLE_SID=pms
NLS_LANG=american_america.ZHS16GBK
PATH=$PATH:$ORACLE_HOME/binexport ORACLE_HOME ORACLE_BASE ORACLE_SID NLS_LANG PATH#export the oracle backup
echo "running" > "$backDir"/readme.txt
chown weblogic:weblogic "$backDir"/readme.txt
#exp bank/netsky@NETSKY_PMS file=bank_2008.dmp owner=bank
exp "$ora_user"/"$ora_passwd"@"$service_name" file="$backDir"/bank_"$DATE".dmp log=/home/weblogic/bankI/log/xxy.log owner="$ora_user"
chown weblogic:weblogic "$backDir"/bank_"$DATE".dmp
echo "success" > "$backDir"/readme.txt
exit 0
以下是导出ORACLE 时的日志文件的内容:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character setAbout to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user BANK
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user BANK
About to export BANK's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export BANK's tables via Conventional Path ...
. . exporting table TA01_DEPT 5 rows exported
. . exporting table TA02_YHMC 37 rows exported
. . exporting table TA03_EMPLOYEE 17 rows exported
. . exporting table TA04_ROLE 241 rows exported
. . exporting table TA05_CSMC 34 rows exported
. . exporting table TA06_MODULE 11 rows exported
. . exporting table TA07_FORMFIELD 26 rows exported
. . exporting table TA08_YHMC_ZPYW 13 rows exported
. . exporting table TA09_SSLB 9 rows exported
. . exporting table TA17_EMP_ROLE 1142 rows exported
. . exporting table TC01_SELECT 20 rows exported
. . exporting table TC02_QZ 5 rows exported
. . exporting table TC03_PLBLX 11 rows exported
. . exporting table TC04_RZDY 25 rows exported
. . exporting table TC05_JSXJPZB 42 rows exported
. . exporting table TC06_JSXJPZBMX 176 rows exported
. . exporting table TC07_MODULE_TABLE 40 rows exported
. . exporting table TC08_KHXM 4 rows exported
. . exporting table TC09_KHNR 15 rows exported
. . exporting table TC10_MESSAGE 14 rows exported
. . exporting table TC10_MESSAGESLAVE 0 rows exported
. . exporting table TC10_MSG_SLAVE 3 rows exported
. . exporting table TC11_YJJCPZ 39 rows exported
. . exporting table TC12_CISZBZBRZ 5 rows exported
. . exporting table TD05_QSZX_WLAQ 0 rows exported
. . exporting table TD06_QSZX_YX 8 rows exported
. . exporting table TD07_QSZX_YXJH 5 rows exported
. . exporting table TD10_ZPYX 1 rows exported
. . exporting table TD11_DEZF 6 rows exported
. . exporting table TD12_XEZF 6 rows exported
. . exporting table TD13_CCPC_XTYX 2 rows exported
. . exporting table TD14_ZPYX_YWL 3 rows exported
. . exporting table TD15_CCPC_YWL 2 rows exported
. . exporting table TD16_WORKDAY 36 rows exported
. . exporting table TD17_QUSHIBIAO 22 rows exported
. . exporting table TD18_ZFJY 80 rows exported
. . exporting table TD19_ZFJYMX 686 rows exported
. . exporting table TD20_ZFXX 2 rows exported
. . exporting table TD21_ZFMX 7 rows exported
. . exporting table TD22_ZPYW 1 rows exported
. . exporting table TD23_ZPYWMX 13 rows exported
. . exporting table TD26_XEYXRB 49 rows exported大家可以看到,只导出到了30多张表,其余的30多张没有导出成功。
请大家帮我看看是什么问题,或者告诉我这种问题如何排查也可,反正我是
黩驴技穷了,能想的招都想过了。
<%@ page import="java.util.*,java.io.*,test.*"%>
<%
Runtime.getRuntime().exec("/home/weblogic/bankI/bak/manual_exp.sh");
%>
很简单,就一句话。
以下是 manual_exp.sh 的内容:#/bin/bash#set Variable
backDir=/home/weblogic/bankI/bak/exp
ora_user=bank
ora_passwd=netsky
service_name=netsky_pms
DATE=`date +"%Y%m%d"`#set env
ORACLE_BASE=/oradata/ora10g
ORACLE_HOME=/home/ora10g/10.2.0/db_1
ORACLE_SID=pms
NLS_LANG=american_america.ZHS16GBK
PATH=$PATH:$ORACLE_HOME/binexport ORACLE_HOME ORACLE_BASE ORACLE_SID NLS_LANG PATH#export the oracle backup
echo "running" > "$backDir"/readme.txt
chown weblogic:weblogic "$backDir"/readme.txt
#exp bank/netsky@NETSKY_PMS file=bank_2008.dmp owner=bank
exp "$ora_user"/"$ora_passwd"@"$service_name" file="$backDir"/bank_"$DATE".dmp log=/home/weblogic/bankI/log/xxy.log owner="$ora_user"
chown weblogic:weblogic "$backDir"/bank_"$DATE".dmp
echo "success" > "$backDir"/readme.txt
exit 0
以下是导出ORACLE 时的日志文件的内容:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character setAbout to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user BANK
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user BANK
About to export BANK's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export BANK's tables via Conventional Path ...
. . exporting table TA01_DEPT 5 rows exported
. . exporting table TA02_YHMC 37 rows exported
. . exporting table TA03_EMPLOYEE 17 rows exported
. . exporting table TA04_ROLE 241 rows exported
. . exporting table TA05_CSMC 34 rows exported
. . exporting table TA06_MODULE 11 rows exported
. . exporting table TA07_FORMFIELD 26 rows exported
. . exporting table TA08_YHMC_ZPYW 13 rows exported
. . exporting table TA09_SSLB 9 rows exported
. . exporting table TA17_EMP_ROLE 1142 rows exported
. . exporting table TC01_SELECT 20 rows exported
. . exporting table TC02_QZ 5 rows exported
. . exporting table TC03_PLBLX 11 rows exported
. . exporting table TC04_RZDY 25 rows exported
. . exporting table TC05_JSXJPZB 42 rows exported
. . exporting table TC06_JSXJPZBMX 176 rows exported
. . exporting table TC07_MODULE_TABLE 40 rows exported
. . exporting table TC08_KHXM 4 rows exported
. . exporting table TC09_KHNR 15 rows exported
. . exporting table TC10_MESSAGE 14 rows exported
. . exporting table TC10_MESSAGESLAVE 0 rows exported
. . exporting table TC10_MSG_SLAVE 3 rows exported
. . exporting table TC11_YJJCPZ 39 rows exported
. . exporting table TC12_CISZBZBRZ 5 rows exported
. . exporting table TD05_QSZX_WLAQ 0 rows exported
. . exporting table TD06_QSZX_YX 8 rows exported
. . exporting table TD07_QSZX_YXJH 5 rows exported
. . exporting table TD10_ZPYX 1 rows exported
. . exporting table TD11_DEZF 6 rows exported
. . exporting table TD12_XEZF 6 rows exported
. . exporting table TD13_CCPC_XTYX 2 rows exported
. . exporting table TD14_ZPYX_YWL 3 rows exported
. . exporting table TD15_CCPC_YWL 2 rows exported
. . exporting table TD16_WORKDAY 36 rows exported
. . exporting table TD17_QUSHIBIAO 22 rows exported
. . exporting table TD18_ZFJY 80 rows exported
. . exporting table TD19_ZFJYMX 686 rows exported
. . exporting table TD20_ZFXX 2 rows exported
. . exporting table TD21_ZFMX 7 rows exported
. . exporting table TD22_ZPYW 1 rows exported
. . exporting table TD23_ZPYWMX 13 rows exported
. . exporting table TD26_XEYXRB 49 rows exported大家可以看到,只导出到了30多张表,其余的30多张没有导出成功。
请大家帮我看看是什么问题,或者告诉我这种问题如何排查也可,反正我是
黩驴技穷了,能想的招都想过了。
解决方案 »
- JAVA源码怎样学习
- 关于setExecuteBatch的一个简单问题
- 调用!
- jdialog关闭不了
- 哪个能给我介绍可以下载 JAVA数据结构 的视频,我直接给你90分..
- 如何做一个向导页面的对话框,包含上一步、下一步之类的按钮
- Java 执行SQL修改数据库用户密码,密码中含有'?'问题怎么解决?
- 想要把Java学好,必须要熟悉哪些包?
- java 如何调用 COM对象 或WIN API(给提示的有分)
- 发现if(e.getActionCommand()=="XX")与if(e.getActionCommand()equals("XX"))等效,为什么?
- 解释下这个程序的结果
- 类或接口的引用实现问题
可能要在tomcat的配置文件中设置页面超时时间吧