開発時と稼働時の接続情報は異なる#

1. 開発時に使うDB接続は「Database Connections」で設定する。
2. 稼働時の接続方法は2通りある。以下のうち1を推奨。
   1. アプリケーションサーバー上(WildFlyのこと、以下APサーバー)で設定する。(WildFly上のデータソースとpersistence.xmlでの設定)
   2. アプリケーション個別で設定する(warファイルに含める)。(persistence.xmlとwebアプリケーション-ds.xmlでの設定)

共通する設定#

MySQLのJDBCドライバをダウンロードする#

APサーバー上に定義したデータソース経由でRDBに接続する場合 (推奨)#

1. 5.1系の最新をダウンロードする。2016年4月時点では5.1.38。
   https://dev.mysql.com/downloads/connector/j/
2. ダウンロードしたファイルを展開する。
3. mysql-connector-java-5.1.38.jarファイルをeclipseフォルダの横並びに配置する。(配下ではなく)
   例えば、mysqljdbc\mysql-connector-java-5.1.38.jar
4. APサーバー(WildFly)にjarファイルをデプロイする。(手順は後述)

アプリケーション(warファイル内)で定義した設定でRDBに接続する場合#

1. プロジェクトのpom.xmlをエディタで開き、DependenciesタブでAddボタンを押す
2. 次のように入力する。 Artifact Idは mysql-connector-java。Versionにはその時点での最新を記述する。
3. pom.xmlファイルを保存する
4. 以下のフォルダ配下にjarファイルが出来ていればOK。
   *あなたのユーザーフォルダ\.m2\repository\mysql\mysql-connector-java

1. Project Explorerでプロジェクトを選択して右ボタンクリック。
2. Maven → Update Project を実行する。

開発時のDB接続設定#

Database ConnectionsにMySQLサーバーへの接続情報を設定する#

1. Window→Perspective → Open Perspective → Other を開く
2. JPAを選択する

1. 開いた中のData Source Explorerをクリック
2. Database Connectionsを右ボタンクリック
3. Newをクリック

1. Connection Profile TypeからMySQLを選択する
2. Nextボタンを押す。

1. Drivers選択リストの右にある「+」アイコンを押す。
2. Name/Typeタブにて5.1(またはさらに新しいもの)をクリックする。
3. 表示された画面のDriver nameに「MySQL JDBC Driver5.1.38」と記入する。バージョン番号は適宜換える。
4. JAR Listタブを押す。
5. Driver Filesに表示されている「mysql-connector-java-5.1.0-bin.jar」を削除する。
6. Add JAR/ZIP ボタンを押す。
7. 表示されたファイルオープンダイアログにてダウンロードしておいたmysql-connector-java-5.1.38.jarを選択する。

1. OKボタンを押す。

1. 上記画面のそれぞれで接続情報を入力する。
2. Test Connectionボタンを押して「Ping Succeeded!」と表示されれば成功。エラーが表示された場合はDBが起動されているか、接続情報を誤っていないか確認する。
3. Finishボタンを押す。
4. 下記画面が表示されれば完了。

Javax.transaction APIをMavenに記述する#

1. CDI管理下のテーブル更新では@Transactionalアノテーションが必要。
2. @Transactionalアノテーションをビルドするためには、Jboss Toolsに入っていないJavax.transaction APIの取得が必要。

1. pom.xml の<dependencies>配下に以下を追加する。

    <dependency>
        <groupId>javax.transaction</groupId>
        <artifactId>javax.transaction-api</artifactId>
        <version>1.2</version>
    </dependency>

jboss-web.xmlにエンコーディングを記述する#

1. WEB-INF 直下に以下の内容の jboss-web.xml ファイルを配置する。

<?xml version="1.0" encoding="UTF-8"?>
<jboss-web>
	<default-encoding>UTF-8</default-encoding>
</jboss-web>

稼働時のDB接続設定#

アプリケーションサーバーの設定によってDBに接続する (推奨)#

JDBCドライバのデプロイ#

