java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • throws execption while start the process
    via by Swapnil Ugare,
  • Scenario error while adding item to cart
    via by Ravi Mandli,
  • Transaction is not active Spring Data JPA
    via Stack Overflow by Raj Kumar
    ,
    • java.sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:154) at org.jbpm.services.task.identity.DBUserGroupCallbackImpl.checkExistence(DBUserGroupCallbackImpl.java:169)[jbpm-human-task-core-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.services.task.identity.DBUserGroupCallbackImpl.existsGroup(DBUserGroupCallbackImpl.java:86)[jbpm-human-task-core-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.services.task.commands.UserGroupCallbackTaskCommand.doCallbackGroupOperation(UserGroupCallbackTaskCommand.java:90)[jbpm-human-task-core-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.services.task.commands.UserGroupCallbackTaskCommand.doCallbackOperationForPeopleAssignments(UserGroupCallbackTaskCommand.java:226)[jbpm-human-task-core-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.services.task.commands.AddTaskCommand.execute(AddTaskCommand.java:102)[jbpm-human-task-core-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.services.task.commands.AddTaskCommand.execute(AddTaskCommand.java:53)[jbpm-human-task-core-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:65)[jbpm-human-task-core-6.2.0.Final.jar:6.2.0.Final] at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)[drools-core-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:54)[jbpm-human-task-jpa-6.2.0.Final.jar:6.2.0.Final] at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)[drools-core-6.2.0.Final.jar:6.2.0.Final] at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:79)[drools-persistence-jpa-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.services.task.commands.TaskCommandExecutorImpl.execute(TaskCommandExecutorImpl.java:40)[jbpm-human-task-core-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.services.task.impl.command.CommandBasedTaskService.addTask(CommandBasedTaskService.java:523)[jbpm-human-task-core-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.runtime.manager.impl.task.SynchronizedTaskService.addTask(SynchronizedTaskService.java:449)[jbpm-runtime-manager-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.services.task.wih.LocalHTWorkItemHandler.executeWorkItem(LocalHTWorkItemHandler.java:61)[jbpm-human-task-workitems-6.2.0.Final.jar:6.2.0.Final] at org.drools.persistence.jpa.processinstance.JPAWorkItemManager.internalExecuteWorkItem(JPAWorkItemManager.java:55)[drools-persistence-jpa-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.workflow.instance.node.WorkItemNodeInstance.internalTrigger(WorkItemNodeInstance.java:133)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.workflow.instance.impl.NodeInstanceImpl.trigger(NodeInstanceImpl.java:171)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.workflow.instance.impl.NodeInstanceImpl.triggerNodeInstance(NodeInstanceImpl.java:364)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.workflow.instance.impl.NodeInstanceImpl.triggerCompleted(NodeInstanceImpl.java:323)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.workflow.instance.node.StartNodeInstance.triggerCompleted(StartNodeInstance.java:73)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.workflow.instance.node.StartNodeInstance.internalTrigger(StartNodeInstance.java:44)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.workflow.instance.impl.NodeInstanceImpl.trigger(NodeInstanceImpl.java:171)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.ruleflow.instance.RuleFlowProcessInstance.internalStart(RuleFlowProcessInstance.java:35)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.process.instance.impl.ProcessInstanceImpl.start(ProcessInstanceImpl.java:236)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.workflow.instance.impl.WorkflowProcessInstanceImpl.start(WorkflowProcessInstanceImpl.java:389)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.process.instance.ProcessRuntimeImpl.startProcessInstance(ProcessRuntimeImpl.java:195)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.process.instance.ProcessRuntimeImpl.startProcess(ProcessRuntimeImpl.java:177)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.jbpm.process.instance.ProcessRuntimeImpl.startProcess(ProcessRuntimeImpl.java:169)[jbpm-flow-6.2.0.Final.jar:6.2.0.Final] at org.drools.core.impl.StatefulKnowledgeSessionImpl.startProcess(StatefulKnowledgeSessionImpl.java:1901)[drools-core-6.2.0.Final.jar:6.2.0.Final] at org.drools.core.command.runtime.process.StartProcessCommand.execute(StartProcessCommand.java:122)[drools-core-6.2.0.Final.jar:6.2.0.Final] at org.drools.core.command.runtime.process.StartProcessCommand.execute(StartProcessCommand.java:40)[drools-core-6.2.0.Final.jar:6.2.0.Final] at org.drools.core.command.impl.DefaultCommandService.execute(DefaultCommandService.java:36)[drools-core-6.2.0.Final.jar:6.2.0.Final] at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)[drools-core-6.2.0.Final.jar:6.2.0.Final] at org.drools.persistence.SingleSessionCommandService$TransactionInterceptor.execute(SingleSessionCommandService.java:548)[drools-persistence-jpa-6.2.0.Final.jar:6.2.0.Final] at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)[drools-core-6.2.0.Final.jar:6.2.0.Final] at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:73)[drools-persistence-jpa-6.2.0.Final.jar:6.2.0.Final] at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)[drools-core-6.2.0.Final.jar:6.2.0.Final] at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:79)[drools-persistence-jpa-6.2.0.Final.jar:6.2.0.Final] at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:358)[drools-persistence-jpa-6.2.0.Final.jar:6.2.0.Final] at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:242)[drools-core-6.2.0.Final.jar:6.2.0.Final] at com.servlets.startProcess.doPost(startProcess.java:146)[classes:] at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)[jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final] at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)[jboss-servlet-api_3.1_spec-1.0.0.Final.jar:1.0.0.Final] at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)[undertow-core-1.0.15.Final.jar:1.0.15.Final] at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:113)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)[undertow-core-1.0.15.Final.jar:1.0.15.Final] at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45)[undertow-core-1.0.15.Final.jar:1.0.15.Final] at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:61)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)[undertow-core-1.0.15.Final.jar:1.0.15.Final] at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)[undertow-core-1.0.15.Final.jar:1.0.15.Final] at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)[undertow-core-1.0.15.Final.jar:1.0.15.Final] at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)[undertow-core-1.0.15.Final.jar:1.0.15.Final] at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:25)[undertow-core-1.0.15.Final.jar:1.0.15.Final] at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:240)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:227)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:73)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:146)[undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at io.undertow.server.Connectors.executeRootHandler(Connectors.java:177)[undertow-core-1.0.15.Final.jar:1.0.15.Final] at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:727)[undertow-core-1.0.15.Final.jar:1.0.15.Final] at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)[rt.jar:1.8.0_66] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)[rt.jar:1.8.0_66] at java.lang.Thread.run(Unknown Source)[rt.jar:1.8.0_66] Caused by: javax.resource.ResourceException: IJ000460: Error checking for a transaction at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:416) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:513) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146) ... 70 more Caused by: javax.resource.ResourceException: IJ000459: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffffc0a80109:46e63615:568a6f2e:5a status: ActionStatus.ABORT_ONLY > at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:400) ... 72 more

    Users with the same issue

    ivanszkypeter
    1 times, last one,
    Andreas Häber
    1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    22 more bugmates