oracle lvmama pet,lvmamastudy

#lvmamastudy

eclipse windows perf maven user settings config

svn connector installation

maven svn checkout thursday

hide pom.xml in thursday

import maven projects in thursday

download tomcat 7

config jdk 7

use dubbo ,zookeeper, jms package and startup zk, dubbo, jms

in eclipse startup module in tomcat server, set timeout to 1200

for example : set vst_back/src/main/config/dubbo.properties

dubbo.application.name=vst_back

dubbo.registry.protocol=zookeeper

dubbo.registry.address=127.0.0.1:2181

dubbo.protocol.port=20880

dubbo.monitor.address=127.0.0.1:7070

use this page:

http://192.168.0.106:8080/prism-web/zk+

to register service into local zk

http://localhost:8082/applications.html

to see if the local provider is registered

if login is needed, can comment following block:

//if (isNeedCheck) { 验证是否登录 //PermUser user = (PermUser) ServletUtil.getSession(req, res, BaseActionSupport.SESSION_BACK_USER); //if(isDebug){ //LOG.debug("user login {}",new Object[]{user!=null}); //} //if (user == null //|| !user.getPermUserPass() //|| uri.equalsIgnoreCase(req.getContextPath()) //|| uri.equalsIgnoreCase("/")) { //res.sendRedirect("/pet_back/login.do"); //return; //} 验证权限 //if(isPermRefused(req,user)){ //if(isDebug){ //LOG.debug("isPermRefused true"); //} //res.sendRedirect("/pet_back/permError.jsp?from=" //+ URLEncoder.encode(req.getRequestURI(),"UTF-8") //+ "&userId=" + String.valueOf(user.getUserId())); //return; //} //}

in file : vst_comm/src/main/java/com/lvmama/vst/comm/filter/PermissionFilter.java

ubuntu sudo apt-get update issue

solution:

sudo rm /var/cache/apt/archives/lock

sudo rm /var/lib/dpkg/lock

intellj 2016 license:

