ssh整合Caused by: org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection

喜欢ヅ旅行 2022-09-30 11:56 174阅读 0赞

<context:property-placeholder location="classpath:jdbc.properties"/>
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    		<property name="url" value="${jdbc.url}"></property>
    		<property name="username" value="${jdbc.username}"></property>
    		<property name="password" value="${jdbc.password}"></property>
    		<property name="driverClassName" value="${jdbc.driverClassName}"></property>
    	</bean>
    	
    	<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    		<property name="dataSource" ref="dataSource"></property>
    		<property name="hibernateProperties">
    			<props>
    				<prop key="dialect">org.hibernate.dialect.SQLServerDialect</prop>
    				<prop key="hibernate.show_sql">true</prop>
    				<prop key="hbm2ddl.auto">update</prop>
    			</props>
    		</property>
    		<property name="mappingLocations" value="classpath:com/gcp/model/*.hbm.xml">
    		</property>
    	</bean>

这里贴出applicationContext.xml的数据链接部分代码

jdbc.properties
    
    jdbc.driverClassName=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost/:3306/db_shop
    jdbc.username=root
    jdbc.password=123456

然后- -，我尝试网上的很多方法不行，就把dataSource配置动态读取jdbc配置 改为固定的

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    		<property name="driverClassName" value="com.mysql.jdbc.Driver"/>  
    	    <property name="url" value="jdbc:mysql://localhost:3306/db_shop" />  
    	    <property name="username" value="root" />  
    	    <property name="password" value="123456" />  
    	</bean>

然后就没有报错了。虽然不知道哪里错了