로그인이 되지 않습니다.
- 작성자 :
- 유*만
- 작성일 :
- 2009-06-30 00:00:00
- 조회수 :
- 8,585
- 구분 :
- 공통컴포넌트
- 진행상태 :
- 완료
Q
2009-06-30 13:20:25,528 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:20:33,298 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:20:58,040 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:20:58,307 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:22:37,944 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table SYSLOG_ID.
2009-06-30 13:22:37,945 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:24:43,665 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:37:02,014 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:37:07,304 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:37:39,940 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table SYSLOG_ID.
2009-06-30 13:37:39,941 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:37:43,607 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
1) mysql 과 달리 오라클에 테이블 몇개가 없는듯 합니다.
-----------
COMVNUSERMASTER
IDS
--------------
2) 다음과 같이 에러가 발생합니다.
select * from COMTNEMPLYRINFO
TEST1 과 비밀번호 1을 입력했는데도 불구하구요?
--------------------------------------------
[egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table SYSLOG_ID.
2009-06-30 13:37:47,430 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:20:33,298 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:20:58,040 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:20:58,307 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:22:37,944 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table SYSLOG_ID.
2009-06-30 13:22:37,945 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:24:43,665 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:37:02,014 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:37:07,304 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:37:39,940 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table SYSLOG_ID.
2009-06-30 13:37:39,941 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
2009-06-30 13:37:43,607 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
1) mysql 과 달리 오라클에 테이블 몇개가 없는듯 합니다.
-----------
COMVNUSERMASTER
IDS
--------------
2) 다음과 같이 에러가 발생합니다.
select * from COMTNEMPLYRINFO
TEST1 과 비밀번호 1을 입력했는데도 불구하구요?
--------------------------------------------
[egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table SYSLOG_ID.
2009-06-30 13:37:47,430 DEBUG [egovframework.rte.fdl.idgnr.EgovIdGnrService] [IDGeneration Service] Allocating a new block of 1 ids for key_table WEBLOG_ID.
A
안녕하세요..
COMVNUSERMASTER는 View로서 Oracle용 테이블 생성파일에 누락되었습니다.
현재는 추가해서 반영해 놓았습니다.
참고로 다음 부분이 추가된 부분입니다..
--------------------------------
CREATE OR REPLACE FORCE VIEW COMVNUSERMASTER
(UNIQ_ID,USER_ID,PASSWORD,USER_NM,USER_ZIP,USER_ADRES,USER_EMAIL,GROUP_ID,USER_SE)
AS
SELECT
UNIQ_ID,MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES, GROUP_ID,USER_SE
FROM (
SELECT
UNIQ_ID,MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES,'' GROUP_ID,'GNR' AS USER_SE
FROM COMTNGNRLMBER
UNION ALL
SELECT
UNIQ_ID,EMPLYR_ID,PASSWORD,EMPLYR_NM,ZIP,HOMEADRES,EMAIL_ADRES,GROUP_ID,'ENT' AS USER_SE
FROM COMTNEMPLYRINFO
UNION ALL
SELECT UNIQ_ID,ENTRPRSMBER_ID,ENTRPRS_MBER_PASSWORD,CMPNY_NM,ZIP,ADRES,APPLCNT_EMAIL_ADRES,'','USR' AS USER_SE
FROM COMTNENTRPRSMBER
)
ORDER BY UNIQ_ID;
--------------------
그리고 IDS 테이블은 샘플용 테이블이기 때문에 생성하실 필요는 없으실 것 같습니다.
그럼.. 즐거운 하루 되십시오..
COMVNUSERMASTER는 View로서 Oracle용 테이블 생성파일에 누락되었습니다.
현재는 추가해서 반영해 놓았습니다.
참고로 다음 부분이 추가된 부분입니다..
--------------------------------
CREATE OR REPLACE FORCE VIEW COMVNUSERMASTER
(UNIQ_ID,USER_ID,PASSWORD,USER_NM,USER_ZIP,USER_ADRES,USER_EMAIL,GROUP_ID,USER_SE)
AS
SELECT
UNIQ_ID,MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES, GROUP_ID,USER_SE
FROM (
SELECT
UNIQ_ID,MBER_ID,PASSWORD,MBER_NM,ZIP,ADRES,MBER_EMAIL_ADRES,'' GROUP_ID,'GNR' AS USER_SE
FROM COMTNGNRLMBER
UNION ALL
SELECT
UNIQ_ID,EMPLYR_ID,PASSWORD,EMPLYR_NM,ZIP,HOMEADRES,EMAIL_ADRES,GROUP_ID,'ENT' AS USER_SE
FROM COMTNEMPLYRINFO
UNION ALL
SELECT UNIQ_ID,ENTRPRSMBER_ID,ENTRPRS_MBER_PASSWORD,CMPNY_NM,ZIP,ADRES,APPLCNT_EMAIL_ADRES,'','USR' AS USER_SE
FROM COMTNENTRPRSMBER
)
ORDER BY UNIQ_ID;
--------------------
그리고 IDS 테이블은 샘플용 테이블이기 때문에 생성하실 필요는 없으실 것 같습니다.
그럼.. 즐거운 하루 되십시오..
