Background Image

FORUM

2013.01.03 00:51

autocommit 설정

조회 수 5355 추천 수 0 댓글 2
?

단축키

Prev이전 문서

Next다음 문서

크게 작게 위로 아래로 댓글로 가기 인쇄

CUBRIDTransaction dbTrans = dbConn.BeginTransaction();

 

LOOP

     UPDATE TBL_POWER_NOW SET ????

 

dbTrans.Commit();

 

 

 

아래는 브로커 로그 입니다. 로그를 트랜잭션 기반으로  분석한건데 set_db_parameter auto_commit 1로 되어 있는거로 봐서는 위 프로그램

에서 트랜잭션을 쓰는 의미가 없을 듯 한데요 맞나요?

auto_commit 을 어떻게 off 시키나요? 

브로커마다 따로따로 설정 가능한가요?

 

 

C:CUBRID/log/broker/sql_log/xfra_broker_1.sql.log:32
01/02 15:32:43.921 (0) set_db_parameter auto_commit 1
01/02 15:32:43.921 (0) get_db_parameter isolation_level 1
01/02 15:32:43.921 (0) set_db_parameter isolation_level 1
01/02 15:32:43.921 (2) prepare 0 SELECT * FROM TBL_POWER_NOW
01/02 15:32:43.922 (2) prepare srv_h_id 1 (PC)
01/02 15:32:43.922 (2) set query timeout to 0 (no limit)
01/02 15:32:43.922 (2) execute srv_h_id 1 SELECT * FROM TBL_POWER_NOW
01/02 15:32:43.929 (2) execute 0 tuple 828 time 0.006
01/02 15:32:43.929 (2) fetch srv_h_id 1 cursor_pos 127 fetch_count 0
01/02 15:32:43.931 (2) fetch srv_h_id 1 cursor_pos 253 fetch_count 0
01/02 15:32:43.934 (2) fetch srv_h_id 1 cursor_pos 379 fetch_count 0
01/02 15:32:43.936 (2) fetch srv_h_id 1 cursor_pos 505 fetch_count 0
01/02 15:32:43.937 (2) fetch srv_h_id 1 cursor_pos 631 fetch_count 0
01/02 15:32:43.938 (2) fetch srv_h_id 1 cursor_pos 757 fetch_count 0
01/02 15:32:43.939 (2) next_result 1
01/02 15:32:43.939 (2) close_req_handle srv_h_id 1
01/02 15:32:43.940 (3) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=930, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=930, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=31
01/02 15:32:43.941 (3) prepare srv_h_id 1 (PC)
01/02 15:32:43.941 (3) set query timeout to 0 (no limit)
01/02 15:32:43.941 (3) execute srv_h_id 1 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=930, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=930, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=31
01/02 15:32:43.944 (3) execute 0 tuple 1 time 0.003
01/02 15:32:43.945 (4) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=937, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=937, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=32
01/02 15:32:43.945 (4) prepare srv_h_id 2 (PC)
01/02 15:32:43.945 (4) set query timeout to 0 (no limit)
01/02 15:32:43.945 (4) execute srv_h_id 2 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=937, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=937, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=32
01/02 15:32:43.948 (4) execute 0 tuple 1 time 0.003
01/02 15:32:43.949 (5) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=968, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=968, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=33
01/02 15:32:43.949 (5) prepare srv_h_id 3 (PC)
01/02 15:32:43.949 (5) set query timeout to 0 (no limit)
01/02 15:32:43.949 (5) execute srv_h_id 3 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=968, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=968, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=33
01/02 15:32:43.953 (5) execute 0 tuple 1 time 0.004
01/02 15:32:43.953 (6) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=935, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=935, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=34
01/02 15:32:43.954 (6) prepare srv_h_id 4 (PC)
01/02 15:32:43.954 (6) set query timeout to 0 (no limit)
01/02 15:32:43.954 (6) execute srv_h_id 4 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=935, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=935, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=34
01/02 15:32:43.957 (6) execute 0 tuple 1 time 0.003
01/02 15:32:43.957 (7) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=929, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=929, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=35
01/02 15:32:43.958 (7) prepare srv_h_id 5 (PC)
01/02 15:32:43.958 (7) set query timeout to 0 (no limit)
01/02 15:32:43.958 (7) execute srv_h_id 5 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=929, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=929, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=35
01/02 15:32:43.961 (7) execute 0 tuple 1 time 0.003
01/02 15:32:43.962 (8) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=950, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=36
01/02 15:32:43.962 (8) prepare srv_h_id 6 (PC)
01/02 15:32:43.962 (8) set query timeout to 0 (no limit)
01/02 15:32:43.962 (8) execute srv_h_id 6 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=950, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=36
01/02 15:32:43.966 (8) execute 0 tuple 1 time 0.004
01/02 15:32:43.966 (9) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=948, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=948, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=37
01/02 15:32:43.966 (9) prepare srv_h_id 7 (PC)
01/02 15:32:43.966 (9) set query timeout to 0 (no limit)
01/02 15:32:43.966 (9) execute srv_h_id 7 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=948, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=948, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=37
01/02 15:32:43.970 (9) execute 0 tuple 1 time 0.004
01/02 15:32:43.970 (10) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=902, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=902, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=38
01/02 15:32:43.971 (10) prepare srv_h_id 8 (PC)
01/02 15:32:43.971 (10) set query timeout to 0 (no limit)
01/02 15:32:43.971 (10) execute srv_h_id 8 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=902, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=902, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=38
01/02 15:32:43.974 (10) execute 0 tuple 1 time 0.003
01/02 15:32:43.974 (11) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=947, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=947, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=39
01/02 15:32:43.975 (11) prepare srv_h_id 9 (PC)
01/02 15:32:43.975 (11) set query timeout to 0 (no limit)
01/02 15:32:43.975 (11) execute srv_h_id 9 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=947, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=947, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=39
01/02 15:32:43.978 (11) execute 0 tuple 1 time 0.003
01/02 15:32:43.979 (12) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=965, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=965, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=40
01/02 15:32:43.979 (12) prepare srv_h_id 10 (PC)
01/02 15:32:43.979 (12) set query timeout to 0 (no limit)
01/02 15:32:43.979 (12) execute srv_h_id 10 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=965, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=965, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=40
01/02 15:32:43.983 (12) execute 0 tuple 1 time 0.004
01/02 15:32:43.983 (13) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=927, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=927, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=41
01/02 15:32:43.983 (13) prepare srv_h_id 11 (PC)
01/02 15:32:43.983 (13) set query timeout to 0 (no limit)
01/02 15:32:43.983 (13) execute srv_h_id 11 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=927, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=927, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=41
01/02 15:32:43.987 (13) execute 0 tuple 1 time 0.004
01/02 15:32:43.987 (14) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=954, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=954, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=42
01/02 15:32:43.987 (14) prepare srv_h_id 12 (PC)
01/02 15:32:43.988 (14) set query timeout to 0 (no limit)
01/02 15:32:43.988 (14) execute srv_h_id 12 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=954, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=954, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=42
01/02 15:32:43.991 (14) execute 0 tuple 1 time 0.003
01/02 15:32:43.991 (15) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=979, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=979, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=43
01/02 15:32:43.992 (15) prepare srv_h_id 13 (PC)
01/02 15:32:43.992 (15) set query timeout to 0 (no limit)
01/02 15:32:43.992 (15) execute srv_h_id 13 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=979, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=979, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=43
01/02 15:32:43.995 (15) execute 0 tuple 1 time 0.003
01/02 15:32:43.995 (16) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=935, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=935, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=44
01/02 15:32:43.996 (16) prepare srv_h_id 14 (PC)
01/02 15:32:43.996 (16) set query timeout to 0 (no limit)
01/02 15:32:43.996 (16) execute srv_h_id 14 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=935, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=935, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=44
01/02 15:32:43.999 (16) execute 0 tuple 1 time 0.003
01/02 15:32:43.999 (17) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=922, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=922, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=45
01/02 15:32:44.000 (17) prepare srv_h_id 15 (PC)
01/02 15:32:44.000 (17) set query timeout to 0 (no limit)
01/02 15:32:44.000 (17) execute srv_h_id 15 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=922, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=922, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=45
01/02 15:32:44.003 (17) execute 0 tuple 1 time 0.003
01/02 15:32:44.004 (18) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=920, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=920, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=46
01/02 15:32:44.004 (18) prepare srv_h_id 16 (PC)
01/02 15:32:44.004 (18) set query timeout to 0 (no limit)
01/02 15:32:44.004 (18) execute srv_h_id 16 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=920, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=920, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=46
01/02 15:32:44.008 (18) execute 0 tuple 1 time 0.004
01/02 15:32:44.008 (19) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=993, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=993, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=47
01/02 15:32:44.008 (19) prepare srv_h_id 17 (PC)
01/02 15:32:44.008 (19) set query timeout to 0 (no limit)
01/02 15:32:44.008 (19) execute srv_h_id 17 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=993, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=993, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=47
01/02 15:32:44.012 (19) execute 0 tuple 1 time 0.003
01/02 15:32:44.012 (20) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=957, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=957, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=48
01/02 15:32:44.013 (20) prepare srv_h_id 18 (PC)
01/02 15:32:44.013 (20) set query timeout to 0 (no limit)
01/02 15:32:44.013 (20) execute srv_h_id 18 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=957, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=957, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=48
01/02 15:32:44.016 (20) execute 0 tuple 1 time 0.003
01/02 15:32:44.016 (21) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=965, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=965, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=49
01/02 15:32:44.017 (21) prepare srv_h_id 19 (PC)
01/02 15:32:44.017 (21) set query timeout to 0 (no limit)
01/02 15:32:44.017 (21) execute srv_h_id 19 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=965, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=965, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=49
01/02 15:32:44.020 (21) execute 0 tuple 1 time 0.003
01/02 15:32:44.021 (22) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=951, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=951, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=50
01/02 15:32:44.021 (22) prepare srv_h_id 20 (PC)
01/02 15:32:44.021 (22) set query timeout to 0 (no limit)
01/02 15:32:44.021 (22) execute srv_h_id 20 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=951, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=951, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=50
01/02 15:32:44.025 (22) execute 0 tuple 1 time 0.004
01/02 15:32:44.025 (23) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=773, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=773, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=70
01/02 15:32:44.025 (23) prepare srv_h_id 21 (PC)
01/02 15:32:44.025 (23) set query timeout to 0 (no limit)
01/02 15:32:44.025 (23) execute srv_h_id 21 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=773, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=773, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=70
01/02 15:32:44.029 (23) execute 0 tuple 1 time 0.004
01/02 15:32:44.029 (24) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=790, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=790, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=71
01/02 15:32:44.029 (24) prepare srv_h_id 22 (PC)
01/02 15:32:44.030 (24) set query timeout to 0 (no limit)
01/02 15:32:44.030 (24) execute srv_h_id 22 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=790, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=790, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=71
01/02 15:32:44.033 (24) execute 0 tuple 1 time 0.003
01/02 15:32:44.033 (25) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=769, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=769, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=72
01/02 15:32:44.034 (25) prepare srv_h_id 23 (PC)
01/02 15:32:44.034 (25) set query timeout to 0 (no limit)
01/02 15:32:44.034 (25) execute srv_h_id 23 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=769, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=769, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=72
01/02 15:32:44.037 (25) execute 0 tuple 1 time 0.003
01/02 15:32:44.037 (26) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=945, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=945, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=1
01/02 15:32:44.038 (26) prepare srv_h_id 24 (PC)
01/02 15:32:44.038 (26) set query timeout to 0 (no limit)
01/02 15:32:44.038 (26) execute srv_h_id 24 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=945, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=945, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=1
01/02 15:32:44.041 (26) execute 0 tuple 1 time 0.003
01/02 15:32:44.042 (27) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=886, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=886, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=2
01/02 15:32:44.042 (27) prepare srv_h_id 25 (PC)
01/02 15:32:44.042 (27) set query timeout to 0 (no limit)
01/02 15:32:44.042 (27) execute srv_h_id 25 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=886, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=886, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=2
01/02 15:32:44.046 (27) execute 0 tuple 1 time 0.004
01/02 15:32:44.046 (28) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=950, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=3
01/02 15:32:44.046 (28) prepare srv_h_id 26 (PC)
01/02 15:32:44.046 (28) set query timeout to 0 (no limit)
01/02 15:32:44.046 (28) execute srv_h_id 26 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=950, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=3
01/02 15:32:44.050 (28) execute 0 tuple 1 time 0.004
01/02 15:32:44.050 (29) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=950, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=4
01/02 15:32:44.050 (29) prepare srv_h_id 27 (PC)
01/02 15:32:44.051 (29) set query timeout to 0 (no limit)
01/02 15:32:44.051 (29) execute srv_h_id 27 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=950, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=4
01/02 15:32:44.054 (29) execute 0 tuple 1 time 0.003
01/02 15:32:44.054 (30) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=959, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=959, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=5
01/02 15:32:44.055 (30) prepare srv_h_id 28 (PC)
01/02 15:32:44.055 (30) set query timeout to 0 (no limit)
01/02 15:32:44.055 (30) execute srv_h_id 28 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=959, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=959, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=5
01/02 15:32:44.058 (30) execute 0 tuple 1 time 0.003
01/02 15:32:44.058 (31) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=984, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=984, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=6
01/02 15:32:44.059 (31) prepare srv_h_id 29 (PC)
01/02 15:32:44.059 (31) set query timeout to 0 (no limit)
01/02 15:32:44.059 (31) execute srv_h_id 29 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=984, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=984, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=6
01/02 15:32:44.062 (31) execute 0 tuple 1 time 0.003
01/02 15:32:44.062 (32) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=921, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=921, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=7
01/02 15:32:44.063 (32) prepare srv_h_id 30 (PC)
01/02 15:32:44.063 (32) set query timeout to 0 (no limit)
01/02 15:32:44.063 (32) execute srv_h_id 30 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=921, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=921, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=7
01/02 15:32:44.066 (32) execute 0 tuple 1 time 0.003
01/02 15:32:44.066 (33) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=938, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=938, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=8
01/02 15:32:44.067 (33) prepare srv_h_id 31 (PC)
01/02 15:32:44.067 (33) set query timeout to 0 (no limit)
01/02 15:32:44.067 (33) execute srv_h_id 31 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=938, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=938, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=8
01/02 15:32:44.070 (33) execute 0 tuple 1 time 0.003
01/02 15:32:44.071 (34) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=973, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=973, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=9
01/02 15:32:44.071 (34) prepare srv_h_id 32 (PC)
01/02 15:32:44.071 (34) set query timeout to 0 (no limit)
01/02 15:32:44.071 (34) execute srv_h_id 32 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=973, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=973, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=9
01/02 15:32:44.075 (34) execute 0 tuple 1 time 0.004
01/02 15:32:44.075 (35) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=930, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=930, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=10
01/02 15:32:44.076 (35) prepare srv_h_id 33 (PC)
01/02 15:32:44.076 (35) set query timeout to 0 (no limit)
01/02 15:32:44.076 (35) execute srv_h_id 33 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=930, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=930, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=10
01/02 15:32:44.079 (35) execute 0 tuple 1 time 0.003
01/02 15:32:44.079 (36) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=959, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=959, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=11
01/02 15:32:44.080 (36) prepare srv_h_id 34 (PC)
01/02 15:32:44.080 (36) set query timeout to 0 (no limit)
01/02 15:32:44.080 (36) execute srv_h_id 34 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=959, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=959, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=11
01/02 15:32:44.083 (36) execute 0 tuple 1 time 0.003
01/02 15:32:44.083 (37) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=961, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=961, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=12
01/02 15:32:44.084 (37) prepare srv_h_id 35 (PC)
01/02 15:32:44.084 (37) set query timeout to 0 (no limit)
01/02 15:32:44.084 (37) execute srv_h_id 35 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=961, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=961, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=12
01/02 15:32:44.087 (37) execute 0 tuple 1 time 0.003
01/02 15:32:44.088 (38) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=977, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=977, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=13
01/02 15:32:44.088 (38) prepare srv_h_id 36 (PC)
01/02 15:32:44.088 (38) set query timeout to 0 (no limit)
01/02 15:32:44.088 (38) execute srv_h_id 36 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=977, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=977, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=13
01/02 15:32:44.092 (38) execute 0 tuple 1 time 0.004
01/02 15:32:44.092 (39) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=982, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=982, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=14
01/02 15:32:44.092 (39) prepare srv_h_id 37 (PC)
01/02 15:32:44.092 (39) set query timeout to 0 (no limit)
01/02 15:32:44.092 (39) execute srv_h_id 37 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=982, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=982, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=14
01/02 15:32:44.096 (39) execute 0 tuple 1 time 0.004
01/02 15:32:44.096 (40) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=932, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=932, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=15
01/02 15:32:44.096 (40) prepare srv_h_id 38 (PC)
01/02 15:32:44.096 (40) set query timeout to 0 (no limit)
01/02 15:32:44.096 (40) execute srv_h_id 38 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=932, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=932, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=15
01/02 15:32:44.100 (40) execute 0 tuple 1 time 0.004
01/02 15:32:44.100 (41) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=899, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=899, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=16
01/02 15:32:44.100 (41) prepare srv_h_id 39 (PC)
01/02 15:32:44.100 (41) set query timeout to 0 (no limit)
01/02 15:32:44.100 (41) execute srv_h_id 39 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=899, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=899, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=16
01/02 15:32:44.104 (41) execute 0 tuple 1 time 0.004
01/02 15:32:44.104 (42) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=934, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=934, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=17
01/02 15:32:44.104 (42) prepare srv_h_id 40 (PC)
01/02 15:32:44.105 (42) set query timeout to 0 (no limit)
01/02 15:32:44.105 (42) execute srv_h_id 40 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=934, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=934, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=17
01/02 15:32:44.108 (42) execute 0 tuple 1 time 0.003
01/02 15:32:44.108 (43) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=962, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=962, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=18
01/02 15:32:44.109 (43) prepare srv_h_id 41 (PC)
01/02 15:32:44.109 (43) set query timeout to 0 (no limit)
01/02 15:32:44.109 (43) execute srv_h_id 41 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=962, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=962, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=18
01/02 15:32:44.112 (43) execute 0 tuple 1 time 0.003
01/02 15:32:44.112 (44) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=996, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=996, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=19
01/02 15:32:44.113 (44) prepare srv_h_id 42 (PC)
01/02 15:32:44.113 (44) set query timeout to 0 (no limit)
01/02 15:32:44.113 (44) execute srv_h_id 42 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=996, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=996, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=19
01/02 15:32:44.116 (44) execute 0 tuple 1 time 0.003
01/02 15:32:44.116 (45) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=926, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=926, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=20
01/02 15:32:44.117 (45) prepare srv_h_id 43 (PC)
01/02 15:32:44.117 (45) set query timeout to 0 (no limit)
01/02 15:32:44.117 (45) execute srv_h_id 43 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=926, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=926, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=20
01/02 15:32:44.120 (45) execute 0 tuple 1 time 0.003
01/02 15:32:44.120 (0) end_tran COMMIT
01/02 15:32:44.120 (0) end_tran 0 time 0.000

 

 

 



 

 

 

  • ?
    이용미 2013.01.03 01:26

    안녕하세요.

    CUBRID 2008 R4.1 부터 $CUBRIDconfcubrid_broker.conf의 브로커별 파라미터로 CCI_DEFAULT_AUTOCOMMIT의 기본값이 ON으로 변경되었습니다.)

    트랜잭션으로 commit/rollback을 사용하기 위해서는 OFF로 설정해 주셔야 하며, 파라미터 값 변경 후, 브로커를 재구동 해 주셔야 해당 값이 적용됩니다.

    CCI_DEFALUT_AUTOCOMMIT에 대한 자세한 설명은 아래 매뉴얼을 참고해 주세요.

    매뉴얼 : http://www.cubrid.com/online_manual/841/pm/pm_broker_one.htm

     

    참고로, CCI API로 개발된 PHP, ODBC, OLEDB등의 인터페이스를 사용하는 프로그램에만 영향을 미치며, JDBC로 개발된 응용은 해당 파라미터와 관련이 없습니다

  • ?
    바람바람 2013.01.03 01:53

    답변 감사합니다.

    c#으로 프로그램 만들고 있는데

    ADO.Net은 적용 안되나요? OLEDB를 사용해야 하나요?


