java - 无法将 Hibernate 项目与 MySQL 数据库连接
问题描述
关于数据库的详细信息我是hibernate的新手。我创建了一个hibernate项目。但它无法连接到MySQL数据库。我使用SQL工作台作为数据库,使用XAMPP服务器作为SQL服务器。请帮我将数据传递给mysql数据库通过hibernate项目。
错误信息:
请求处理失败;嵌套异常是 org.springframework.transaction.CannotCreateTransactionException:无法为事务打开 Hibernate Session;嵌套异常是 org.hibernate.exception.GenericJDBCException:无法打开连接
错误描述:
服务器遇到一个内部错误,导致它无法完成此请求。
例外:
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:973)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
调度程序-servlet.xml
<context:component-scan base-package="com.candidjava.springmvc.controller" />
<context:property-placeholder location="classpath:database.properties" />
<mvc:annotation-driven />
<bean id="dataSource111" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${database.driver}" />
<property name="url" value="${database.url}" />
<property name="username" value="${database.user}" />
<property name="password" value="${database.password}" />
</bean>
<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource111" />
<property name="annotatedClasses">
<list>
<value>com.candidjava.springmvc.entity.Employee</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">${hibernate.dialect}</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
</props>
</property>
</bean>
<tx:annotation-driven/>
<bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<bean id="persistenceExceptionTranslationPostProcessor" class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor"/>
<bean id="jspViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
<property name="prefix" value="/WEB-INF/pages/" />
<property name="suffix" value=".jsp" />
</bean>
<bean id="employeeDao" class="com.candidjava.springmvc.dao.impl.EmployeeDAOImpl" />
<bean id="employeeService" class="com.candidjava.springmvc.service.impl.EmployeeServiceImpl" />
数据库属性
database.driver=com.mysql.jdbc.Driver
database.url=jdbc:mysql://localhost:3306/test
database.user=root
database.password=root
hibernate.dialect=org.hibernate.dialect.MySQLDialect
hibernate.show_sql=true
hibernate.hbm2ddl.auto=update
解决方案
推荐阅读
- javascript - stopPropagation 还停止同一父级中的其他兄弟事件
- java - 仅当池已满时 Hikari 连接超时
- java - 如何修复 toString 中意外的字符串输出“null”
- linux-kernel - 为什么 ARM SMP Linux 内核强制缓存策略为 writealloc?
- linux - 在 Linux 登录配置文件中设置 Vi 编辑器配置
- php - Codeigniter中表单生成器的更改方法
- sql - 如何查询:“这些值适用于哪些”?
- python - 使用 JSON 输入将 JSON 转换为表格格式
- javascript - 拆分包含连续逗号和用引号括起来的逗号的字符串
- linux - How to access a C global variable through GOT in GAS assembly on x86-64 Linux?