47 lines
1.6 KiB
Properties
47 lines
1.6 KiB
Properties
drivers=oracle.jdbc.OracleDriver
|
|
logfile=D:\\tomcatLogs\\db\\{yyMM\\dd}.txt
|
|
|
|
#db1.url=jdbc:oracle:thin:@10.0.37.200:1521:ORcl
|
|
db1.url=jdbc:oracle:thin:@192.168.81.207:1521:orcl
|
|
#db1.url=jdbc:oracle:thin:@188.188.69.3:1521:orcl
|
|
#db1.url=jdbc:oracle:thin:@36.110.73.24:1521:orcl
|
|
db1.user=wms
|
|
db1.password=wms
|
|
#db1.user=i_srm
|
|
#db1.password=oracle
|
|
db1.initconns=10
|
|
db1.maxconns=60
|
|
db1.logintimeout=5
|
|
db1.loglevel=error
|
|
db1.databaseLogo=ORA-
|
|
db1.reserveTrailingZero=false
|
|
db1.sessionConfigStatement=ALTER SESSION SET nls_date_format='YY-MM-DD HH24:mi'
|
|
db1.datetimeFormat=yyyy/MM/dd HH:mm:ss
|
|
db1.sqlTypeForVarchar=999
|
|
db1.sqlTypeForDate=91
|
|
db1.sqlDeleteUserRightByGroup=MERGE INTO zc_yhmkqx A\n\
|
|
USING (SELECT A.yhm,B.mkbm,B.qx FROM zc_yhyhzxx A, ZC_YHZMKQX B WHERE A.yhzbm=? AND A.yhzbm=B.yhzbm) B\n\
|
|
ON (A.yhm=B.yhm AND A.mkbm=B.mkbm)\n\
|
|
WHEN MATCHED THEN\n\
|
|
UPDATE SET A.qx = BITAND(A.qx, (B.qx - 1) - BITAND(B.qx,-1) * 2)
|
|
db1.sqlAddUserRightByGroup=MERGE INTO zc_yhmkqx A\n\
|
|
USING (SELECT A.yhm,B.mkbm,B.qx FROM zc_yhyhzxx A, ZC_YHZMKQX B WHERE A.yhzbm=? AND A.yhzbm=B.yhzbm) B\n\
|
|
ON (A.yhm=B.yhm AND A.mkbm=B.mkbm)\n\
|
|
WHEN MATCHED THEN\n\
|
|
UPDATE SET A.qx = (A.qx + B.qx) - BITAND(A.qx, B.qx)
|
|
|
|
|
|
#db2.url=jdbc:oracle:thin:@192.168.100.8:1521/pdborcl
|
|
#db2.user=eas_mes
|
|
#db2.password=noblelift
|
|
#db2.initconns=0
|
|
#db2.maxconns=15
|
|
#db2.logintimeout=5
|
|
#db2.loglevel=error
|
|
#db2.databaseLogo=ORA-
|
|
#db2.reserveTrailingZero=false
|
|
#db2.sessionConfigStatement=ALTER SESSION SET nls_date_format='YY-MM-DD HH24:mi'
|
|
#db2.datetimeFormat=yyyy/MM/dd HH:mm:ss
|
|
#db2.sqlTypeForVarchar=999
|
|
#db2.sqlTypeForDate=91
|