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文件放进去