43B4A73YYJ-eyJsaWNlbnNlSWQiOiI0M0I0QTczWVlKIiwibGljZW5zZWVOYW1lIjoibGFuIHl1IiwiYXNzaWduZWVOYW1lIjoiIiwiYXNzaWduZWVFbWFpbCI6IiIsImxpY2Vuc2VSZXN0cmljdGlvbiI6IkZvciBlZHVjYXRpb25hbCB1c2Ugb25seSIsImNoZWNrQ29uY3VycmVudFVzZSI6ZmFsc2UsInByb2R1Y3RzIjpbeyJjb2RlIjoiSUkiLCJwYWlkVXBUbyI6IjIwMTctMDItMjUifSx7ImNvZGUiOiJBQyIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IkRQTiIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IlBTIiwicGFpZFVwVG8iOiIyMDE3LTAyLTI1In0seyJjb2RlIjoiRE0iLCJwYWlkVXBUbyI6IjIwMTctMDItMjUifSx7ImNvZGUiOiJDTCIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IlJTMCIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IlJDIiwicGFpZFVwVG8iOiIyMDE3LTAyLTI1In0seyJjb2RlIjoiUEMiLCJwYWlkVXBUbyI6IjIwMTctMDItMjUifSx7ImNvZGUiOiJSTSIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9LHsiY29kZSI6IldTIiwicGFpZFVwVG8iOiIyMDE3LTAyLTI1In0seyJjb2RlIjoiREIiLCJwYWlkVXBUbyI6IjIwMTctMDItMjUifSx7ImNvZGUiOiJEQyIsInBhaWRVcFRvIjoiMjAxNy0wMi0yNSJ9XSwiaGFzaCI6IjMzOTgyOTkvMCIsImdyYWNlUGVyaW9kRGF5cyI6MCwiYXV0b1Byb2xvbmdhdGVkIjpmYWxzZSwiaXNBdXRvUHJvbG9uZ2F0ZWQiOmZhbHNlfQ==-keaxIkRgXPKE4BR/ZTs7s7UkP92LBxRe57HvWamu1EHVXTcV1B4f/KNQIrpOpN6dgpjig5eMVMPmo7yMPl+bmwQ8pTZaCGFuLqCHD1ngo6ywHKIQy0nR249sAUVaCl2wGJwaO4JeOh1opUx8chzSBVRZBMz0/MGyygi7duYAff9JQqfH3p/BhDTNM8eKl6z5tnneZ8ZG5bG1XvqFTqWk4FhGsEWdK7B+He44hPjBxKQl2gmZAodb6g9YxfTHhVRKQY5hQ7KPXNvh3ikerHkoaL5apgsVBZJOTDE2KdYTnGLmqxghFx6L0ofqKI6hMr48ergMyflDk6wLNGWJvYHLWw==-MIIEPjCCAiagAwIBAgIBBTANBgkqhkiG9w0BAQsFADAYMRYwFAYDVQQDDA1KZXRQcm9maWxlIENBMB4XDTE1MTEwMjA4MjE0OFoXDTE4MTEwMTA4MjE0OFowETEPMA0GA1UEAwwGcHJvZDN5MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAxcQkq+zdxlR2mmRYBPzGbUNdMN6OaXiXzxIWtMEkrJMO/5oUfQJbLLuMSMK0QHFmaI37WShyxZcfRCidwXjot4zmNBKnlyHodDij/78TmVqFl8nOeD5+07B8VEaIu7c3E1N+e1doC6wht4I4+IEmtsPAdoaj5WCQVQbrI8KeT8M9VcBIWX7fD0fhexfg3ZRt0xqwMcXGNp3DdJHiO0rCdU+Itv7EmtnSVq9jBG1usMSFvMowR25mju2JcPFp1+I4ZI+FqgR8gyG8oiNDyNEoAbsR3lOpI7grUYSvkB/xVy/VoklPCK2h0f0GJxFjnye8NT1PAywoyl7RmiAVRE/EKwIDAQABo4GZMIGWMAkGA1UdEwQCMAAwHQYDVR0OBBYEFGEpG9oZGcfLMGNBkY7SgHiMGgTcMEgGA1UdIwRBMD+AFKOetkhnQhI2Qb1t4Lm0oFKLl/GzoRykGjAYMRYwFAYDVQQDDA1KZXRQcm9maWxlIENBggkA0myxg7KDeeEwEwYDVR0lBAwwCgYIKwYBBQUHAwEwCwYDVR0PBAQDAgWgMA0GCSqGSIb3DQEBCwUAA4ICAQC9WZuYgQedSuOc5TOUSrRigMw4/+wuC5EtZBfvdl4HT/8vzMW/oUlIP4YCvA0XKyBaCJ2iX+ZCDKoPfiYXiaSiH+HxAPV6J79vvouxKrWg2XV6ShFtPLP+0gPdGq3x9R3+kJbmAm8w+FOdlWqAfJrLvpzMGNeDU14YGXiZ9bVzmIQbwrBA+c/F4tlK/DV07dsNExihqFoibnqDiVNTGombaU2dDup2gwKdL81ua8EIcGNExHe82kjF4zwfadHk3bQVvbfdAwxcDy4xBjs3L4raPLU3yenSzr/OEur1+jfOxnQSmEcMXKXgrAQ9U55gwjcOFKrgOxEdek/Sk1VfOjvS+nuM4eyEruFMfaZHzoQiuw4IqgGc45ohFH0UUyjYcuFxxDSU9lMCv8qdHKm+wnPRb0l9l5vXsCBDuhAGYD6ss+Ga+aDY6f/qXZuUCEUOH3QUNbbCUlviSz6+GiRnt1kA9N2Qachl+2yBfaqUqr8h7Z2gsx5LcIf5kYNsqJ0GavXTVyWh7PYiKX4bs354ZQLUwwa/cG++2+wNWP+HtBhVxMRNTdVhSm38AknZlD+PTAsWGu9GyLmhti2EnVwGybSD2Dxmhxk3IPCkhKAK+pl0eWYGZWG3tJ9mZ7SowcXLWDFAk0lRJnKGFMTggrWjV8GYpw5bq23VmIqqDLgkNzuoog==

sync_super_jdbc.username=lvmama_super

sync_super_jdbc.password=oU7Reu3nLh

sync_super_jdbc.url=jdbc:oracle:thin:@192.168.0.70:1523:lvmamadb2

sync_pet_jdbc.username=lvmama_pet

sync_pet_jdbc.password=hJn4B90rPO

sync_pet_jdbc.url=jdbc:oracle:thin:@192.168.0.70:1523:lvmamadb2

sync_vst_jdbc.username=lvmama_ver

