ibatis DataSource

Frameworks/iBATIS | 2009/01/09 10:18 | 830801

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMapConfig     
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"     
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>

  <transactionManager type="JDBC" commitRequired="false">
    <dataSource type="JNDI">
     <property name="DataSource" value="java:comp/env/jdbc/oracle"/>
    </dataSource>
  </transactionManager>

  <sqlMap resource="com/mydomain/data/Member.xml"/>


</sqlMapConfig>

sequence 생성 & 삭제

Oracle | 2009/01/09 09:56 | 830801

drop sequence board_seq;

create sequence board_seq;

태그 : SEQUENCE

ibatis 시작하기

Frameworks/iBATIS | 2009/01/08 10:16 | 830801

http://ibatis.apache.org =>

 

다운로드

http://mirror.apache-kr.org/ibatis/binaries/ibatis.java/ibatis-2.3.4.726.zip

압축푼 후 ibatis-2.3.4.726\lib\ibatis-2.3.4.726.jar(3개 jar이 포함)

 

1. 이클립스에 lib추가

2. C:\Java\ibatis-2.3.4.726\simple_example에 com폴더를 이클립스 src에 넣어준다.

 

SimpleExample(DAO클래스 역활을 한다)

-------------------------------------------------------------------------------------

■ SqlMapConfig.xml (수정)

-------------------------------------------------------------------------------------

<transactionManager type="JDBC" commitRequired="false">
    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver"/>
      <property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
      <property name="JDBC.Username" value="scott"/>
      <property name="JDBC.Password" value="tiger"/>
    </dataSource>
  </transactionManager>

-------------------------------------------------------------------------------------

http://download2.bea.com/pub/platform/81

http://download2.bea.com/pub/platform/81/server816_win32.exe

 

C:/bea/user_projects/domains/mydomain

C:/bea/user_projects/domains/mydomain/startWebLogic.cmd

C:/bea/user_projects/domains/mydomain/stopWebLogic.cmd

 

 

===================================================================================

startWebLogic.com (수정)

===================================================================================

set PRODUCTION_MODE =           =>       set PRODUCTION_MODE = false

 

===================================================================================

jar cvf ejb_exam01.war *.*

Weblogic 실행방법

1. 이클립스
2. war파일


C:\bea\weblogic81\server\lib\weblogic.jar

1. web.xml에 다음내용을 추가한다.

 <!-- Standard Action Servlet Configuration -->
  <servlet>
    <servlet-name>action</servlet-name>
    <servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
    <init-param>
      <param-name>config</param-name>
      <param-value>/WEB-INF/struts-config.xml</param-value>
    </init-param>
    <load-on-startup>2</load-on-startup>
 </servlet>


  <!-- Standard Action Servlet Mapping -->
  <servlet-mapping>
    <servlet-name>action</servlet-name>
    <url-pattern>*.do</url-pattern>
  </servlet-mapping>

 

2. validation.xml, struts-config.xml 파일을 WEB-INF안에 복사해서 붙여 넣는다.

 

3. 다음 라이브러리(.jar파일 10개)을 WEB-INF/lib 폴더 안에 넣어준다.
 - antlr-2.7.2.jar
 - commons-beanutils.jar
 - commons-chain-1.2.jar
 - commons-digester-1.8.jar
 - commons-logging-1.0.4.jar
 - commons-validator-1.3.1.jar
 - oro-2.0.8.jar
 - struts-core-1.3.10.jar
 - struts-taglib-1.3.10.jar
 - struts-title-1.3.10.jar

 

* struts-config.xml 설정하기
<action-mappings>
 <action path="/hello" type="hello.HelloAction"> // path=>.do를 제외한 이름을 넣어 준다.

type=>Action클래스가 있는 경로를 설정한다.
  <forward name="greet" path="/hello_res.jsp"/> // name=> 응답 결과(Action 클래스는 ActionForward타

입 객체를 리턴한다.), path=>호츨 할 페이지를 넣어준다.
 </action>
</action-mappings>

이전 1 2 3 4 5 6 7 8 ... 9 다음