spring Data jpa to mysql error

最新推荐文章于 2021-11-04 17:21:00 发布
最新推荐文章于 2021-11-04 17:21:00 发布
阅读量298 收藏
点赞数
分类专栏： java 文章标签： 数据库 测试 java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/javaee_jsp/article/details/84686881
版权

2014-11-20 9:53:22 com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable

警告: [c3p0] A PooledConnection that has already signalled a Connection error is still in use!

2014-11-20 9:53:22 com.mchange.v2.c3p0.impl.NewPooledConnection handleThrowable

警告: [c3p0] Another error has occurred [ java.sql.SQLNonTransientConnectionException: Could not send query: Last packet not finished ] which will not be reported to listeners!

java.sql.SQLNonTransientConnectionException: Could not send query: Last packet not finished

at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:136)

at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)

at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:264)

at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:288)

at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:338)

at org.mariadb.jdbc.MySQLConnection.rollback(MySQLConnection.java:244)

at com.mchange.v2.c3p0.impl.NewProxyConnection.rollback(NewProxyConnection.java:855)

at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:213)

at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:192)

at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:88)

at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:513)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755)

at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)

at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:475)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:270)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:633)

at com.zc.lottery.business.service.lotterys.sports.jc.jczq.impl.JczqSchemeServiceImpl$$EnhancerBySpringCGLIB$$a06ca3fb.createScheme(<generated>)

at com.zc.lottery.web.lottery.fore.lotterys.sports.jczq.JczqController.createScheme(JczqController.java:213)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:855)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)

at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)

at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)

at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)

at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)

at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)

at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)

at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)

at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)

at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)

at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.orm.jpa.support.OpenEntityManagerInViewFilter.doFilterInternal(OpenEntityManagerInViewFilter.java:180)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.zc.lottery.web.core.common.web.TimerFilter.doFilter(TimerFilter.java:35)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)

at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)

at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1760)

at java.lang.Thread.run(Thread.java:662)

Caused by: org.mariadb.jdbc.internal.common.QueryException: Could not send query: Last packet not finished

at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:984)

at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:281)

... 72 more

Caused by: java.io.IOException: Last packet not finished

at org.mariadb.jdbc.internal.common.packet.PacketOutputStream.startPacket(PacketOutputStream.java:38)

at org.mariadb.jdbc.internal.common.packet.commands.StreamedQueryPacket.send(StreamedQueryPacket.java:76)

at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:982)

... 73 more

 

将mariadb-java-client 换成 mysql-connector-java.jar,然后设置MySQL下my.ini

max_allowed_packet=70M （默认为：1M）

重新启动tomcat，OK；