sync_vst_jdbc.password=nPH3g7yVgn

sync_vst_jdbc.url=jdbc:oracle:thin:@192.168.0.70:1523:lvmamadb2

workflow 由订单创建启动

影响 comAudit, comMessage 两个表

主流程 -> 子流程

分支有listener notify 方法注入控制变量

仿真环境账号

bbbbbb1,111111

前台下单

后台财务管理->线下支付管理->测试付款->VST+订单查询->付款

vst_order,vst_workflow分别在192.168.0.184,10.2.2.38上面

http://ebooking.lvmama.com/

账号：lv9224 密码：lv9224

供应商登录后发现有待确定的订单，确定资源

仿真环境的主机IP基于全仿真工程分配图_2016版_V1.0_20160105(1)

有所变化

192.168.X.X保持不变

10.0.2.x ==> 10.200.1.x

10.2.2.x ==> 10.200.2.x

状态: 失败 -测试失败: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

状态: 失败 -测试失败: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

陈国红 - 用户体验组 2016-08-18 10:33:15

http://super.lvmama.com/vst_back/biz/category/findObjectList.do?code=242bf46a04018ed4ef00d78cb141761b

不知道你有没有权限查

陈国红 - 用户体验组 2016-08-18 10:33:39

如果没有权限，只能写好SQL找DBA查

陈国红 - 用户体验组 2016-08-18 10:33:51

拉分支

陈国红 - 用户体验组 2016-08-18 10:33:59

现在可以拉，之后可能拉不了

陈炜 - 出境业务开发组 2016-08-18 10:35:25

明白了

陈国红 - 用户体验组 2016-08-18 10:36:45

测试申请写一下

陈国红 - 用户体验组 2016-08-18 10:36:58

分支名字发下给梁石

调试vst_ebooking时候登录不了(zookeeper 配置游玩人后置2已经完毕3个依赖包已经导入本地zookeeper)

|--> vst_order

|--> vst_pet

|--> vst_back

|--> pet_public

1.

说是memcache配置问题

原先的memcached.properties 修改成

cache.server=10.200.3.144:12000

session.cache.server=10.200.3.144:12000

cache.enable=true

vst_ebkService 中copy vst_ebooking 的 dubbo.properties到 vst_ebkService中

启动在另外一个tomcat server 看一下eclipse 启动tomcat的参数配置，而不是tomcat本身的配置

128数据库

128数据库：用户名 密码

lvmama_super RM1cp5H8

lvmama_pet HgQz5Ncl

lvmama_report lvmama_report

lvmama yh9TlXkj

lvmama_ver YDUXtDDZ

LVMAMA_WORKFLOW Ry3ex1mp

#url ：jdbc:mysql://10.200.3.188:3306/lvmama_user

#user ：lvmama_user_ro

#password：8ZV0Y2GMSHz

8月24日图形验证码没有显示时下单不成问题

反思了昨天bug：

路径依赖的变量必须都核实是否要改动判断条件，我当时是知道有这个变量是路径依赖的，但是不太敢动，想测试出问题了再改

拖延了

测试依赖，结果当时让邢智宇提供不需要图形验证码的手机号，他没有及时回应，让我把链接发给他，我发了，他说可以，我就

以为是没问题，也把这个消息告诉陈国红了，结果造成其实测试依赖也没有落实。

8月25日开始有2个项目，其中workflow是在分支上开发

本地环境备忘：

本地intellj基于Thursday 建立git repo并和oschina作为远端备份，作为开发环境便于代码版本管理，已经在git 基础上建立了workflow分支

本地在working目录下建立Thursday , workflow的目录作为代码checkin的环境 到时候比较1.intellj 和 2.working/Thursday or workflow 的差异

将需要提交的文件copy 覆盖到working 目录下提交注意避免文件覆盖错误

检查子订单资源审核 信息审核是否enable

auditMap 中下面2个值

RESOURCE_AUDIT

INFO_AUDIT

检查工作流实时instance

select * from act_ru_execution t where t.order_id_ ='';

select * from act_ru_variable ;

select * from act_ge_bytearray b where b.id_='1743';

检查实时工作流图

主订单

http://super.lvmama.com/vst_workflow/page/order/20022648

子订单 子订单生命周期短，完事后就查不到流程图了

http://super.lvmama.com/vst_workflow/page/item/30000326547/approve

