{"id":78,"date":"2011-12-18T13:12:13","date_gmt":"2011-12-18T04:12:13","guid":{"rendered":"http:\/\/ec2-52-35-32-26.us-west-2.compute.amazonaws.com\/blog\/2011\/12\/18\/20111218131213\/"},"modified":"2011-12-18T13:12:13","modified_gmt":"2011-12-18T04:12:13","slug":"20111218131213","status":"publish","type":"post","link":"http:\/\/daimlars.jp\/blog\/?p=78","title":{"rendered":"iTunes\u3067\u518d\u751f\u30c1\u30e3\u30fc\u30c8\u30e9\u30f3\u30ad\u30f3\u30b0\u3092\u5b9a\u671f\u7684\u306b\u81ea\u52d5\u3067\u4f5c\u308a\u305f\u3044\uff08\uff11\uff09"},"content":{"rendered":"

\u307e\u305a\u306f\u74b0\u5883\u4f5c\u308a\u304b\u3089\u30fb\u30fb\u30fb\u3002<\/p>\n<\/p>\n

MySQL<\/a>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u306f\u4ee5\u4e0b\u306b\u306f\u307e\u3063\u305f\u3002\u300cCannot start SSH tunnel<\/a> manager\u300d<\/p>\n<\/p>\n

\"\"<\/a><\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

Home>View>Output\u3088\u308a\u30ed\u30b0\u3092\u53c2\u7167\u3059\u308b\u3068\u540c\u69d8\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u591a\u767a\u3002<\/p>\n

ImportError: DLL<\/a> load failed: \ufffdw\ufffd\u80b3\ufffd\ua0bd\ufffd\ufffd\ufffdW\ufffd\ufffd\ufffd[\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\u0082\ufffd\ufffd\ufffd\u0702\ufffd\ufffd\ufffdB<\/p>\n

Traceback (most recent call last):<\/p>\n

File “C:\\Program Files<\/a> (x86<\/a>)\\MySQL<\/a>\\MySQL<\/a> Workbench 5.2 CE<\/a>\\sshtunnel.py”, line 6, in<\/p>\n

import<\/a> socket<\/p>\n

File “C:\\Program Files (x86<\/a>)\\MySQL<\/a>\\MySQL<\/a> Workbench 5.2 CE\\Python<\/a>\\socket.py”, line 46, in<\/p>\n

import _socket<\/p><\/blockquote>\n

Trac<\/a>\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u306a\u304b\u3063\u305f\u304c\u3001Pythonhome\u74b0\u5883\u5909\u6570<\/a>\u3092\u30bb\u30c3\u30c8\u3057\u3066\u307f\u305f\u3002<\/p>\n

Traceback (most recent call last):<\/p>\n

File “C:\\Program Files (x86<\/a>)\\MySQL<\/a>\\MySQL<\/a> Workbench 5.2 CE\\sshtunnel.py”, line 6, in <module><\/p>\n

import socket<\/p>\n

File “C:\\Program Files (x86<\/a>)\\MySQL<\/a>\\MySQL<\/a> Workbench 5.2 CE\\Python<\/a>\\socket.py”, line 46, in <module><\/p>\n

import _socket<\/p>\n

ImportError: DLL load failed: \ufffdw\ufffd\u80b3\ufffd\ua0bd\ufffd\ufffd\ufffdW\ufffd\ufffd\ufffd[\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\u0082\ufffd\ufffd\ufffd\u0702\ufffd\ufffd\ufffdB\uffe5<\/p><\/blockquote>\n

\u65ad\u5ff5\u3002\u3002\u3002<\/p>\n<\/p>\n

\u305f\u3060\u3001DataModeling\u306f\u4f7f\u3048\u305f\u306e\u3067ER\u56f3\u3092\u66f8\u3044\u3066DDL<\/a>\u3092\u81ea\u52d5\u751f\u6210\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u308b\u3002<\/p>\n<\/p>\n

\"\"<\/a><\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

 <\/p>\n<\/p>\n

DDL<\/a>\u306f\u30c6\u30fc\u30d6\u30eb\u3092\u9078\u3093\u3067\u53f3\u30af\u30ea\u30c3\u30af\u3067\u81ea\u52d5\u751f\u6210\u3002\u3064\u3044\u3067\u3001Eclipse<\/a>\u3002JPA<\/a>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\u3057\u3001\u53f3\u30af\u30ea\u30c3\u30af\uff1e\u65b0\u898f\u4f5c\u6210\uff1e\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u3067\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u3092\u4f5c\u6210\u3002\u3053\u3093\u306a\u30af\u30e9\u30b9\u304c\u3067\u304d\u305f\u3002<\/p>\n

import java<\/a>.io.Serializable;<\/p>\n

import javax.persistence.*;<\/p>\n

import java<\/a>.util.Date;<\/p>\n

import java<\/a>.util.Set;<\/p>\n

\/**<\/p>\n

* The persistent class for the tbl_update database table.<\/p>\n

*<\/p>\n

*\/<\/p>\n

@Entity<\/p>\n

@Table(name=”tbl_update”)<\/p>\n

public class TblUpdate implements Serializable {<\/p>\n

private static final long serialVersionUID = 1L;<\/p>\n<\/p>\n

@Id<\/p>\n

@Column(name=”Trac<\/a>_ID”)<\/p>\n

private int trac<\/a>_ID;<\/p>\n<\/p>\n

@Column(name=”Play_Count”)<\/p>\n

private String play_Count;<\/p>\n<\/p>\n

@Column(name=”Type”)<\/p>\n

private String type<\/a>;<\/p>\n<\/p>\n

@Temporal<\/a>( TemporalType.TIMESTAMP)<\/p>\n

@Column(name=”Update_data”)<\/p>\n

private Date update_data;<\/p>\n<\/p>\n

\/\/bi-directional many-to-one association to TbmTrack<\/p>\n

@OneToMany(mappedBy=”tblUpdate”)<\/p>\n

private Set<TbmTrack> tbmTracks;<\/p>\n<\/p>\n

public TblUpdate() {<\/p>\n

}<\/p>\n<\/p>\n

public int getTrac_ID() {<\/p>\n

return this.trac<\/a>_ID;<\/p>\n

}<\/p>\n<\/p>\n

public void setTrac_ID(int trac<\/a>_ID) {<\/p>\n

this.trac<\/a>_ID = trac<\/a>_ID;<\/p>\n

}<\/p>\n<\/p>\n

public String getPlay_Count() {<\/p>\n

return this.play_Count;<\/p>\n

}<\/p>\n<\/p>\n

public void setPlay_Count(String play_Count) {<\/p>\n

this.play_Count = play_Count;<\/p>\n

}<\/p>\n<\/p>\n

public String getType() {<\/p>\n

return this.type;<\/p>\n

}<\/p>\n<\/p>\n

public void setType(String type) {<\/p>\n

this.type = type;<\/p>\n

}<\/p>\n<\/p>\n

public Date getUpdate_data() {<\/p>\n

return this.update_data;<\/p>\n

}<\/p>\n<\/p>\n

public void setUpdate_data(Date update_data) {<\/p>\n

this.update_data = update_data;<\/p>\n

}<\/p>\n<\/p>\n

public Set<TbmTrack> getTbmTracks() {<\/p>\n

return this.tbmTracks;<\/p>\n

}<\/p>\n<\/p>\n

public void setTbmTracks(Set<TbmTrack> tbmTracks) {<\/p>\n

this.tbmTracks = tbmTracks;<\/p>\n

}<\/p>\n<\/p>\n

}<\/p><\/blockquote>\n

\u30af\u30e9\u30b9\u306e\u81ea\u52d5\u751f\u6210\u3068\u3068\u3082\u306b\u3001persistence.xml<\/a>\u3082\u66f4\u65b0\u3055\u308c\u3066\u3044\u308b\uff01<\/p>\n

<?xml<\/a> version=”1.0″ encoding=”UTF-8<\/a>“?><\/p>\n

<persistence version=”2.0″ xmlns=”http:\/\/java.sun.com\/xml\/ns\/persistence<\/a>” xmlns:xsi=”http:\/\/www.w3.org\/2001\/XMLSchema-instance<\/a>” xsi:schemaLocation=”http:\/\/java.sun.com\/xml\/ns\/persistence<\/a> http:\/\/java.sun.com\/xml\/ns\/persistence\/persistence_2_0.xsd<\/a>“><\/p>\n

<persistence-unit name=”JPA<\/a>_test”><\/p>\n

<class>TblUpdate<\/class><\/p>\n

<class>TbmTrack<\/class><\/p>\n

<\/persistence-unit><\/p>\n

<\/persistence><\/p><\/blockquote>\n

DB\u3078\u306e\u767b\u9332\u306f\u4e0b\u8a18\u306e\u3088\u3046\u306a\u30af\u30e9\u30b9\u3067\u53ef\u80fd\u3002<\/p>\n

import javax.persistence.EntityManager;<\/p>\n

import javax.persistence.EntityManagerFactory;<\/p>\n

import javax.persistence.EntityTransaction;<\/p>\n

import javax.persistence.Persistence;<\/p>\n<\/p>\n

public class test {<\/p>\n

public static void main(String[] args) {<\/p>\n<\/p>\n

TbmTrack track = new TbmTrack();<\/p>\n<\/p>\n

EntityManagerFactory emf = Persistence.createEntityManagerFactory(“JPA<\/a>_test”);<\/p>\n

EntityManager em = emf.createEntityManager();<\/p>\n<\/p>\n

track.setTrack_id(1);<\/p>\n

track.setArtist(new String(“test”));<\/p>\n<\/p>\n

EntityTransaction tx = em.getTransaction();<\/p>\n

tx.begin();<\/p>\n

em.persist(track);<\/p>\n

tx.commit();<\/p>\n<\/p>\n

em.close();<\/p>\n

emf.close();<\/p>\n<\/p>\n

}<\/p>\n

}<\/p><\/blockquote>\n

\u4e88\u60f3\u901a\u308aDB\u304b\u3089DDL<\/a>\u3092\u62bd\u51fa\u3057\u3066\u3057\u307e\u3048\u3070\u3001\u6b8b\u308b\u30bd\u30fc\u30b9\u3067\u66f8\u304f\u306e\u306f\u307b\u3093\u3068\u50c5\u304b\u3002\u3053\u308c\u3058\u3083\u3042\u8a00\u8a9e\u6bce\u306e\u751f\u7523\u6027\u3082\u9055\u3044\u306f\u3042\u307e\u308a\u3067\u306a\u3044\u6c17\u304c\u3059\u308b\u3002<\/p>\n

iTunes<\/a>\u306eXML<\/a>\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u306f\u771f\u30fbplist\u5f62\u5f0f\u306exml\u8aad\u307f\u8fbc\u307f\u7528digester-rules(\u304a\u3088\u3073\u30af\u30e9\u30b9)<\/a>\u304c\u3042\u3063\u305f\u306e\u3067\u3001\u3053\u3053\u304b\u3089\u62dd\u501f\u3057\u3066\u79d2\u6bba\u3002<\/p>\n

\u9762\u5012\u306a\u306e\u306f\u524d\u56de\u306e\u30c0\u30f3\u30d7\u3068\u306e\u5dee\u5206\u3092\u3068\u3063\u3066\u30c1\u30e3\u30fc\u30c8\u3092\u51fa\u3057\u305f\u308a\u3059\u308b\u3001\u30c7\u30fc\u30bf\u306e\u6301\u3061\u65b9\u306e\u8a2d\u8a08\u3042\u305f\u308a\u3002<\/p>\n<\/p>\n

\u7c21\u5358\u306b\u4f5c\u308c\u308b\u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af<\/a>\u304c\u7121\u3044\u3082\u306e\u304b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u307e\u305a\u306f\u74b0\u5883\u4f5c\u308a\u304b\u3089\u30fb\u30fb\u30fb\u3002 MySQL\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u306f\u4ee5\u4e0b\u306b\u306f\u307e\u3063\u305f\u3002\u300cCannot start SSH tunnel manager\u300d           Home&g […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-78","post","type-post","status-publish","format-standard","hentry","category-engineering"],"_links":{"self":[{"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/78","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=78"}],"version-history":[{"count":0,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions"}],"wp:attachment":[{"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}