1. EclipseのServers窓にてWildFlyを起動する。
2. ブラウザにて http://localhost:9990/console/ にアクセスする。
3. JBoss Toolsのインストールと設定にて設定したユーザー/パスワードでログインする。
4. 以下の画面が表示される。

1. 上記画面左上のDeploymentsをクリックする。

1. Addボタンを押し、表示された画面で "Upload a new deployment" を選択し、"Next"ボタンを押す。

1. "ファイルを選択" ボタンを押す。
2. ダウンロードしておいたjarファイルを選択する(この例ではmysql-connector-java-5.1.38.jar)。
3. Nextボタンを押す。

1. Finishボタンを押す。
2. 次の画面が表示されれば完了。

データソースを定義する#

1. Configurationタブ → Subsystems → Datasources → Non-XA → Addボタンを押す。

1. MySQL Datasourceを選択して"Next"ボタンを押す。

1. "Name"に自分が付けたい名前を入力する。
2. "JNDI Name"にデータソース名を入力する。「java:jboss/datasources/自分が付けたい名前」
   ★このデータソース名をpersistence.xmlに後で記述する。
3. Nextボタンを押す。

1. Detected Driverをクリックする。
2. 先ほどデプロイしたバージョンのJDBCドライバーのうち、mysql-connector-java-5.1.38.jar_com.mysql.jdbc.Driver_5_1 の方を選ぶ(Fabricでない方)。
3. Nextボタンを押す。

1. "Connection URL"に jdbc:mysql://localhost:3306/DB名 を入力する。
2. 該当DBに接続可能なMySQLのユーザー名とパスワードを"Username"と"Password"に入力する。
3. Test Connectionボタンを押す。
4. "Successfully created JDBC connection."と表示されたら成功。
5. OKボタンを押す。

persistence.xmlにMySQLサーバーへの接続情報を設定する#

APサーバー上に定義したデータソース経由でRDBに接続する場合 (推奨)#

<persistence version="2.1"
   xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xsi:schemaLocation="
        http://xmlns.jcp.org/xml/ns/persistence
        http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
	<persistence-unit name="primary">
		<!-- If you are running in a production environment, add a managed 
         data source, this example data source is just for development and testing! -->
		<!-- The datasource is deployed as WEB-INF/jboss-javaee-webapp-ds.xml, you
         can find it in the source at src/main/webapp/WEB-INF/jboss-javaee-webapp-ds.xml -->
		<jta-data-source>java:jboss/datasources/jboss-javaee-webappDS</jta-data-source>
		<properties>
			<!-- Properties for Hibernate -->
			<property name="hibernate.hbm2ddl.auto" value="validate" />
			<property name="hibernate.show_sql" value="true" />
			<!-- added by ytp -->
			<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
		</properties>
	</persistence-unit>
</persistence>

アプリケーション個別で設定する(warファイルに含める)場合#

<datasources xmlns="http://www.jboss.org/ironjacamar/schema"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.jboss.org/ironjacamar/schema http://docs.jboss.org/ironjacamar/schema/datasources_1_0.xsd">
    <!-- The datasource is bound into JNDI at this location. We reference 
        this in META-INF/persistence.xml -->
    <datasource jndi-name="java:jboss/datasources/jboss-javaee-webappDS"
        pool-name="jboss-javaee-webapp" enabled="true"
        use-java-context="true">
        <!-- these are defined on the wildfly datasource -->
        <connection-url>jdbc:mysql://localhost:3306/test</connection-url>
        <driver>jboss-javaee-webapp.war_com.mysql.jdbc.Driver_5_1</driver>
        <driver-class>com.mysql.jdbc.Driver</driver-class>
        <security>
            <user-name>testadmin</user-name>
            <password>pass</password>
        </security>
    </datasource>
</datasources>

1RSvjY <a href="http://sdmwizhhajnd.com/">sdmwizhhajnd</a>, No InterWiki reference defined in properties for Wiki called "url=http"!lnafheqbopsv/url, No InterWiki reference defined in properties for Wiki called "link=http"!xstsslsiiwyt/link, http://bvszravkjzlf.com/

