Styjun

Why did it become so much more expensive to start a university?

Why don’t low light cameras just use bigger sensors?

Is it fair to ask my employer for personal laptop insurance?

Are Democrats more likely to believe Astrology is a science?

"Literally" Vs "In the true sense of the word"

How seriously should I take a CBP interview where I was told I have a red flag and could only stay for 30 days?

What is this unknown executable on my boot volume? Is it Malicious?

What exactly is a marshrutka (маршрутка)?

Is there an inconsistency about Natasha Romanoff's middle name in the MCU?

Might have gotten a coworker sick, should I address this?

Where can I get an anonymous Rav Kav card issued?

How to stabilise the bicycle seatpost and saddle when it is all the way up?

Why aren't tangent spaces simply defined as vector spaces with same dimension as the manifold?

Why do sellers care about down payments?

What jurisdiction do Scottish courts have over the Westminster parliament?

Why did they ever make smaller than full-frame sensors?

Where can I find vomiting people?

A medieval fantasy adventurer lights a torch in a 100% pure oxygen room. What happens?

Job offer without any details but asking me to withdraw other applications - is it normal?

Where does the expression "triple-A" come from?

Writing a love interest for my hero

Do any aircraft carry boats?

A shy person in a queue

Glue or not to glue boots

How can I Use JpaSpecificationExecutor from Spring-Jpa without transaction

How can I prevent SQL injection in PHP?How to solve “Plugin execution not covered by lifecycle configuration” for Spring Data Maven BuildsHow to add custom method to Spring Data JPAWhat is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?Multiple statements Delphi TZquery (Zeos) errorUpdates & transactions in Spring Data JPASpring Data JPA + JpaSpecificationExecutor + EntityGraphShould autocommit of a datasource be set to false?When sharing a Jdbc connection pool between spring-data-jpa and spring-security-oauth's JdbcTokenStore, how to handle transactions?Spring Data and @Transactional does not rollback when there are multiple saves

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

enter image description hereWhen I using JpaSpecificationExecutor doing findAll, I found it
automatically adding transaction, starting sql with

set autocommit = 0;

And I don't want it.

I test JpaRepository, doing the same select sql and it didn't go with
set autocommit = 0;

but the JpaSpecificationExecutor has.

Then I break point it and find out there is a PROXY do that adding transaction thing, but I don't know how to disable it.

I do set defaultAutoCommit: true

And I also set

datasource:

 tomcat:

 default-auto-commit: true

 dbcp2:

 default-auto-commit: true

the connection pool is already defaultAutoCommit=true

it didn't help

so I blame the JpaSpecificationExecutor

@Repository
public interface GameRepository extends JpaRepository<GameEntity, Integer>, JpaSpecificationExecutor<GameEntity> 
 List<GameEntity> findByName(String name);

public List<GameEntity> search(HttpServletRequest request) 
 return mGameRepository.findAll(searchAction(request), new Sort(Sort.Direction.DESC, "id"));
 

break point screen cut

mysql spring-data-jpa spring-data spring-transactions

share|improve this question

asked Mar 28 at 9:29

LoranzoTangLoranzoTang

111 bronze badge

add a comment | 

0

enter image description hereWhen I using JpaSpecificationExecutor doing findAll, I found it
automatically adding transaction, starting sql with

set autocommit = 0;

And I don't want it.

I test JpaRepository, doing the same select sql and it didn't go with
set autocommit = 0;

but the JpaSpecificationExecutor has.

Then I break point it and find out there is a PROXY do that adding transaction thing, but I don't know how to disable it.

I do set defaultAutoCommit: true

And I also set

datasource:

 tomcat:

 default-auto-commit: true

 dbcp2:

 default-auto-commit: true

the connection pool is already defaultAutoCommit=true

it didn't help

so I blame the JpaSpecificationExecutor

@Repository
public interface GameRepository extends JpaRepository<GameEntity, Integer>, JpaSpecificationExecutor<GameEntity> 
 List<GameEntity> findByName(String name);

public List<GameEntity> search(HttpServletRequest request) 
 return mGameRepository.findAll(searchAction(request), new Sort(Sort.Direction.DESC, "id"));
 

break point screen cut

mysql spring-data-jpa spring-data spring-transactions

share|improve this question

asked Mar 28 at 9:29

LoranzoTangLoranzoTang