$ git config --global core.quotepath false # 显示 status 编码

$ git config --global gui.encoding utf-8 # 图形界面编码

$ git config --global i18n.commit.encoding utf-8 # 提交信息编码

$ git config --global i18n.logoutputencoding utf-8 # 输出 log 编码

$ export LESSCHARSET=utf-8

最后一条命令是因为 git log 默认使用 less 分页，所以需要 bash 对 less 命令进行 utf-8 编码

select * from act_re_procdef where resource_name_ ='order_prepaid_main_process.bpmn' order by update_time_ desc ;

select * from ACT_RE_DEPLOYMENT order by deploy_time_ desc, update_time_ desc ;

144：

ls -al restart*.sh |gawk '{ print "./"$9"&" }'

sudo ./restart_memcache.sh nohup&

sudo ./restart_activemq_5.13.0.sh nohup&

sudo ./restart_cmt_front.sh nohup&

sudo ./restart_other.sh nohup&

sudo ./restart_pet_service.sh nohup&

sudo ./restart_seo_back.sh nohup&

sudo ./restart_tnt_front.sh nohup&

sudo ./restart_tnt_service.sh nohup&

sudo ./restart_back.sh nohup&

sudo ./restart_cmt_service.sh nohup&

sudo ./restart_payment.sh nohup&

sudo ./restart_pic.sh nohup&

sudo ./restart_seo_dist.sh nohup&

sudo ./restart_tnt_order.sh nohup&

sudo ./restart_tomcat.sh nohup&

sudo ./restart_channel_server.sh nohup&

sudo ./restart_front.sh nohup&

sudo ./restart_pc.sh nohup&

sudo ./restart_report.sh nohup&

sudo ./restart_super_service.sh nohup&

sudo ./restart_tnt_platform.sh nohup&

sudo ./restart_user.sh nohup&

sudo ./restart_cmt_back.sh nohup&

sudo ./restart_ocs.sh nohup&

sudo ./restart_pet_finfront.sh nohup&

sudo ./restart_sales_service.sh nohup&

sudo ./restart_tnt_back.sh nohup&

sudo ./restart_tnt_sback.sh nohup&

145:

sudo ./restart_cms_content.sh nohup&

sudo ./restart_dest_bridge_schedule.sh nohup&

sudo ./restart_dest_hotel_dock.sh nohup&

sudo ./restart_dest_service.sh nohup&

sudo ./restart_o2o_back.sh nohup&

sudo ./restart_o2o_front.sh nohup&

sudo ./restart_supp.sh nohup&

sudo ./restart_tomcat.sh nohup&

sudo ./restart_vst_allocation.sh nohup&

sudo ./restart_vst_back.sh nohup&

sudo ./restart_vst_ebkService.sh nohup&

sudo ./restart_vst_ebooking.sh nohup&

sudo ./restart_vst_front.sh nohup&

sudo ./restart_vst_interfacePlatform.sh nohup&

sudo ./restart_vst_order.sh nohup&

sudo ./restart_vst_passport.sh nohup&

sudo ./restart_vst_pet.sh nohup&

sudo ./restart_vst_prodcal.sh nohup&

sudo ./restart_vst_prom.sh nohup&

sudo ./restart_vst_rest.sh nohup&

sudo ./restart_vst_search.sh nohup&

sudo ./restart_vst_ticket.sh nohup&

sudo ./restart_vst_workflow.sh nohup&

sudo ./restart_dest_bridge_schedule.sh nohup&

sudo ./restart_dest_hotel_dock.sh nohup&

sudo ./restart_dest_service.sh nohup&

更改工作流bpmn文件后部署上去后要配置人员清缓存memcache

独立环境里面缓存在10.200.3.144上 kill memche的进程

从新启动各个服务

10.200.3.145

restart_memcache.sh

144&145 独立环境下数据库

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver

jdbc.maxActive=10

jdbc.maxIdle=1

jdbc.maxWait=10000

jdbc.initSize=1

jdbc.username=lvmama_ver

jdbc.password=nPH3g7yVgn

jdbc.url=jdbc:oracle:thin:@192.168.0.70:1522:lvmamadb1

jdbc.readonly.driverClassName=oracle.jdbc.driver.OracleDriver

jdbc.readonly.maxActive=10

jdbc.readonly.maxIdle=1