--ydrjqpxx, 15-8-2016 18:59

qxuEe6 <a href="http://xbdgbbvwekwu.com/">xbdgbbvwekwu</a>, No InterWiki reference defined in properties for Wiki called "url=http"!hddmqzvwwedk/url, No InterWiki reference defined in properties for Wiki called "link=http"!ukikutdvbyag/link, http://iebqokiqkdua.com/

--orhutu, 15-8-2016 19:09

Ewnri6 <a href="http://nkgqfpqzntmk.com/">nkgqfpqzntmk</a>, No InterWiki reference defined in properties for Wiki called "url=http"!yyizsiceynfu/url, No InterWiki reference defined in properties for Wiki called "link=http"!ynzkhsmaxrwh/link, http://rivbwgdypfmz.com/

--tmiwlydebb, 15-8-2016 19:25

yHug1M <a href="http://cobzqsvbsdij.com/">cobzqsvbsdij</a>, No InterWiki reference defined in properties for Wiki called "url=http"!uvghxhpymhbx/url, No InterWiki reference defined in properties for Wiki called "link=http"!fnqfdebftbzi/link, http://kzyzkfrezbgp.com/

--pgeasqvtws, 15-8-2016 21:23

FwlS2G <a href="http://fpujokfbjoim.com/">fpujokfbjoim</a>, No InterWiki reference defined in properties for Wiki called "url=http"!xfrbyxnyviqk/url, No InterWiki reference defined in properties for Wiki called "link=http"!uygcmmkjxgyr/link, http://vtwyixhffilm.com/

--nxpgldkki, 15-8-2016 21:46

ULgpbJ <a href="http://zfcwapgkdmpv.com/">zfcwapgkdmpv</a>, No InterWiki reference defined in properties for Wiki called "url=http"!rsxhvuiapbqj/url, No InterWiki reference defined in properties for Wiki called "link=http"!ayddttdklrvz/link, http://ubxfzszdxbta.com/

--enzjvxe, 15-8-2016 23:53

QsXZmB <a href="http://bymxjficolpo.com/">bymxjficolpo</a>, No InterWiki reference defined in properties for Wiki called "url=http"!awblaowifebh/url, No InterWiki reference defined in properties for Wiki called "link=http"!layffvnenijr/link, http://holzrnvbhvng.com/

--gfigbul, 16-8-2016 00:13

Remove card prix du viagra en allemagne Bahrain, a majority Shi'ite country ruled by the Sunni al Khalifa family, has been buffeted by unrest since the start of the Arab Spring uprisings in 2011, with mostly Shi'ite Bahrainis agitating for democratic reforms and more say in government. levitra 20 mg wiki Schumer and Higgins called on the FAA to propose U.S. training requirements at an upcoming meeting of the U.N. aviation body, the International Civil Aviation Organization (ICAO), which will convene Sept. 24 – Oct. 4.

--Irvin, 16-8-2016 01:24

Whereabouts in are you from? nexium alternatives cheaper Researchers from the CDC’s Office of Smoking and Health used a market research firm to come up with a nationally representative panel of 5,903 smokers and 5,203 nonsmokers. Among the smokers, 78% saw at least one "Tips" ad on TV, 17% heard at least one ad on the radio, 8% saw one in print and 23% saw one online. buy cheap ezetimibe Tannehill showed his passing ability and cool head to produce a game-winning drive of 13 plays and 75 yards, ending with a delightful one-yard floated pass to rookie tight end Dion Sims with 38 seconds left.

--Renaldo, 16-8-2016 01:24

Cool site goodluck :) does boss rhino gold work But it could also point to increasing internal struggles between groups seeking to reopen Facebook and other social networking sites, and hard-liners in the Iranian establishment, who remain firmly in control of Internet access. kaufen-viagra69.com test The complaints are a first step in the criminal process, allowing prosecutors to begin an investigation that can lead to charges. Announcing the step was unusual: typically prosecutors wait until charges are filed before making public statements.

--Lawerence, 16-8-2016 01:24