111 bronze badge

add a comment | 

enter image description hereWhen I using JpaSpecificationExecutor doing findAll, I found it
automatically adding transaction, starting sql with

set autocommit = 0;

And I don't want it.

I test JpaRepository, doing the same select sql and it didn't go with
set autocommit = 0;

but the JpaSpecificationExecutor has.

Then I break point it and find out there is a PROXY do that adding transaction thing, but I don't know how to disable it.

I do set defaultAutoCommit: true

And I also set

datasource:

 tomcat:

 default-auto-commit: true

 dbcp2:

 default-auto-commit: true

the connection pool is already defaultAutoCommit=true

it didn't help

so I blame the JpaSpecificationExecutor

@Repository
public interface GameRepository extends JpaRepository<GameEntity, Integer>, JpaSpecificationExecutor<GameEntity> 
 List<GameEntity> findByName(String name);

public List<GameEntity> search(HttpServletRequest request) 
 return mGameRepository.findAll(searchAction(request), new Sort(Sort.Direction.DESC, "id"));
 

break point screen cut

mysql spring-data-jpa spring-data spring-transactions

share|improve this question

asked Mar 28 at 9:29

LoranzoTangLoranzoTang

111 bronze badge

datasource:

 tomcat:

 default-auto-commit: true

 dbcp2:

 default-auto-commit: true

@Repository
public interface GameRepository extends JpaRepository<GameEntity, Integer>, JpaSpecificationExecutor<GameEntity> 
 List<GameEntity> findByName(String name);

public List<GameEntity> search(HttpServletRequest request) 
 return mGameRepository.findAll(searchAction(request), new Sort(Sort.Direction.DESC, "id"));
 

share|improve this question

asked Mar 28 at 9:29

LoranzoTangLoranzoTang

111 bronze badge

share|improve this question

asked Mar 28 at 9:29

LoranzoTangLoranzoTang

111 bronze badge

asked Mar 28 at 9:29

LoranzoTangLoranzoTang

111 bronze badge

asked Mar 28 at 9:29

LoranzoTangLoranzoTang

111 bronze badge

1 Answer
1

active

oldest

votes

0

Turns out all the CRUD methods (CrudRepository methods) are by default marked as transactional.

But how can I unmark it?

share|improve this answer

answered Mar 30 at 3:40

LoranzoTangLoranzoTang

111 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @EnableJpaRepositories has an attribute enableDefaultTransactions defaulting to true. If you disable this, Spring Data assumes you're manually taking care of transactions required by JPA. --- this is from Oliver Drotbohm
  
  – LoranzoTang
  Apr 12 at 8:16
  
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55394147%2fhow-can-i-use-jpaspecificationexecutor-from-spring-jpa-without-transaction%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Turns out all the CRUD methods (CrudRepository methods) are by default marked as transactional.

But how can I unmark it?

share|improve this answer

answered Mar 30 at 3:40

LoranzoTangLoranzoTang

111 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @EnableJpaRepositories has an attribute enableDefaultTransactions defaulting to true. If you disable this, Spring Data assumes you're manually taking care of transactions required by JPA. --- this is from Oliver Drotbohm
  
  – LoranzoTang
  Apr 12 at 8:16
  
  

  
  
  
  

add a comment | 

0

Turns out all the CRUD methods (CrudRepository methods) are by default marked as transactional.

But how can I unmark it?

share|improve this answer

answered Mar 30 at 3:40

LoranzoTangLoranzoTang

111 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @EnableJpaRepositories has an attribute enableDefaultTransactions defaulting to true. If you disable this, Spring Data assumes you're manually taking care of transactions required by JPA. --- this is from Oliver Drotbohm
  
  – LoranzoTang
  Apr 12 at 8:16
  
  

  
  
  
  

add a comment | 

Turns out all the CRUD methods (CrudRepository methods) are by default marked as transactional.

But how can I unmark it?

share|improve this answer

answered Mar 30 at 3:40

LoranzoTangLoranzoTang

111 bronze badge

share|improve this answer

answered Mar 30 at 3:40

LoranzoTangLoranzoTang

111 bronze badge

answered Mar 30 at 3:40

LoranzoTangLoranzoTang

111 bronze badge

answered Mar 30 at 3:40

LoranzoTangLoranzoTang

111 bronze badge