nekolr edited a comment on issue #15629:
URL:
https://github.com/apache/shardingsphere/issues/15629#issuecomment-1064699460
i got the same problem when i using
`org.springframework.data.repository.CrudRepository#findById`.
i traced the call stack and found the reason:
> refer:
hibernate-core\5.6.5.Final\hibernate-core-5.6.5.Final.jar!\org\hibernate\resource\jdbc\internal\AbstractLogicalConnectionImplementor.class
```
public void begin() {
try {
if (!this.doConnectionsFromProviderHaveAutoCommitDisabled()) {
log.trace("Preparing to begin transaction via JDBC
Connection.setAutoCommit(false)");
// here
this.getConnectionForTransactionManagement().setAutoCommit(false);
log.trace("Transaction begun via JDBC
Connection.setAutoCommit(false)");
}
this.status = TransactionStatus.ACTIVE;
} catch (SQLException var2) {
throw new TransactionException("JDBC begin transaction failed: ",
var2);
}
}
```
call stack:
```
setAutoCommit:129, ShardingSphereConnection
(org.apache.shardingsphere.driver.jdbc.core.connection)
begin:72, AbstractLogicalConnectionImplementor
(org.hibernate.resource.jdbc.internal)
begin:285, LogicalConnectionManagedImpl
(org.hibernate.resource.jdbc.internal)
begin:246,
JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl
(org.hibernate.resource.transaction.backend.jdbc.internal)
begin:83, TransactionImpl (org.hibernate.engine.transaction.internal)
beginTransaction:164, HibernateJpaDialect
(org.springframework.orm.jpa.vendor)
doBegin:421, JpaTransactionManager (org.springframework.orm.jpa)
startTransaction:400, AbstractPlatformTransactionManager
(org.springframework.transaction.support)
getTransaction:373, AbstractPlatformTransactionManager
(org.springframework.transaction.support)
createTransactionIfNecessary:595, TransactionAspectSupport
(org.springframework.transaction.interceptor)
invokeWithinTransaction:382, TransactionAspectSupport
(org.springframework.transaction.interceptor)
invoke:119, TransactionInterceptor
(org.springframework.transaction.interceptor)
proceed:186, ReflectiveMethodInvocation (org.springframework.aop.framework)
invoke:137, PersistenceExceptionTranslationInterceptor
(org.springframework.dao.support)
proceed:186, ReflectiveMethodInvocation (org.springframework.aop.framework)
invoke:174,
CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor
(org.springframework.data.jpa.repository.support)
proceed:186, ReflectiveMethodInvocation (org.springframework.aop.framework)
invoke:97, ExposeInvocationInterceptor (org.springframework.aop.interceptor)
proceed:186, ReflectiveMethodInvocation (org.springframework.aop.framework)
invoke:215, JdkDynamicAopProxy (org.springframework.aop.framework)
findById:-1, $Proxy237 (com.sun.proxy)
getUser:18, UserService (com.example.mysqlreadwrite)
getUser:20, UserController (com.example.mysqlreadwrite)
invoke0:-1, NativeMethodAccessorImpl (sun.reflect)
invoke:62, NativeMethodAccessorImpl (sun.reflect)
invoke:43, DelegatingMethodAccessorImpl (sun.reflect)
invoke:498, Method (java.lang.reflect)
doInvoke:205, InvocableHandlerMethod (org.springframework.web.method.support)
invokeForRequest:150, InvocableHandlerMethod
(org.springframework.web.method.support)
invokeAndHandle:117, ServletInvocableHandlerMethod
(org.springframework.web.servlet.mvc.method.annotation)
invokeHandlerMethod:895, RequestMappingHandlerAdapter
(org.springframework.web.servlet.mvc.method.annotation)
handleInternal:808, RequestMappingHandlerAdapter
(org.springframework.web.servlet.mvc.method.annotation)
handle:87, AbstractHandlerMethodAdapter
(org.springframework.web.servlet.mvc.method)
doDispatch:1067, DispatcherServlet (org.springframework.web.servlet)
doService:963, DispatcherServlet (org.springframework.web.servlet)
processRequest:1006, FrameworkServlet (org.springframework.web.servlet)
doGet:898, FrameworkServlet (org.springframework.web.servlet)
service:655, HttpServlet (javax.servlet.http)
service:883, FrameworkServlet (org.springframework.web.servlet)
service:764, HttpServlet (javax.servlet.http)
internalDoFilter:227, ApplicationFilterChain (org.apache.catalina.core)
doFilter:162, ApplicationFilterChain (org.apache.catalina.core)
doFilter:53, WsFilter (org.apache.tomcat.websocket.server)
internalDoFilter:189, ApplicationFilterChain (org.apache.catalina.core)
doFilter:162, ApplicationFilterChain (org.apache.catalina.core)
doFilterInternal:100, RequestContextFilter (org.springframework.web.filter)
doFilter:117, OncePerRequestFilter (org.springframework.web.filter)
internalDoFilter:189, ApplicationFilterChain (org.apache.catalina.core)
doFilter:162, ApplicationFilterChain (org.apache.catalina.core)
doFilterInternal:93, FormContentFilter (org.springframework.web.filter)
doFilter:117, OncePerRequestFilter (org.springframework.web.filter)
internalDoFilter:189, ApplicationFilterChain (org.apache.catalina.core)
doFilter:162, ApplicationFilterChain (org.apache.catalina.core)
doFilterInternal:201, CharacterEncodingFilter
(org.springframework.web.filter)
doFilter:117, OncePerRequestFilter (org.springframework.web.filter)
internalDoFilter:189, ApplicationFilterChain (org.apache.catalina.core)
doFilter:162, ApplicationFilterChain (org.apache.catalina.core)
invoke:197, StandardWrapperValve (org.apache.catalina.core)
invoke:97, StandardContextValve (org.apache.catalina.core)
invoke:540, AuthenticatorBase (org.apache.catalina.authenticator)
invoke:135, StandardHostValve (org.apache.catalina.core)
invoke:92, ErrorReportValve (org.apache.catalina.valves)
invoke:78, StandardEngineValve (org.apache.catalina.core)
service:359, CoyoteAdapter (org.apache.catalina.connector)
service:399, Http11Processor (org.apache.coyote.http11)
process:65, AbstractProcessorLight (org.apache.coyote)
process:889, AbstractProtocol$ConnectionHandler (org.apache.coyote)
doRun:1735, NioEndpoint$SocketProcessor (org.apache.tomcat.util.net)
run:49, SocketProcessorBase (org.apache.tomcat.util.net)
runWorker:1191, ThreadPoolExecutor (org.apache.tomcat.util.threads)
run:659, ThreadPoolExecutor$Worker (org.apache.tomcat.util.threads)
run:61, TaskThread$WrappingRunnable (org.apache.tomcat.util.threads)
run:748, Thread (java.lang)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