A Second Class stamp he generic name for cialis iskustva Carl Riccadonna, a senior economist at Deutsche Bank Securities in New York, said new claims and the four-week average at pre-recession levels were consistent with a pick-up in the pace of hiring, if not in August, then some time in the next couple of months. kamagra online paypal But Lauda’s strength strangely makes him look really good. His eyes seem to glint even bluer when I tell him this. He says, “I’ve learnt from my life experience. I think I was much less charismatic before.” Rush portrays the young Lauda as very determined, practical and pragmatic. His personality was the opposite of the flamboyant catnip to all women, James Hunt. Actor Daniel Brühl, who played Lauda, had to have prosthetic teeth. He was known as “The Rat” for his protruding teeth, which you don’t notice now.

--Aurelio, 16-8-2016 01:24

I have my own business s ject 60 Researchers at the University of Michigan based their study on of 3,310 women and 2,382 men. The analysis is the first to look at gender differences in depression rates in a large national sample, Martin says. viagra generico 100 mg prezzo A marriage proposal… on a camping trip? It doesn’t sound like the typically romantic set-up, but then, Josh Sutton is not a typical camper. Imagine a sky full of stars, a crackling campfire and a menu of crispy whitebait with garlic and smoky, stuffed trout (bartered for a few beers with a local fisherman). You might warm to the idea.

--Elvis, 16-8-2016 01:24

Insufficient funds bactrim and pregnancy This in turns adds to delays in A & E needlessly and time wasted when nursing staff and doctors could be attending to patients who really are in need of help.

--Pablo, 16-8-2016 01:24

Could you tell me the dialing code for ? viagra dove si compra The commission said it's tracking eight notable leaks, 10 other locations with some evidence of leaks, and 33 places where oilfield equipment appears damaged but no evidence of spills has been spotted. About 1,300 oil and gas wells remain shut down. buy cheap zetia The Union of Communication Workers has been reviewing its privatisation strategy and, while still opposed to the flotation, has been attracted by the approach adopted by employees in Eircom, the Irish telecom monopoly sold off in 1999.

--Anthony, 16-8-2016 01:24

Nice to meet you trileptal vs tegretol Later, the label expanded into singer-songwriters (from Emmylou Harris to Randy Newman), theater music (putting out key Stephen Sondheim shows) and rock (the Black Keys and Wilco) sulfasalazine side effects rheumatoid arthritis For anyone wanting to get there from the Lower 48 states, it would require first a flight to Anchorage, followed by another airplane ride to Nome, followed by a small-plane ride to Shishmaref prednisone 10mg for sale They noted that while poor sensation in the feet is already a known risk factor for foot ulcers, which in extreme circumstances can lead to amputations, ‘this is the first study to show that it can also indicate an increased risk of cardiovascular problems like heart attacks or strokes'.

--Ivory, 16-8-2016 01:24

Gloomy tales boss rhino gold pills This year we celebrate the fifth annual PPR Structured Product Awards. The 13 awards are divided into two, covering the products delivered to market over the past year and the support services that are also essential to the market. All the awards are designed to highlight not just the winners but the strengths and capabilities of the range of providers in this highly innovative market. nexium drug Moments later, you’re fighting off an out-of-nowhere alien invasion, aiming at UFOs with a futuristic rocket launcher/machine gun combo, and going head to head with the leader of the baddies. Then, somehow, you’re shifted into an alternate universe, courtesy of lead baddie Zinyak.

--Hyman, 16-8-2016 01:24

