|
<bean id="dataSource"
??class="org.apache.commons.dbcp.BasicDataSource"
??destroy-method="close">
??<property name="driverClassName"
???value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
??<property name="url"
???value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ITSM_JBPM;SelectMethod=cursor;" />
??<property name="username" value="sa" />
??<property name="password" value="sa" />
?</bean>
?<bean id="sessionFactory"
??class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"
??singleton="true">
<!-------
?问题一：property属性的名字能不能取成其他的名字？
mappingResources，? hibernateProperties，? dataSource
答案是： 不能随便取。
理由是：
package org.springframework.orm.hibernate3;
public class LocalSessionFactoryBean extends AbstractSessionFactoryBean {
?private Resource[] mappingLocations;
?private Properties hibernateProperties;
?private DataSource dataSource;
?public void setMappingResources(String[] mappingResources) {
??this.mappingLocations = new Resource[mappingResources.length];
??for (int i = 0; i < mappingResources.length; i++) {
???this.mappingLocations[i] = new ClassPathResource(mappingResources[i].trim());
??}
?}
?public void setHibernateProperties(Properties hibernateProperties) {
??this.hibernateProperties = hibernateProperties;
?}
?public void setDataSource(DataSource dataSource) {
??this.dataSource = dataSource;
?}
}
---->
??<property name="mappingResources">
???<list>
????? <value>
????????? com/vandagroup/itsm/dataobject/attachment/ItsmAttachment.hbm.xml
???? ?</value>
????<!-- ###################### -->
????<!-- # jbpm mapping files? 以下是配置的一些工作流相关的信息# -->
????<!-- ###################### -->
????<!-- hql queries and type defs -->
????<value>org/jbpm/db/hibernate.queries.hbm.xml</value>
????<!-- graph.def mapping files -->
??????? ?<value>
??????????????? org/jbpm/graph/def/ProcessDefinition.hbm.xml
??????? </value>
???????</list>
????<!-- # jbpm mapping files? 这里不是我的重点。省略不提# -->
??</property>
??<property name="hibernateProperties">
???<props>
?????? <prop key="hibernate.dialect">
????????????? org.hibernate.dialect.SQLServerDialect
?????? </prop>
<!-- # jbpm mapping files? 这里是我的重点# -->
<!--
Hibernate SQL方言 (hibernate.dialect)
如果出现如下错误，则可能是Hibernate SQL方言 (hibernate.dialect)设置不正确。
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]'last_insert_id' 不是可以识别的 函数名。
RDBMS |
方言 |
| 