Lightweight Designer 설치하기

Windows XP에 설치하기

Tomcat 서버를 사용한다.

1. copy folder /oracledilwd in ODI 설치 CD 
        - > #TOMCAT_PATH#/webapps/oracledilwd로 paste

2. ojdbc14.jar 파일 설정

3. master와 work Rep. 설정

 - MENUAL  ???

        - > META-INF/context.xml
        - > #TOMCAT_HOME#/conf/Catalina/localhost/oraclelwd.xml

<Context > 
    <Resource      
      name="jdbc/ORACLE_MASTER"
      type="javax.sql.DataSource"
      auth="Container"
      driverClassName="oracle.jdbc.OracleDriver"
      url="jdbc:oracle:thin:@SRV1:1521:ORA10"
      username="ODIM"
      password="ODIM"
      maxActive="8" 
      maxIdle="2"
      maxWait="15000"
      poolPreparedStatements="true"
      removeAbandoned="true"
      initialSize="2"
      removeAbandonedTimeout="1800"
/>
    <Resource
      name="jdbc/ORACLE_WORK"
      type="javax.sql.DataSource"
      auth="Container"
      driverClassName="oracle.jdbc.OracleDriver"
      url="jdbc:oracle:thin:@SRV1:1521:ORA10"
      username="ODIW"
      password="ODIW"
      maxActive="8" 
      maxIdle="2"
      maxWait="15000"
      poolPreparedStatements="true"
      removeAbandoned="true"
      initialSize="2"
      removeAbandonedTimeout="1800"
/>
</Context>
 
Parameters Details:
 - name is the datasource name
 - username and password in use in your database
 - driverClassName contains the JDBC class name in the driver
 - url contains the JDBC URLmaxActive contains the maximum number of simultaneous authorized connections
 - maxIdle contains the maximum number of simultaneous connections in idle state in the connection pool.

For more information, refer to the Apache Tomcat manual. These parameters should be adapted to the workload of your server.

  - CHEON's OPINION 

난 잘 모르겠고 이렇게 하니까 에러나서 더 단순한 방법을 사용하였음.
tomcat/conf/server.xml context 추가
<Context docBase="oracledilwd" path="/oracledilwd" reloadable="true"> 
    <Resource      
      name="jdbc/ORACLE_MASTER"
      type="javax.sql.DataSource"
      auth="Container"
      driverClassName="oracle.jdbc.OracleDriver"
      url="jdbc:oracle:thin:@SRV1:1521:ORA10"
      username="ODIM"
      password="ODIM"
      maxActive="8" 
      maxIdle="2"
      maxWait="15000"
      poolPreparedStatements="true"
      removeAbandoned="true"
      initialSize="2"
      removeAbandonedTimeout="1800"
/>
    <Resource
      name="jdbc/ORACLE_WORK"
      type="javax.sql.DataSource"
      auth="Container"
      driverClassName="oracle.jdbc.OracleDriver"
      url="jdbc:oracle:thin:@SRV1:1521:ORA10"
      username="ODIW"
      password="ODIW"
      maxActive="8" 
      maxIdle="2"
      maxWait="15000"
      poolPreparedStatements="true"
      removeAbandoned="true"
      initialSize="2"
      removeAbandonedTimeout="1800"
/>
</Context>

4. WEB-INF/web.xml 수정 (사용 레퍼런스 추가)

<resource-ref>

<description>Oracle Datasource for the Master Repository</description>
<res-ref-name>jdbc/ORACLE_MASTER</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Unshareable</res-sharing-scope>

</resource-ref>
<resource-ref>

<description>Oracle Datasource for the Work Repository</description>
<res-ref-name>jdbc/ORACLE_WORK</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Unshareable</res-sharing-scope>

</resource-ref>


5. repositories.xml 수정 (내가 사용할 Work Repository 명을 기입)

<login name="My Work Repository">

<master name="jdbc/ORACLE_MASTER" masterDriver="oracle.jdbc.OracleDriver"/>
<work name="jdbc/ORACLE_WORK" workName="CHEON_WORKREP"/>

</login>

6. Restart App.

<LightWeight Designer에 로그인한 페이지 화면>

성공적인 결과 화면을 볼 수 있었다.
하지만 Tomcat Server에 나타난 경고들

경고: Locale name in faces-config.xml null or empty, setting locale to default locale : ko_KR
2009. 3. 10 오전 11:47:31 org.apache.myfaces.renderkit.RenderKitFactoryImpl getRenderKit
경고: Unknown RenderKit 'HTML_BASIC'.
2009. 3. 10 오전 11:47:31 org.apache.myfaces.trinidadinternal.renderkit.core.CoreRenderKit _addBasicHTMLRenderKit
경고: Basic HTMLRenderKit could not be located
2009. 3. 10 오전 11:47:31 org.apache.myfaces.webapp.StartupServletContextListener initFaces

해결책을 알려주세요.