[sandbox.mistral]/trunk/mistral/src/main/resources/jdbc.dicon
Parent Directory
| 
Revision Log
Revision 98 -
(show annotations)
Thu Jan 1 00:32:19 2009 JST (4 years, 5 months ago) by azusa
File size: 5641 byte(s)
Thu Jan 1 00:32:19 2009 JST (4 years, 5 months ago) by azusa
File size: 5641 byte(s)
| 1 | <?xml version="1.0" encoding="UTF-8"?> |
| 2 | <!DOCTYPE components PUBLIC "-//SEASAR//DTD S2Container 2.4//EN" |
| 3 | "http://www.seasar.org/dtd/components24.dtd"> |
| 4 | <components namespace="jdbc"> |
| 5 | <include path="jta.dicon"/> |
| 6 | |
| 7 | <!-- for HSQLDB --> |
| 8 | <!-- |
| 9 | <component name="xaDataSource" |
| 10 | class="org.seasar.extension.dbcp.impl.XADataSourceImpl"> |
| 11 | <property name="driverClassName"> |
| 12 | "org.hsqldb.jdbcDriver" |
| 13 | </property> |
| 14 | <property name="URL"> |
| 15 | "jdbc:hsqldb:file:" |
| 16 | + @org.seasar.framework.util.ResourceUtil@getBuildDir('app.dicon').getCanonicalPath() |
| 17 | + "/data/test" |
| 18 | </property> |
| 19 | <property name="user">"sa"</property> |
| 20 | <property name="password">""</property> |
| 21 | </component> |
| 22 | --> |
| 23 | |
| 24 | <!-- for H2 --> |
| 25 | <component name="xaDataSource" |
| 26 | class="org.seasar.extension.dbcp.impl.XADataSourceImpl"> |
| 27 | <property name="driverClassName"> |
| 28 | "org.h2.Driver" |
| 29 | </property> |
| 30 | <property name="URL"> |
| 31 | "jdbc:h2:tcp://localhost:9092/demo" |
| 32 | </property> |
| 33 | <property name="user">"sa"</property> |
| 34 | <property name="password">""</property> |
| 35 | <destroyMethod> |
| 36 | @org.seasar.framework.util.DriverManagerUtil@deregisterAllDrivers() |
| 37 | </destroyMethod> |
| 38 | </component> |
| 39 | |
| 40 | <!-- for Oracle --> |
| 41 | <!-- |
| 42 | <component name="xaDataSource" |
| 43 | class="org.seasar.extension.dbcp.impl.XADataSourceImpl"> |
| 44 | <property name="driverClassName"> |
| 45 | "oracle.jdbc.driver.OracleDriver" |
| 46 | </property> |
| 47 | <property name="URL"> |
| 48 | "jdbc:oracle:thin:@xxx:1521:xxx" |
| 49 | </property> |
| 50 | <property name="user">"xxx"</property> |
| 51 | <property name="password">"xxx"</property> |
| 52 | </component> |
| 53 | --> |
| 54 | |
| 55 | <!-- for DB2 --> |
| 56 | <!-- |
| 57 | <component name="xaDataSource" |
| 58 | class="org.seasar.extension.dbcp.impl.XADataSourceImpl"> |
| 59 | <property name="driverClassName"> |
| 60 | "com.ibm.db2.jcc.DB2Driver" |
| 61 | </property> |
| 62 | <property name="URL"> |
| 63 | "jdbc:db2://foo.bar.com:50000/SAMPLE" |
| 64 | </property> |
| 65 | <property name="user">"db2user"</property> |
| 66 | <property name="password">"db2password"</property> |
| 67 | <initMethod name="addProperty"> |
| 68 | <arg>"currentSchema"</arg> |
| 69 | <arg>"SCHEMA"</arg> |
| 70 | </initMethod> |
| 71 | </component> |
| 72 | --> |
| 73 | |
| 74 | <!-- for PostgreSQL --> |
| 75 | <!-- |
| 76 | <component name="xaDataSource" |
| 77 | class="org.seasar.extension.dbcp.impl.XADataSourceImpl"> |
| 78 | <property name="driverClassName"> |
| 79 | "org.postgresql.Driver" |
| 80 | </property> |
| 81 | <property name="URL"> |
| 82 | "jdbc:postgresql://localhost/TEST" |
| 83 | </property> |
| 84 | <property name="user">"xxxx"</property> |
| 85 | <property name="password">"xxxx"</property> |
| 86 | </component> |
| 87 | --> |
| 88 | |
| 89 | <!-- MySQL |
| 90 | - MySQL4.0以下でマルチバイト文字を扱う場合には，URL指定の後に， |
| 91 | 以下の接続パラメータを追加で指定してください． |
| 92 | useUnicode=true |
| 93 | characterEncoding=[MySQLのエンコーディングに対応した |
| 94 | Javaのエンコーディング名] |
| 95 | 例："jdbc:mysql://localhost:3306/test?useUnicode=true" + |
| 96 | "&characterEncoding=Windows-31J" |
| 97 | |
| 98 | - MySQL5.0以降で，エンコーディングがeucjpmsの列を扱う場合には， |
| 99 | URL指定の後に，以下の接続パラメータを追加で指定してください． |
| 100 | characterEncoding=UTF-8またはWindows-31J |
| 101 | characterSetResults=UTF-8またはWindows-31J |
| 102 | 例："jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8" + |
| 103 | "&characterSetResults=UTF-8" |
| 104 | この指定をしない場合，Java側でUCS-2⇔EUC_JP_Solarisの変換が |
| 105 | 行なわれるため，ユーザー定義外字などの一部の文字が化けます． |
| 106 | この指定をすることで，MySQL側でeucjpms⇔ucs2⇔utf8(cp932)の |
| 107 | 変換が行なわれ，Java側でUCS-2⇔UTF-8(Windows-31J)の変換が |
| 108 | 行なわれるようになります．この結果，文字化けを防げます． |
| 109 | なおJIS X 0212(補助漢字)を使用する場合は，Windows-31Jではなく |
| 110 | UTF-8を指定する必要があります． |
| 111 | |
| 112 | - 上記以外の場合は，my.cnfでdefault-character-setの設定を適切に |
| 113 | (cp932やutf8など．デフォルトのlatin1は不可)行なっていれば， |
| 114 | 文字化けは防げます． |
| 115 | <component name="xaDataSource" |
| 116 | class="org.seasar.extension.dbcp.impl.XADataSourceImpl"> |
| 117 | <property name="driverClassName"> |
| 118 | "com.mysql.jdbc.Driver" |
| 119 | </property> |
| 120 | <property name="URL"> |
| 121 | "jdbc:mysql://localhost:3306/test" |
| 122 | </property> |
| 123 | <property name="user">"xxx"</property> |
| 124 | <property name="password">"xxx"</property> |
| 125 | </component> |
| 126 | --> |
| 127 | |
| 128 | <!-- for SQLServer --> |
| 129 | <!-- |
| 130 | <component name="xaDataSource" |
| 131 | class="org.seasar.extension.dbcp.impl.XADataSourceImpl"> |
| 132 | <property name="driverClassName"> |
| 133 | "net.sourceforge.jtds.jdbc.Driver" |
| 134 | </property> |
| 135 | <property name="URL"> |
| 136 | "jdbc:jtds:sqlserver://localhost/TEST;instance=SQLEXPRESS" |
| 137 | </property> |
| 138 | <property name="user">"xxxx"</property> |
| 139 | <property name="password">"xxxx"</property> |
| 140 | </component> |
| 141 | --> |
| 142 | |
| 143 | <component name="connectionPool" |
| 144 | class="org.seasar.extension.dbcp.impl.ConnectionPoolImpl"> |
| 145 | <property name="timeout">600</property> |
| 146 | <property name="maxPoolSize">10</property> |
| 147 | <property name="allowLocalTx">true</property> |
| 148 | <destroyMethod name="close"/> |
| 149 | </component> |
| 150 | |
| 151 | <component name="DataSource" |
| 152 | class="org.seasar.extension.dbcp.impl.DataSourceImpl" |
| 153 | /> |
| 154 | |
| 155 | <!-- from JNDI --> |
| 156 | <!-- |
| 157 | <component name="DataSource" |
| 158 | class="javax.sql.DataSource"> |
| 159 | @org.seasar.extension.j2ee.JndiResourceLocator@lookup("java:comp/env/jdbc/DataSource") |
| 160 | </component> |
| 161 | --> |
| 162 | |
| 163 | <!-- |
| 164 | <component name="dataSource" |
| 165 | class="org.seasar.extension.datasource.impl.SelectableDataSourceProxy"/> |
| 166 | --> |
| 167 | </components> |
| Repository Top ViewVC Help |
 |
| Powered by ViewVC |