javaee_jsp
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
解决[c3p0] A PooledConnection that has already signalled a Connection error is still in use
老尹的笔记
01-07 1万+
1.[c3p0] A PooledConnection that has already signalled a Connection error is still in useYou have to use either Transaction.commit even if you are only doing a select. 2.可以使用的参数，除了连接串以外
[问题][已解决]java.io.IOException: Last packet not finished
蜗牛的专栏
10-26 3606
Caused by: java.io.IOException: Last packet not finished at org.mariadb.jdbc.internal.common.packet.PacketOutputStream.startPacket(PacketOutputStream.java:38) at org.mariadb.jdbc.internal.common.pac
spring data jpa 连接mysql8.x的一些问题梳理总结.docx
03-12
Spring Data JPA 连接 MySQL 8.x 遇到的问题总结 Spring Data JPA 是一个基于 Java 的持久层框架，它提供了简洁的数据访问方式，支持多种数据库，包括 MySQL。然而，在使用 Spring Data JPA 连接 MySQL 8.x 时，...
Springboot集成spring-data-jpa增删查改使用ajax数据交互
07-01
在开发Web应用时，Spring Boot和Spring Data JPA是常用的技术框架，它们简化了数据库操作和前后端交互。本教程将详细介绍如何在Spring Boot项目中集成Spring Data JPA，实现CRUD（创建、读取、更新、删除）操作，并...
完美解决SpringDataJPA报错create table hibernate_sequence (next_val bigint) type=MyISAM Hibernate: create t
01-20
用Spring Boot JPA自动生成数据库的表的时候 报了一个错 SpringBoot版本：2.2.6.RELEASE MySQL版本：5.6 2020-04-09 12:52:29.990 INFO 14120 --- [ restartedMain] org.hibernate.dialect.Dialect : HHH000400: ...
spring Security Json 数据库登录验证
01-21
<artifactId>spring-boot-starter-data-jpa <groupId>mysql <artifactId>mysql-connector-java <scope>runtime ``` 接下来，我们需要配置Spring Security。在`src/main/java`目录下创建一个配置类，例如`...
Shiro-springBoot-mysql集成
10-17
<artifactId>spring-boot-starter-data-jpa ``` 接下来，我们需要配置数据库连接。在`application.properties`或`application.yml`中设置MySQL数据库的连接信息： ```properties # application.properties ...
c3p0错误java.sql.SQLException: Invalid state, the Co
学得越多,忘得越多;忘得越多,知道的越少
10-10 1088
C3P0再次报错.. [code="java"] [framework] 2008-10-10 22:54:05,890 - com.mchange.v2.c3p0.impl.NewPooledConnection -148383250 [TP-Processor11] WARN com.mchange.v2.c3p0.impl.NewPooledConnection - [c3p0]...
【Debug】 Packet for query is too large (1155878 ＞ 1048576)，max_allowed_packet设置.
一起进步
11-04 921
max_allowed_packet报错原因解决方法1：修改配置文件解决方法二：通过Mysql命令行解决 报错原因 向数据表中插入Blob类型的数据。报错： com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1155878 > 1048576). You can change this value on the server by setting the max_allowed_packet’ variable.
mysql max allow_mysql max_allowed_packet过小引起的问题
weixin_29461699的博客
01-19 97
mysql max_allowed_packet过小引起的问题com.mysql.jdbc.PacketTooBigException: Packet for query is too large (5366885 > 4194304)Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large ...
关于max_allowed_packet的修改
sz_bdqn的专栏
06-06 1720
项目中查询的时候会好好的，但是有时候会突然间报错：packet for query is too large(2248>1024),you can change this value on the server by setting the max_allowed_packet variable. SHOW VARIABLES LIKE '%max_allowed_packet%';
线上遇到插入重复数据(重复提交)
Flyer的后花园
05-19 5152
今天发现日志 有人登陆不上系统 个人信息发现有重复记录  数据库插入的秒数都一样 当时服务器比较卡 日志如下 2016.05.19 17:51:15 com.mchange.v2.c3p0.impl.NewPooledConnection - [c3p0] A PooledConnection that has already signalled a Connectio
【J2EE】【2.JDBC】JDBC连接数据库（MariaDB，Mysql）（继续之前jee的登陆例子）
热门推荐
12-14 1万+
JDBC（Java Data Base Connectivity,java数据库连接）是一种用于执行SQL语句的Java API，可以为多种关系数据库提供统一访问，它由一组用Java语言编写的类和接口组成。JDBC提供了一种基准，据此可以构建更高级的工具和接口，使数据库开发人员能够编写数据库应用程序。
c3p0报错：Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a nee
zqmy_的博客
01-22 6251
可能是这些原因造成： 1，驱动配置有误：driver=com.mysql.jdbc.Driver 2，数据库连接地址有误：url=jdbc:mysql://localhost:3306/test 3，密码或帐号有误：username=root       password=root 4，数据库未启动或无权访问 5，项目未引入对应的驱动jar包mysql-connector-java-5.1....
org.mariadb.jdbc.internal.com.send.authentication.SendGssApiAuthPacket could not be instantiated
ww_ndsc_ww的专栏
10-11 594
docker+slueth+zipkin+rabbitmq+mysql实现链路追踪 问题：使用mysql8.0版本，启动zipkin后查询，报错如下： Provider org.mariadb.jdbc.internal.com.send.authentication.SendGssApiAuthPacket could not be instantiated
用spring boot+html+mysql制作一个登录
最新发布
05-19
好的，下面是一个简单的登录系统的步骤： 1. 创建一个 Spring Boot 工程，并添加所需的依赖。在 pom.xml 文件中添加以下依赖： ``` <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-thymeleaf</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> </dependencies> ``` 2. 在 `application.properties` 文件中配置数据库连接信息： ``` spring.datasource.url=jdbc:mysql://localhost:3306/mydb?useSSL=false&serverTimezone=UTC spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect spring.jpa.hibernate.ddl-auto=update ``` 3. 创建一个用户实体类，用于映射数据库表： ```java @Entity @Table(name = "user") public class User { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @Column(nullable = false, unique = true) private String username; @Column(nullable = false) private String password; public User() { } public User(String username, String password) { this.username = username; this.password = password; } // getter 和 setter 略 } ``` 4. 创建一个 UserRepository 接口，继承自 JpaRepository 接口，用于操作数据库： ```java public interface UserRepository extends JpaRepository<User, Long> { User findByUsername(String username); } ``` 5. 创建一个控制器类，用于处理登录相关的请求： ```java @Controller public class LoginController { @Autowired private UserRepository userRepository; @GetMapping("/") public String index() { return "login"; } @PostMapping("/login") public String login(String username, String password, HttpSession session, Model model) { User user = userRepository.findByUsername(username); if (user != null && user.getPassword().equals(password)) { session.setAttribute("user", user); return "redirect:/home"; } else { model.addAttribute("error", "用户名或密码错误"); return "login"; } } @GetMapping("/home") public String home(HttpSession session, Model model) { User user = (User) session.getAttribute("user"); if (user != null) { model.addAttribute("username", user.getUsername()); return "home"; } else { return "redirect:/"; } } @GetMapping("/logout") public String logout(HttpSession session) { session.removeAttribute("user"); return "redirect:/"; } } ``` 6. 创建登录页面和主页页面。在 `resources/templates` 目录下创建两个 HTML 文件：`login.html` 和 `home.html`。以 `login.html` 为例： ```html <!DOCTYPE html> <html xmlns:th="http://www.thymeleaf.org"> <head> <meta charset="UTF-8"> <title>登录</title> </head> <body> <h1>登录</h1> <form method="post" action="/login"> <div> <label for="username">用户名：</label> <input type="text" id="username" name="username"> </div> <div> <label for="password">密码：</label> <input type="password" id="password" name="password"> </div> <div> <button type="submit">登录</button> </div> <div th:if="${error}"> <p th:text="${error}"></p> </div> </form> </body> </html> ``` 7. 启动项目，在浏览器中访问 `http://localhost:8080/`，就可以看到登录页面了。输入正确的用户名和密码，点击登录按钮，就可以跳转到主页页面了。在主页页面中点击注销按钮，就可以退出登录。 以上就是一个简单的登录系统的制作过程，希望对你有所帮助。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值