# -------------------------------------- # 디자인시 데이터베이스 연결 설정 - 시작 # 절대 수정하지 마세요! (편집 불가) # -------------------------------------- rex.service.0 = 9 rex.service.1 = ORACLE rex.service.2 = SQLSERVER rex.service.3 = SQLSERVER2005 rex.service.4 = DB2 rex.service.5 = JDBC rex.service.6 = JNDI rex.service.7 = ODBC rex.service.8 = SAP rex.service.9 = SYBASE rex.service.ORACLE.0 = 6 rex.service.ORACLE.1.key = Driver rex.service.ORACLE.1.value = oracle.jdbc.driver.OracleDriver rex.service.ORACLE.2.key = Connection rex.service.ORACLE.2.value = jdbc:oracle:thin:@124.137.28.170:1521:orcl rex.service.ORACLE.3.key = User rex.service.ORACLE.3.value = scott rex.service.ORACLE.4.key = Password rex.service.ORACLE.4.value = tiger rex.service.ORACLE.5.key = DefaultSchema rex.service.ORACLE.5.value = rex.service.ORACLE.6.key = NLS rex.service.ORACLE.6.value = rex.service.SQLSERVER.0 = 6 rex.service.SQLSERVER.1.key = Driver rex.service.SQLSERVER.1.value = com.microsoft.jdbc.sqlserver.SQLServerDriver rex.service.SQLSERVER.2.key = Connection rex.service.SQLSERVER.2.value = jdbc:microsoft:sqlserver://124.137.28.170:1433;DatabaseName=northwind rex.service.SQLSERVER.3.key = User rex.service.SQLSERVER.3.value = sa rex.service.SQLSERVER.4.key = Password rex.service.SQLSERVER.4.value = clip815mail rex.service.SQLSERVER.5.key = DefaultSchema rex.service.SQLSERVER.5.value = rex.service.SQLSERVER.6.key = NLS rex.service.SQLSERVER.6.value = rex.service.SQLSERVER2005.0 = 6 rex.service.SQLSERVER2005.1.key = Driver rex.service.SQLSERVER2005.1.value = com.microsoft.sqlserver.jdbc.SQLServerDriver rex.service.SQLSERVER2005.2.key = Connection rex.service.SQLSERVER2005.2.value = jdbc:sqlserver://ipaddress:1433;DatabaseName=northwind rex.service.SQLSERVER2005.3.key = User rex.service.SQLSERVER2005.3.value = rex.service.SQLSERVER2005.4.key = Password rex.service.SQLSERVER2005.4.value = rex.service.SQLSERVER2005.5.key = DefaultSchema rex.service.SQLSERVER2005.5.value = rex.service.SQLSERVER2005.6.key = NLS rex.service.SQLSERVER2005.6.value = rex.service.DB2.0 = 6 rex.service.DB2.1.key = Driver rex.service.DB2.1.value = com.ibm.db2.jcc.DB2Driver #rex.service.DB2.1.value = COM.ibm.db2.jdbc.app.DB2Driver #rex.service.DB2.1.value = com.ibm.db2.jcc.DB2Driver rex.service.DB2.2.key = Connection rex.service.DB2.2.value = jdbc:db2:sample # jdbc:db2:sample # jdbc:db2://localhost:50000/sample rex.service.DB2.3.key = User rex.service.DB2.3.value = db2admin rex.service.DB2.4.key = Password rex.service.DB2.4.value = db2admin rex.service.DB2.5.key = DefaultSchema rex.service.DB2.5.value = rex.service.DB2.6.key = NLS rex.service.DB2.6.value = rex.service.JDBC.0 = 6 rex.service.JDBC.1.key = Driver rex.service.JDBC.1.value = mycompany.jdbc.driver.myDriver rex.service.JDBC.2.key = Connection rex.service.JDBC.2.value = jdbc:mydrivertype:@myserver rex.service.JDBC.3.key = User rex.service.JDBC.3.value = my user id rex.service.JDBC.4.key = Password rex.service.JDBC.4.value = my password rex.service.JDBC.5.key = DefaultSchema rex.service.JDBC.5.value = rex.service.JDBC.6.key = NLS rex.service.JDBC.6.value = rex.service.JNDI.0 = 4 rex.service.JNDI.1.key = JNDI rex.service.JNDI.1.value = myjndi rex.service.JNDI.2.key = DatabaseType rex.service.JNDI.2.value = DB2 rex.service.JNDI.3.key = DefaultSchema rex.service.JNDI.3.value = rex.service.JNDI.4.key = NLS rex.service.JNDI.4.value = rex.service.ODBC.0 = 6 rex.service.ODBC.1.key = Driver rex.service.ODBC.1.value = sun.jdbc.odbc.JdbcOdbcDriver rex.service.ODBC.2.key = Connection rex.service.ODBC.2.value = jdbc:odbc:mysystemdsn rex.service.ODBC.3.key = User rex.service.ODBC.3.value = rex.service.ODBC.4.key = Password rex.service.ODBC.4.value = rex.service.ODBC.5.key = DefaultSchema rex.service.ODBC.5.value = rex.service.ODBC.6.key = NLS rex.service.ODBC.6.value = rex.service.SAP.0 = 8 rex.service.SAP.1.key = Client rex.service.SAP.1.value = 000 rex.service.SAP.2.key = User rex.service.SAP.2.value = BCUSER rex.service.SAP.3.key = Password rex.service.SAP.3.value = minisap rex.service.SAP.4.key = Language rex.service.SAP.4.value = EN rex.service.SAP.5.key = HostName rex.service.SAP.5.value = 124.137.28.186 rex.service.SAP.6.key = SystemNumber rex.service.SAP.6.value = 00 rex.service.SAP.7.key = Group rex.service.SAP.7.value = rex.service.SAP.8.key = NLS rex.service.SAP.8.value = rex.service.SYBASE.0 = 6 rex.service.SYBASE.1.key = Driver rex.service.SYBASE.1.value = com.sybase.jdbc3.jdbc.SybDriver rex.service.SYBASE.2.key = Connection rex.service.SYBASE.2.value = jdbc:sybase:Tds:10.182.54.23:5000 rex.service.SYBASE.3.key = User rex.service.SYBASE.3.value = userid rex.service.SYBASE.4.key = Password rex.service.SYBASE.4.value = passwd rex.service.SYBASE.5.key = DefaultSchema rex.service.SYBASE.5.value = rex.service.SYBASE.6.key = NLS rex.service.SYBASE.6.value = # ----------------------------------- # 디자인시 데이터베이스 연결 설정 - 끝 # ----------------------------------- # ----------------------------------- # 실행시 데이터베이스 연결 설정 - 시작 # 사용자 정의(편집 가능) # ----------------------------------- rex.userservice.default = comdb rex.userservice.0 = 8 rex.userservice.1 = jdbc.comdb rex.userservice.2 = jdbc.emrdb rex.userservice.3 = jdbc.astdb rex.userservice.4 = jdbc.lisdb rex.userservice.5 = jdbc.misdb rex.userservice.6 = jdbc.pamdb rex.userservice.7 = jdbc.cendb rex.userservice.8 = jdbc.stsdb rex.userservice.jdbc.comdb = ORACLE rex.userservice.jdbc.comdb.Driver = oracle.jdbc.driver.OracleDriver rex.userservice.jdbc.comdb.Connection = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn2adsp1)(PORT=1521))(CONNECT_DATA=(SID=HIS031))) rex.userservice.jdbc.comdb.User = comu01 rex.userservice.jdbc.comdb.Password = comu01 rex.userservice.jdbc.comdb.DefaultSchema = rex.userservice.jdbc.comdb.NLS = rex.userservice.jdbc.emrdb = ORACLE rex.userservice.jdbc.emrdb.Driver = oracle.jdbc.driver.OracleDriver rex.userservice.jdbc.emrdb.Connection = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn2adsp1)(PORT=1521))(CONNECT_DATA=(SID=HIS031))) rex.userservice.jdbc.emrdb.User = hisu01 rex.userservice.jdbc.emrdb.Password = hisu01 rex.userservice.jdbc.emrdb.DefaultSchema = rex.userservice.jdbc.emrdb.NLS = rex.userservice.jdbc.astdb = ORACLE rex.userservice.jdbc.astdb.Driver = oracle.jdbc.driver.OracleDriver rex.userservice.jdbc.astdb.Connection = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn2adsp1)(PORT=1521))(CONNECT_DATA=(SID=HIS031))) rex.userservice.jdbc.astdb.User = hisu01 rex.userservice.jdbc.astdb.Password = hisu01 rex.userservice.jdbc.astdb.DefaultSchema = rex.userservice.jdbc.astdb.NLS = rex.userservice.jdbc.lisdb = ORACLE rex.userservice.jdbc.lisdb.Driver = oracle.jdbc.driver.OracleDriver rex.userservice.jdbc.lisdb.Connection = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn2adsp1)(PORT=1521))(CONNECT_DATA=(SID=HIS031))) rex.userservice.jdbc.lisdb.User = hisu01 rex.userservice.jdbc.lisdb.Password = hisu01 rex.userservice.jdbc.lisdb.DefaultSchema = rex.userservice.jdbc.lisdb.NLS = rex.userservice.jdbc.misdb = ORACLE rex.userservice.jdbc.misdb.Driver = oracle.jdbc.driver.OracleDriver rex.userservice.jdbc.misdb.Connection = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn2adsp1)(PORT=1521))(CONNECT_DATA=(SID=MIS030))) rex.userservice.jdbc.misdb.User = misu01 rex.userservice.jdbc.misdb.Password = misu01 rex.userservice.jdbc.misdb.DefaultSchema = rex.userservice.jdbc.misdb.NLS = rex.userservice.jdbc.pamdb = ORACLE rex.userservice.jdbc.pamdb.Driver = oracle.jdbc.driver.OracleDriver rex.userservice.jdbc.pamdb.Connection = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn2adsp1)(PORT=1521))(CONNECT_DATA=(SID=HIS031))) rex.userservice.jdbc.pamdb.User = hisu01 rex.userservice.jdbc.pamdb.Password = hisu01 rex.userservice.jdbc.pamdb.DefaultSchema = rex.userservice.jdbc.pamdb.NLS = rex.userservice.jdbc.cendb = ORACLE rex.userservice.jdbc.cendb.Driver = oracle.jdbc.driver.OracleDriver rex.userservice.jdbc.cendb.Connection = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn2adsp1)(PORT=1521))(CONNECT_DATA=(SID=CEN030))) rex.userservice.jdbc.cendb.User = cenu01 rex.userservice.jdbc.cendb.Password = cenu01 rex.userservice.jdbc.cendb.DefaultSchema = rex.userservice.jdbc.cendb.NLS = rex.userservice.jdbc.stsdb = ORACLE rex.userservice.jdbc.stsdb.Driver = oracle.jdbc.driver.OracleDriver rex.userservice.jdbc.stsdb.Connection = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kn2adsp1)(PORT=1521))(CONNECT_DATA=(SID=HIS031))) rex.userservice.jdbc.stsdb.User = stsu01 rex.userservice.jdbc.stsdb.Password = stsu01 rex.userservice.jdbc.stsdb.DefaultSchema = rex.userservice.jdbc.stsdb.NLS = # ----------------------------------- # 실행시 데이터베이스 연결 설정 - 끝 # ----------------------------------- # ----------------------------------- # 데이터 타입 정의 - 시작 # 사용자 정의(편집 가능) # ----------------------------------- #rex.datatype.direction = server #rex.datatype.direction = client #rex.datatype = XML rex.datatype = CSV rex.datatype.CSV.separator.dataset = |@| rex.datatype.CSV.separator.column = |*| rex.datatype.CSV.separator.row = # ----------------------------------- # 데이터 타입 정의 - 끝 # ----------------------------------- # ----------------------------------- # 로그 정의 - 시작 # 사용자 정의(편집 가능) # ----------------------------------- # Log Configuration Information rex.logger.driver = RexService.CRexDefaultLoggerWriter rex.logger.autoflush = true # 로그 파일 저장 디렉토리 #rex.logger.dir = /path/test rex.logger.dir = D:\\Logs # Logging Trace Level ( SYS, ERR, WARN, INFO, DEBUG, DBWRAP ) rex.logger.sys.trace = false rex.logger.err.trace = true rex.logger.warn.trace = false rex.logger.info.trace = false rex.logger.debug.trace = false # ----------------------------------- # 로그 정의 - 끝 # ----------------------------------- # ----------------------------------- # Flush 정의 - 시작 # 사용자 정의(편집 가능) # ----------------------------------- rex.data.flush = True #rex.data.flush = False rex.data.flush.rowcount = 10 # ----------------------------------- # Flush 정의 - 끝 # ----------------------------------- # ---------------------------------------------------------- # CharacterSet, Content-Type, encoding/decoding 정의 - 시작 # 사용자 정의(편집 가능) # ---------------------------------------------------------- rex.nls.default = euckr rex.nls.0 = 4 rex.nls.1 = euckr rex.nls.2 = iso8859 rex.nls.3 = utf8 rex.nls.4 = utf16 # 일반적인 셋팅 rex.nls.euckr.encoding.xml = EUC-KR rex.nls.euckr.contenttype.xml = text/xml;charset=EUC-KR rex.nls.euckr.contenttype.csv = text/html;charset=EUC-KR rex.nls.euckr.encoding.data.from = rex.nls.euckr.encoding.data.to = rex.nls.euckr.decoding.data.from = rex.nls.euckr.decoding.data.to = #rex.nls.euckr.decoding.EscapeToUnicode = 10 #rex.nls.euckr.decoding.EscapeToUnicode = 16 #rex.nls.euckr.decoding.EscapeToUnicode.field = HANJA1,HANJA2,HANJA3 #rex.nls.euckr.decoding.EscapeToUnicode.field = nm # oracle charset이 english일 때 셋팅 (ex, 중고원) rex.nls.iso8859.encoding.xml = rex.nls.iso8859.contenttype.xml = text/xml;charset=UTF-8 rex.nls.iso8859.contenttype.csv = text/html;charset=EUC-KR rex.nls.iso8859.encoding.data.from = EUC-KR rex.nls.iso8859.encoding.data.to = ISO-8859-1 rex.nls.iso8859.decoding.data.from = ISO-8859-1 rex.nls.iso8859.decoding.data.to = EUC-KR # 일반적인 셋팅 rex.nls.utf8.encoding.xml = UTF-8 rex.nls.utf8.contenttype.xml = text/xml;charset=UTF-8 rex.nls.utf8.contenttype.csv = text/html;charset=UTF-8 rex.nls.utf8.encoding.data.from = rex.nls.utf8.encoding.data.to = rex.nls.utf8.decoding.data.from = rex.nls.utf8.decoding.data.to = #rex.nls.utf8.decoding.EscapeToUnicode = 10 #rex.nls.utf8.decoding.EscapeToUnicode = 16 #rex.nls.utf8.decoding.EscapeToUnicode.field = HANJA1,HANJA2,HANJA3 #rex.nls.utf8.decoding.EscapeToUnicode.field = nm # 일반적인 셋팅 rex.nls.utf16.encoding.xml = UTF-16 rex.nls.utf16.contenttype.xml = text/xml;charset=UTF-16 rex.nls.utf16.contenttype.csv = text/html;charset=UTF-16 rex.nls.utf16.encoding.data.from = rex.nls.utf16.encoding.data.to = rex.nls.utf16.decoding.data.from = rex.nls.utf16.decoding.data.to = # ---------------------------------------------------------- # CharacterSet, Content-Type, encoding/decoding 정의 - 끝 # ---------------------------------------------------------- # ---------------------------------------------------------- # DB필드 암호화 복호화 정의 - 시작 # 사용자 정의(편집 가능) # ---------------------------------------------------------- #rex.crypto.dbfield.encode.factory = RexService.CUserCbCrypto #rex.crypto.dbfield.encode.field = CompanyName,City #rex.crypto.dbfield.decode.factory = RexService.CUserCbCrypto #rex.crypto.dbfield.decode.field = CompanyName,City # ------------------------- # DB필드 암호화 복호화 정의 - 끝 # ------------------------- # ---------------------------------------------------------- # Web 암호화 복호화 정의 - 시작 # 사용자 정의(편집 가능) # ---------------------------------------------------------- #rex.crypto.web.factory = RexService.CUserXecureWebCrypto #rex.crypto.web.factory = RexService.CRexWebCrypto 풀기 #rex.crypto.web.decode = true 풀기 #rex.crypto.web.encode = true #rex.crypto.web.encodeperflush = true #rex.crypto.web.encodeperflush.separator = |!| # ------------------------- # DB필드 암호화 복호화 정의 - 끝 # -------------------------