昨天弄了一天,也没配好环境,看来百度比谷歌在搜索专业知识方面还是有差距啊(我昨天都是在百度上查的资料),言归正传。
Tomcat5 下的相关配置
我的项目名称是xiaonei,在Tomcat 5.0\conf\Catalina\localhost下建立文件xiaonei.xml是用来配置数据源的。
<?xml version='1.0' encoding='utf-8'?>
<Context docBase="xiaonei" path="/xiaonei" workDir="work\Catalina\localhost\xiaonei">
<Resource name="xiaonei" type="javax.sql.DataSource"/>
<ResourceParams name="xiaonei">
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>1000</value>
</parameter>
<parameter>
<name>password</name>
<value>sa</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xiaonei</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>2000</value>
</parameter>
<parameter>
<name>username</name>
<value>sa</value>
</parameter>
</ResourceParams>
</Context>
Spring 配置文件applicationContext.xml中相应得配置是
<beans>
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value>java:comp/env/xiaonei</value>
</property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="hibernate.query.factory_class">
org.hibernate.hql.classic.ClassicQueryTranslatorFactory
</prop>
<prop key="hibernate.connection.autocommit">true</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/xiaonei/basic/vo/Continent.hbm.xml</value></list>
</property>
</bean>
</beans>
注意看是这句:<value>java:comp/env/xiaonei</value>这是和weblogic8下不同的地方。
Weblogic8下的相关配置:
我的Weblogic8 的安装目录C:\bea,在 C:\bea\user_projects\domains\mydomain下的文件config.xml中配置如下:
<?xml version="1.0" encoding="UTF-8"?>
<Domain ConfigurationVersion="8.1.4.0" Name="mydomain">
<Server ListenAddress="" ListenPort="7001" Name="myserver"
NativeIOEnabled="true" ReliableDeliveryPolicy="RMDefaultPolicy" ServerVersion="8.1.4.0">
<SSL Enabled="false" HostnameVerificationIgnored="false"
IdentityAndTrustLocations="KeyStores" Name="myserver"/>
</Server>
<JMSFileStore Directory="rmfilestore" Name="FileStore"/>
<WSReliableDeliveryPolicy DefaultRetryCount="10"
DefaultTimeToLive="60000" Name="RMDefaultPolicy" Store="FileStore"/>
<Security Name="mydomain"
PasswordPolicy="wl_default_password_policy"
Realm="wl_default_realm" RealmSetup="true"/>
<EmbeddedLDAP
CredentialEncrypted="{3DES}8IDYj6bMH+8iF9Q1RsjSs0ofzzppIPYE2byzPISNwrw=" Name="mydomain"/>
<SecurityConfiguration
CredentialEncrypted="{3DES}hGPuj7+RdrRjHCGmIceho4JqIfKsityW8RiLKFtp73NlSc+p4vpqmgJisH8R9l2V4FGA/nAs+WQlBeCuo7DsIVc+0L8EmQoO"
Name="mydomain" RealmBootStrapVersion="1"/>
<Realm FileRealm="wl_default_file_realm" Name="wl_default_realm"/>
<FileRealm Name="wl_default_file_realm"/>
<PasswordPolicy Name="wl_default_password_policy"/>
<JMSServer Name="WSStoreForwardInternalJMSServermyserver"
Store="FileStore" Targets="myserver">
<JMSQueue CreationTime="1206515080640"
JNDIName="jms.internal.queue.WSStoreForwardQueue"
JNDINameReplicated="false" Name="WSInternaljms.internal.queue.WSStoreForwardQueuemyserver"/>
<JMSQueue CreationTime="1206515081312"
JNDIName="jms.internal.queue.WSDupsEliminationHistoryQueue"
JNDINameReplicated="false" Name="WSInternaljms.internal.queue.WSDupsEliminationHistoryQueuemyserver"/>
</JMSServer>
<JDBCConnectionPool
DriverName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
Name="xiaoneiConPool" PasswordEncrypted="{3DES}7/ZCTgJsOSA="
Properties="user=sa;url=jdbc:microsoft:sqlserver://localhost:1433;selectMethod=cursor;dataSourceName=SQL2000JDBC;userName=sa;databaseName=xiaonei;serverName=localhost"
Targets="myserver" TestTableName="SQL SELECT 1" URL="jdbc:microsoft:sqlserver://localhost:1433"/>
<JDBCTxDataSource JNDIName="xiaonei" Name="xiaonei"
PoolName="xiaoneiConPool" Targets="myserver"/>
<WebAppComponent Name="xn" Targets="myserver" URI="xn"/>
<Application Name="xiaonei"
Path="C:\bea\user_projects\domains\mydomain\applications"
StagingMode="nostage" TwoPhase="true">
<WebAppComponent Name="xiaonei" Targets="myserver" URI="xiaonei"/>
</Application>
</Domain>
Spring 配置文件applicationContext.xml中相应得配置是
<beans>
<bean id="dataSource"
class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName">
<value> xiaonei</value>
</property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="hibernate.query.factory_class">
org.hibernate.hql.classic.ClassicQueryTranslatorFactory
</prop>
<prop key="hibernate.connection.autocommit">true</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/xiaonei/basic/vo/Continent.hbm.xml</value></list>
</property>
</bean>
</beans>
注意看是这句:<value>xiaonei</value>这是和Tomcat5下的主要区别。
如果在两种服务器下写反了,会报错的。