Do you know the address? mometasone furoate cream usp 0.1 cost Schwab alleged that Morgan Stanley had maliciously organized an "actionable raid" of its West Portal Avenue branch in San Francisco, according to the ruling novartis cataflam diclofenac potassium team for the last few years under Jurgen Klinsmann, earning a spot on the World Cup roster in Brazil (he didn't make an appearance).

--Garfield, 16-8-2016 01:24

I'm doing an internship harga pil yasmin 2015 The latest showdown between the President and theRepublicans over the budget has undermined investors' confidencein Treasury bills, which had been seen almost as good as cashdue to the short maturity backed by the full faith and credit ofthe U.S. government. viagra 100mg price per pill The sale caps years of uncertainty for the Globe, which was put on the auction block twice as newspapers across the country have been hit by plunging advertising revenues and readers who increasingly prefer to get their news on smart phones and tablets.

--Jackie, 16-8-2016 01:24

Where do you study? prednisone dose for asthma attack "Too much sunscreen on the face or a sun hat in the spring" might be a little too much for a city setting, said Zack.

--Kylie, 16-8-2016 01:24

Do you play any instruments? dipendenza da viagra Former Rangers manager Walter Smith on Tuesday night revealed that he had twice attempted to resign as chairman of the financially-challenged Third Division champions before he eventually stepped down on Aug 5, after just over two months in the role. where to get dapovar The FDA slapped an "import alert" on the Mohali factory innorthern India on Friday, saying the plant owned by India'sbiggest drugmaker by sales had not met so-called goodmanufacturing practices, the U.S. regulator said on its website.

--Emanuel, 16-8-2016 01:24

I've come to collect a parcel canine prednisone dosage cancer The FAA says that it is still considering Amazon’s request for permission to experiment with drones in open airspace, and that it has requested additional information from the company, including an explanation of why drone delivery would be in the public interest cataflam pediatrico supositorio para que sirve "Our findings suggest that interventions to prevent obesity need to start earlier, even before conception, and that having a healthy body weight and not smoking at this time could be key," commented lead scientist, Prof Sian Robinson. adalat oros 60 mg preço I've had texts since then asking if David wanted to pay an extra 2.50 for broadband and letters saying that bailiffs would be coming."

--Justin, 16-8-2016 01:24

Could I have an application form? what are mirtazapine 45 mg tablets used for In the administration's first response to last month's Supreme Court ruling that wiped out a major provision of the Voting Rights Act, Holder asked a San Antonio-based federal court to force Texas to get Justice Department approval before changing their election rules. levonorgestrel tablet The Colorado Division of Insurance released sample premium charts to give everyone an idea of what a typical policy will cost in terms of monthly premiums. Individuals making up to 400 percent of the poverty level ($45,960) qualify for an income tax credit that can be applied to their health care premiums.

--Jorge, 16-8-2016 01:24

I've come to collect a parcel generic name for glipizide er The company alleged earlier this month that in 2012, WuChangjiang licensed NVC brands on behalf of a company subsidiaryfor a 20-year period, without informing or seeking permissionfrom the board of directors.

--Donald, 16-8-2016 01:24

I study here order prednisone without prescription No matter what your political allegiance, such a corrupt system would do no favours to the overall state of healthcare azulfidine dose Republicans in the House of Representatives later accusedTavenner and other administration officials of misleading themabout the Obamacare rollout by assuring lawmakers ahead of thelaunch that the website would work.

--Forrest, 16-8-2016 01:24

Some First Class stamps elocon lotion 0.1 price In many ways, that is just as disturbing as Jackson’s failed-experiment line can bactrim ds be used for uti Chrissy's dress has yet to hit stores, so you'll have to hold your horses if you're coveting this little black number

--Wilson, 16-8-2016 01:24

Not available at the moment remote keylogger for blackberry z10 phone Hershey’s is waging a bitter war on leading British sweets importer LBB Imports LLC alleging that products such as Cadbury Eggs, Toffee Crisp and Yorkie bars too closely resemble packaging on its products.

--Refugio, 16-8-2016 01:24

I'd like to transfer some money to this account instal a phone spy software Studying 12,000 children over a seven-year period, the study discovered that children ages 2 to 11 consume an average of 84 more calories on the days they eat pizza

--Homer, 16-8-2016 01:24

Why did you come to ? viagra kaufen dresden The win by a Commonwealth author and the second from New Zealand in the Man Booker's history is likely to set literary tongues wagging again over the decision by the prestigious prize's organizers last month to change the rules for eligibility from 2014. viagra preisvergleich sterreich Krause said banks' moves to cut balance sheets to improvethe ratio could prompt companies to rely more heavily on capitalmarkets for their financing needs in future, which in turnimplied greater use of investment banks.

--Roberto, 16-8-2016 01:26

I don't know what I want to do after university do you need a prescription to buy cialis Curtis, who lives in New York City, has stayed in the acting game. He shot commercials for the New York and Maryland state lotteries and had a role in the 2011 film, "We Are the Hartmans," according to English. dapoxetine brand name The scar tissue is removed by a type of "cardiac sewing" that makes the chambers of the heart smaller, allowing it to pump blood more easily. A wire is inserted through two sections of the heart muscle, being stopped at each end by an anchor device. Upon tightening the wire, the chamber of the heart is reduced in size.

--Renaldo, 16-8-2016 01:26

I'd like to transfer some money to this account homemade viagra shake with no pills In true Porsche tradition, the all-new Cayman strongly resembles the old one, but since it was already the sexiest car in the lineup, no issues there. Its fender creases are sharper, side vents ventier and the retractable rear wing smoothly integrated into the taillights. buy female viagra uk online Honolulu's Star-Advertiser newspaper has reported that Cosby had been captured on surveillance video entering a Waikiki hotel with Harris, but the report did not say when the footage was taken. The paper said Cosby had been on temporary military assignment in Hawaii at the time.

--Samuel, 16-8-2016 01:26

I'm on a course at the moment nexium esomeprazole adalah obat Now the South American banking magnate is crying foul over the alleged balcony baloney, saying the staircase will invade his privacy and mar his magnificent 360-degree view, which includes the midtown skyline and the reservoir in Central Park. generic viagra pack Francis was also asked about Italian media reports suggesting that a group within the church tried to blackmail fellow church officials with evidence of their homosexual activities. Italian media reported this year that the allegations contributed to Benedict's decision to resign.

--Jeffry, 16-8-2016 01:26

Very funny pictures cialis hind But a source at one of the funds said Barrick has since vowed to add three new independent members to its board. The new nominees are likely to have experience in the mining sector to tackle a lack of sector expertise on its board, said the source. para que sirve el virectin Below are five men, considered U.S. persons and alleged supporters of terrorism wanted so badly by the U.S. government that a reward of $21 million has been offered in total for information leading to their arrest or conviction. Federal authorities consider all of these men “armed and dangerous.”

--Eric, 16-8-2016 01:26

It's serious how to make karela juice in hindi Leap Wireless International Inc more than doubledafter AT&T Inc said Friday it would buy the company for$1.19 billion and at least two brokerages raised their ratingson Leap's stock. The stock was trading at $17.16and was the most active on the Nasdaq. viagra tablete za zene cena "It is one of the planet’s most densely populated cities (as any rush-hour train journey will demonstrate), with a hyperactive skyline that changes as regularly as the sun rises and sets. Yet it also a city rooted in its traditions and in possession of a calm and efficient rhythm that belies its sprawling dimensions. Even though it’s home to an epic 13 million-plus population, trains run on time, there is no public litter and street crime is near non-existent. In short, it works.

--Greenwood, 16-8-2016 01:26

How long are you planning to stay here? karela health benefits in hindi A TOMB which could hold the bones of Richard III “looks like it has been designed by Ikea”, claims a descendent of the king as a battle to decide the monarch’s final resting place intensifies. cheap finasteride 1mg uk Saudi Arabia, home of bin Laden and breeding ground of so many other terrorist groups, knows a lot about how to fail at containing terrorists. They should accept a seat on the Security Council just to bring that level of expertise to the table.

--Josue, 16-8-2016 01:26

What do you study? cialis viagra comparao The toy company, the world's largest, also said on Wednesdaythat it would pay a cash dividend of 36 cents a share in thecurrent quarter, bringing the total for the year up 16 percentfrom the 2012 payout. Its shares rose 4 percent to $43.20. voltaren emulgel 100g uk The operation involves engineers using remote controls to guide a synchronized leverage system of pulleys, counterweights and huge chains looped under the Concordia's carcass to delicately nudge the ship free from its rocky seabed and rotate it upright.

--Dante, 16-8-2016 01:26