WebObjects

1. WebObjectsをまたひっぱり出す機会があったのでメモ

• 今度はMySQLと接続してみる
• WO5.2
• MySQL 5.http://www.mysql.org/downloads/
  • いつものおまじない
  • /usr/local/mysql/bin/mysqladmin -u root password XXXXXX
  • /usr/local/mysql/bin/mysql -u root -p
  • grant all privileges on *.* to gikoha@localhost identified by 'XXXXX' with grant option;
  • grant all privileges on *.* to gikoha@'%' identified by 'XXXXX' with grant option;
  • flush privileges;
  • quit
• MySQL Java Connector http://www.mysql.com/products/connector/j/
  • ダウンロードしたmysql-connector-java-3.1.12-bin.jarを/Library/Java/Extensions/にほうりこむ
• EOModeler
  • JDBC Connection
  • username: gikoha
  • password: XXXXX
  • URL: jdbc:mysql://127.0.0.1/DATABASENAME?useUnicode=true&characterEncoding=SJIS
  • Driver: org.gjt.mm.mysql.Driver
  • MySQLではkeyとかnameとかは予約語になっているのでcolumn nameには使わないほうがいい