List of Articles
번호 제목 글쓴이 날짜 조회 수
공지 SQLGate for CUBRID 영구 무료 라이선스 제공 file admin 2020.04.09 4278
1356 PHP 5.4.10 에서 드라이브 연동이안됩니다. 5 kudoz 2013.01.15 7410
1355 CLOB 데이터 타입 질문 1 하늘같은바다 2013.01.15 7228
1354 웹 매니져 설치 질문 3 file kudoz 2013.01.15 8647
1353 큐브리드 매니저 접속 관련 문의 5 secret 하늘같은바다 2013.01.14 33
1352 데이터베이스 백업 관련 문의입니다. 1 하늘같은바다 2013.01.14 5719
1351 쿼리 관련 문의 드립니다. 2 오니오니 2013.01.09 6064
1350 HA 구성 관련하여 문의 드립니다. 내용보충!! 1 secret 장경수 2013.01.08 8
1349 ㅠ.ㅠ 안되는 autocommit off 2 바람바람 2013.01.03 10861
» autocommit 설정 2 바람바람 2013.01.03 5355
1347 호스트 연결이 안됩니다. 3 file 미드소나 2013.01.01 7746
1346 & 등의 특수문자등이 변환되어 저장되는 경우 1 호랑이야옹 2012.12.28 10671
1345 데이터 볼륨 자동 추가 로그 생성 안됨 3 종이 2012.12.27 7675
1344 statdump 추가추가 질문입니다. 2 오니오니 2012.12.21 5626
1343 (1개의 댓글은 작성자가 썼습니다.)비주얼 베이직 큐브리드 연동후 동시에 여러 테이블 보는 방법문의 2 secret 강남우 2012.12.21 58
1342 c# 에서 개발 중인데 쿼리 처리속도가 느리네요(수정) 5 yak341 2012.12.20 22686
1341 혹시 큐브리드 매니져 기본글꼴을 고정폭으로 해주실 생각은 없으신가요... 1 안지민 2012.12.20 5762
1340 HA 구성 관련하여 문의 드립니다. 4 secret 장경수 2012.12.19 14
1339 oledbprovider 7 yak341 2012.12.18 6283
1338 상위버전에서 백업받은 파일을 하위버전에서 복원하는 방법? 1 보요 2012.12.14 9199
1337 시간계산 문제 1 큐빅 2012.12.13 13482
Board Pagination Prev 1 ... 127 128 129 130 131 132 133 134 135 136 ... 199 Next
/ 199

Contact Cubrid

대표전화 070-4077-2110 / 기술문의 070-4077-2113 / 영업문의 070-4077-2112 / Email. contact_at_cubrid.com
Contact Sales