오늘도 행복하다.

1. Import LowFareAir.war
2. Import derbyclient.jar, jstl.jar, standard.jar
3. Import /data/airlinesDB/
4. Import /devlib/derby.jar, derbynet.jar, derbyrun.jar
5. build.xml : Derby를 서버로 구동시키는 Ant 스크립트, derby.properties
   
6. web.xml 수정 : 데이터베이스 경로, 사용자/암호
   
7. com.ibm.sample.DerbyDatabase.java 수정 : 데이터베이스 경로, 사용자/암호
8. Data Source Explorer에 Derby 설정
9. Tomcat 시작

<context-param>
	<param-name>javax.servlet.jsp.jstl.sql.dataSource</param-name>
	<param-value>
		jdbc:derby://localhost:1527/data/airlinesDB;user=USER;password=PASSWORD,
		org.apache.derby.jdbc.ClientDriver
	</param-value>
</context-param>

• Database 접속 설정하기
• 테이블 생성
• SQL 실행
• 데이터 입력하고 저장하기

• Configure default JPA implementation library
• Ganymede 에서 실행했음.
• orm.xml 은 생성되지 않도록 하자

@Entity
@Table(schema="baseball", name = "players")
public class Player implements Serializable {
	@Id
	@GeneratedValue(strategy=IDENTITY)
	private int id;

	@Column(name="First_Name")
	private String firstName;

	@Column(name="Last_Name")
	private String lastName;
        
	//setter and getter
}

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
	<persistence-unit name="baseball">
		<class>org.developerworks.baseball.Player</class>
		<properties>
			<property name="openjpa.ConnectionURL" value="jdbc:mysql://localhost:3306/baseball"/>
			<property name="openjpa.ConnectionDriverName" value="com.mysql.jdbc.Driver"/>
			<property name="openjpa.ConnectionUserName" value="team"/>
		    <property name="openjpa.ConnectionPassword" value="1234"/>
		    <property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/>
		</properties>
	</persistence-unit>
</persistence>

EntityManagerFactory factory = Persistence.createEntityManagerFactory("baseball");
EntityManager em = factory.createEntityManager();
List<Player> players = em.createQuery("SELECT p FROM Player p").getResultList();
for(Player player : players){
	System.out.println(player.getFirstName());
}

• openjpa-1.2.1.jar : User Libraries로 추가
  
• geronimo-jpa_3.0_spec-1.0.jar : JPA 구현체
  
• geronimo-jta_1.1_spec-1.1.jar
• serp-1.13.1.jar
• commons-collections-3.2.jar
• commons-lang-2.1.jar