jdbc.readonly.maxWait=10000

jdbc.readonly.initSize=1

jdbc.readonly.username=lvmama_ver

jdbc.readonly.password=nPH3g7yVgn

jdbc.readonly.url=jdbc:oracle:thin:@192.168.0.70:1522:lvmamadb1

datasource.hold.enabled=false

jdbc.r1.username=lvmama_ver

jdbc.r1.password=nPH3g7yVgn

jdbc.r1.url=jdbc:oracle:thin:@192.168.0.70:1522:lvmamadb1

DB_SYNC_SECOND=2

checkWriteInReadonly=true

\vst_front\src\main\webapp\js\visa\bookVisa.js 闫冬全修改的前端图形码优化显示

在添加Tomcat之前，需要修改一下Tomcat中的catalina.bat文件。否则在项目启动一段时间后会出现：

java.lang.OutOfMemoryError: PermGen space错误(内存溢出)，这是因为存放class信息的PermGen space

区域不会在主程序运行期被清理，如果load很多class的话,就很可能出现PermGen space错误。

文件位置:安装tomcat目录下的bin目录下。我的是在：D:\develop\apache-tomcat-6.0.36\bin下。

打开catalina.bat文件，找到：echo Using CATALINA_BASE: "%CATALINA_BASE%"。在其上面位置

添加：set JAVA_OPTS=%JAVA_OPTS% -server -XX:PermSize=128M -XX:MaxPermSize=512m

下面这句sql外面包裹了一层分页逻辑

SELECT * FROM (SELECT P_T.*,ROWNUM AS RN FROM (

select

ORDERSTOCK.MESSAGE_ID ,

ORDERSTOCK.PRODUCT_ID,

ORDERSTOCK.PRODUCT_NAME,

ORDERSTOCK.VISIT_TIME,

ORDERSTOCK.SUPPLIER_ID,

ORDERSTOCK.LATEST_PAYMENT_TIME,

MSG.CONTENT

from EBK_MESSAGE MSG , EBK_MESSAGE_ORDER_STOCK ORDERSTOCK

where MSG.message_id = ORDERSTOCK.message_id

and

ORDERSTOCK.PRODUCT_ID = 1000

and

MSG.SUPPLIER_ID = 3410

AND MSG.EXPIRY_DATE > sysdate

) P_T ) WHERE RN BETWEEN 1 AND 5;

workflow 改动总结

executeTask的时候可以往context即execution里面塞环境变量

dubbo调用，跨jvm的module往往用dubbo调用，如果已经声明过的service，那么只需要查看是否需要添加接口定义

可以尝试一下用listener来往execution里面塞环境变量 -- 可行

BizEnum.category_route_group(15L,"跟团游"),

alter session set NLS_COMP=ANSI;

alter session set NLS_SORT=BINARY_CI;

SELECT owner, table_name FROM all_tables where owner = 'LVMAMA_VER' and table_name like '%HOTEL%';

SELECT owner, table_name FROM all_tables where owner = 'LVMAMA_VER';

发现用ExecutionListener后在一次测试中当vst_order service不正常时，workflow能够继续走，觉得用listener 后把需要串行的流程变成并行导致有可能出现变量尚未被设置到activiti的context中而流程已经走到需要判断变量以决定走哪个分支的阶段。 有风险，提出缓提交。

解决方法：还是用原来的task模式查询出控制变量设置到activiti的context中

数据库表设计模式和实践方面的好书要重点补充阅读

9月22日把workflow的代码更新成Thursday的最新版

然后把originworkflow/workflow2的代码合并修改到workflow目录里面然后提交

陈洁电话：15900867030

ebooking供应商登录帐号

ceshichanpin 111111q

SELECT table_name

FROM all_tab_cols

WHERE column_name like'%attachment'

grep -n ...

awk 'NR >= 9222600 && NR <= 9222800' catalina.out-2016-09-26 | more

awk 'NR >= 4384102 && NR <= 4384902' 172.20.9.169/catalina.out-2016-09-26|more

查询code

D:\working\workflow\vst_comm\src\main\java\com\lvmama\vst\comm\utils\DESCoder.java

的main函数生成 比如：

3a59d74f3b28cf173f5f5fd711de3f43

delete from PROD_TRAFFIC_FLIGHT

where FLIGHT_ID IN

#{flightId}

where 1 != 1