C++Builder Programming Forum
C++Builder  |  Delphi  |  FireMonkey  |  C/C++  |  Free Pascal  |  Firebird
볼랜드포럼 BorlandForum
 경고! 게시물 작성자의 사전 허락없는 메일주소 추출행위 절대 금지
C++빌더 포럼
Q & A
FAQ
팁&트릭
강좌/문서
자료실
컴포넌트/라이브러리
메신저 프로젝트
볼랜드포럼 홈
헤드라인 뉴스
IT 뉴스
공지사항
자유게시판
해피 브레이크
공동 프로젝트
구인/구직
회원 장터
건의사항
운영진 게시판
회원 메뉴
북마크
볼랜드포럼 광고 모집

C++빌더 Q&A
C++Builder Programming Q&A
[70251] Re:BCB6+Oracle 9i+TQuery
초행길 [] 19521 읽음    2013-10-22 07:27
상황을 잘 모르겠지만, 혹시, Connection Timeout  때문 아닌가요 ?
쓰신 내용글을 보면, 17:34 에는 정상이고, 19:49 는 에러인데, 2시간 15분 정도의 차이가 있어 보이네요....



민현호 님이 쓰신 글 :
: 안녕하세요..
:
: TQuery의 Edit/Post메소드로데이터를 변경하는 처리가
: 어떤때는 에러가 나고 어떤 때는 정상적으로 처리 되는
: 경우가  발생했습니다.
:
: SQL모니터로 확인한 로그입니다.
: 같은 처리인데 아래와 같이 정상일때가 있고 에러일때 가 있습니다..
: 무엇이 문제일까요??? 정말 모르겠습니다..
: 정상일 때는 9845    17:34:31  SQL Data In: ORACLE - Rows affected = 1
: 에러일때는 184422  19:49:36  SQL Data In: ORACLE - Rows affected = 0
:
:
: >>1. 정상일때는
: 9830    17:34:31  SQL Prepare: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL  AND "ACCS_DATE" IS NULL  AND "ACCS_TIME" IS NULL  AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
: 9831    17:34:31  SQL Data In: ORACLE - Param = 1, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:34:25
: 9832    17:34:31  SQL Data In: ORACLE - Param = 2, Name = TEST_ID, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 11.000000
: 9833    17:34:31  SQL Data In: ORACLE - Param = 3, Name = TT_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data =  ABS-2004  m0 12
: 9834    17:34:31  SQL Data In: ORACLE - Param = 4, Name = PRN_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 079461-2007
: 9835    17:34:31  SQL Data In: ORACLE - Param = 5, Name = SCOMMENT, Type = fldZSTRING, Precision = 16, Scale = 0, Data = -CM-000525
: 9836    17:34:31  SQL Data In: ORACLE - Param = 6, Name = INDATE, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2013/10/15
: 9837    17:34:31  SQL Data In: ORACLE - Param = 7, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:32:31
: 9838    17:34:31  SQL Data In: ORACLE - Param = 8, Name = BLK_CNT, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 0.000000
: 9839    17:34:31  SQL Data In: ORACLE - Param = 9, Name = LOCK_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
: 9840    17:34:31  SQL Data In: ORACLE - Param = 10, Name = USER_ID, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NLB-0042
: 9841    17:34:31  SQL Data In: ORACLE - Param = 11, Name = LIB_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
: 9842    17:34:31  SQL Data In: ORACLE - Param = 12, Name = TUNING_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 0.000000
: 9843    17:34:31  SQL Data In: ORACLE - Param = 13, Name = ROWID, Type = fldZSTRING, Precision = 18, Scale = 0, Data = AAAHefAAPAAABfaAAK
: 9844    17:34:31  SQL Execute: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL  AND "ACCS_DATE" IS NULL  AND "ACCS_TIME" IS NULL  AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
: 9845    17:34:31  SQL Data In: ORACLE - Rows affected = 1
: 9846    17:34:31  SQL Stmt: ORACLE - Close
:
: >>>2.에러 일때는
:
: 184407  19:49:36  SQL Prepare: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL  AND "ACCS_DATE" IS NULL  AND "ACCS_TIME" IS NULL  AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
: 184408  19:49:36  SQL Data In: ORACLE - Param = 1, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:49:36
: 184409  19:49:36  SQL Data In: ORACLE - Param = 2, Name = TEST_ID, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 11.000000
: 184410  19:49:36  SQL Data In: ORACLE - Param = 3, Name = TT_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data =  ABS-2004  m0 12
: 184411  19:49:36  SQL Data In: ORACLE - Param = 4, Name = PRN_NAME, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 079461-2007
: 184412  19:49:36  SQL Data In: ORACLE - Param = 5, Name = SCOMMENT, Type = fldZSTRING, Precision = 16, Scale = 0, Data = -CM-000525
: 184413  19:49:36  SQL Data In: ORACLE - Param = 6, Name = INDATE, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 2013/10/15
: 184414  19:49:36  SQL Data In: ORACLE - Param = 7, Name = INTIME, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:49:30
: 184415  19:49:36  SQL Data In: ORACLE - Param = 8, Name = BLK_CNT, Type = fldFLOAT, Precision = 4, Scale = 0, Data = 0.000000
: 184416  19:49:36  SQL Data In: ORACLE - Param = 9, Name = LOCK_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
: 184417  19:49:36  SQL Data In: ORACLE - Param = 10, Name = USER_ID, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NLB-0042
: 184418  19:49:36  SQL Data In: ORACLE - Param = 11, Name = LIB_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000
: 184419  19:49:36  SQL Data In: ORACLE - Param = 12, Name = TUNING_FLAG, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 0.000000
: 184420  19:49:36  SQL Data In: ORACLE - Param = 13, Name = ROWID, Type = fldZSTRING, Precision = 18, Scale = 0, Data = AAAHefAAPAAABfaAAK
: 184421  19:49:36  SQL Execute: ORACLE - UPDATE "TEST_HEAD" SET "INTIME"=:1 WHERE "TEST_ID"=:2 AND "TT_NAME"=:3 AND "PRN_NAME"=:4 AND "SCOMMENT"=:5 AND "INDATE"=:6 AND "INTIME"=:7 AND "BLK_CNT"=:8 AND "LOCK_FLAG"=:9 AND "USER_ID"=:10 AND "TEST_LIB_ID" IS NULL  AND "ACCS_DATE" IS NULL  AND "ACCS_TIME" IS NULL  AND "LIB_FLAG"=:11 AND "TUNING_FLAG"=:12 AND "ROWID"=:13
: 184422  19:49:36  SQL Data In: ORACLE - Rows affected = 0
: 184423  19:49:36  SQL Stmt: ORACLE - Close
:
:

+ -

관련 글 리스트
70237 BCB6+Oracle 9i+TQuery 민현호 22251 2013/10/16
70251     Re:BCB6+Oracle 9i+TQuery 초행길 19521 2013/10/22
Google
Copyright © 1999-2015, borlandforum.com. All right reserved.