ds文件的配置

连接Oracle数据库：

jdbc:oracle:thin:@192.168.200.151:1522:ORCL10g

?

<local-tx-datasource><jndi-name>MobileOaInterfaceDatasource</jndi-name><connection-url>jdbc:oracle:thin:@192.168.200.151:1522:ORCL10g</connection-url><driver-class>oracle.jdbc.driver.OracleDriver</driver-class><user-name>EpointFrame7_CS</user-name><password>11111</password></local-tx-datasource><local-tx-datasource><jndi-name>SecondDatasource</jndi-name><connection-url>jdbc:oracle:thin:@192.168.200.151:1522:ORCL10g</connection-url><driver-class>oracle.jdbc.driver.OracleDriver</driver-class><user-name>EpointFrame7_CS</user-name><password>11111</password></local-tx-datasource>

?

连接MySQL：

?

jdbc:mysql://localhost:3306/dev_wjj

<driver-url>jdbc:mysql://localhost:3306/dev_wjj</driver-url><driver-class>com.mysql.jdbc.Driver</driver-class><driver-properties><property name="user" value="root" /><property name="password" value="11111" /><property name="autoReconnect" value="true" /></driver-properties>

?

<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5DialectExtend"/>?

?

?

连接SQLServer：

jdbc:sqlserver://192.168.200.151\sql2005;databaseName=CityManage_Frame

?

<local-tx-datasource><jndi-name>EpointAndroidInterfaceDatasource</jndi-name><connection-url>jdbc:sqlserver://192.168.200.151\sql2005;databaseName=CityManage_Frame</connection-url><driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class><user-name>sa</user-name><password>sql_00000</password></local-tx-datasource>

<property name="hibernate.dialect" value="org.hibernate.dialect.SQLServer2008Dialect" />

?

?

?配置方言：

?

?

<persistence-unit name="MobileOaInterface"transaction-type="JTA"><provider>org.hibernate.ejb.HibernatePersistence</provider><jta-data-source>java:/MobileOaInterfaceDatasource</jta-data-source><class>com.epoint.mobileoa.model.CsQwWentisb</class><class>com.epoint.mobileoa.model.CodeItem</class><properties><property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/><!-- <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/> --><!-- <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServer2008Dialect" /> --><property name="hibernate.hbm2ddl.auto" value="none" /><property name="hibernate.show_sql" value="false" /><property name="hibernate.format_sql" value="true" /><!-- Only relevant if Seam is loading the persistence unit (Java SE bootstrap) --><property name="hibernate.transaction.manager_lookup_class"value="org.hibernate.transaction.JBossTransactionManagerLookup" /></properties></persistence-unit>

?自定义方言，需要在src目录下建立个文件夹:org.hibernate.dialect,然后把dialec.zip文件放进去