jpa assignment order

Spring Data JPA Sort/Order by multiple Columns | Spring Boot

In previous tutorial, we’ve known how to build Spring Boot Rest CRUD Apis with Spring Data JPA. Today I will show you how to sort/order result by multiple Columns in Spring Boot with Spring Data JPA. You also know way to apply sorting and paging together.

Related Posts: – JPA – filter by multiple Columns – Spring Boot, Spring Data JPA – Rest CRUD API example – Spring Boot Pagination & Filter example | Spring JPA, Pageable – Spring Boot @ControllerAdvice & @ExceptionHandler example

More Practice: – Spring Boot Token based Authentication with Spring Security & JWT – Spring Boot One To One example with JPA, Hibernate – Spring Boot One To Many example with JPA, Hibernate – Spring Boot Many to Many example with JPA, Hibernate – Spring Boot Unit Test for JPA Repository – Spring Boot Unit Test for Rest Controller – Documentation: Spring Boot Swagger 3 example – Caching: Spring Boot Redis Cache example – Validation: Spring Boot Validate Request Body

Spring Data Sort multiple Columns example Overview

Order by multiple columns with spring data jpa, spring data sort and order, paging and sorting, spring boot application, repository that supports paging and sorting, controller with sort/order by multiple columns, further reading, source code.

Assume that we have tutorials table in database like this:

Here are some url samples for order by single/multiple Columns (with/without paging), sort by Ascending or Descending:

• /api/tutorials sort by [id, descending] (default)
• /api/tutorials?sort=title,asc sort by [title, ascending]
• /api/tutorials?sort=published,desc&sort=title,asc order by column [published, descending], then order by column [title, ascending]
• /api/tutorials?page=0&size=3&sort=published,desc&sort=title,asc order by column [published, descending], then order by column [title, ascending] together with pagination

In this tutorial, to help you have a clear idea in Sorting using Spring Boot, I will create separated endpoints with different response structure:

• for Sorting by Multiple Columns: /api/sortedtutorials
• for Paging & Sorting coming together: /api/tutorials

Let’s look at the result after building this Spring Boot Application:

– Get all Tutorials with default order [id, descending]:

– Get all Tutorials, sort by single column [title, ascending]:

– Get all Tutorials, sort by multiple columns [published, descending] & [title, ascending]:

To help us deal with this situation, Spring Data JPA provides way to implement pagination with PagingAndSortingRepository .

PagingAndSortingRepository extends CrudRepository to provide additional methods to retrieve entities using the sorting abstraction. So you can add a special Sort parameter to your query method.

findAll(Sort sort) : returns a Iterable of entities meeting the sorting condition provided by Sort object.

You can also define more derived and custom query methods with additional Sort parameter. For example, the following method returns List of Tutorials which title contains a given string:

You can find more supported keywords inside method names here .

Let’s continue to explore Sort class.

The Sort class provides sorting options for database queries with more flexibility in choosing single/multiple sort columns and directions (ascending/descending).

For example, we use by() , descending() , and() methods to create Sort object and pass it to Repository.findAll() :

We can also create a new Sort object with List of Order objects.

What if we want todo both sorting and paging the data?

CrudRepository also provides additional methods to retrieve entities using the pagination abstraction.

findAll(Pageable pageable) : returns a Page of entities meeting the paging condition provided by Pageable object.

Spring Data also supports many useful Query Creation from method names that we’re gonna use to filter result in this example such as:

For more details about Pagination and Sorting, please visit: Spring Boot Pagination and Sorting example

You can follow step by step, or get source code in this post: Spring Boot, Spring Data JPA – Rest CRUD API example

The Spring Project contains structure that we only need to add some changes to make the pagination work well.

Or you can get the new Github source code (including paging and sorting) at the end of this tutorial.

This is the Tutorial entity that we’re gonna work:

model / Tutorial.java

Early in this tutorial, we know PagingAndSortingRepository , but in this example, for keeping the continuity and taking advantage Spring Data JPA, we continue to use JpaRepository which extends PagingAndSortingRepository interface.

repository / TutorialRepository.java

In the code above, we use add pageable parameter with Spring Query Creation to find all Tutorials which title containing input string.

More Derived queries at: JPA Repository query example in Spring Boot

Custom query with @Query annotation: Spring JPA @Query example: Custom query in Spring Boot

To get multiple sort request parameters, we use @RequestParam String[] sort with defaultValue = "id,desc" .

Before writing the Controller method to handle the case, let’s see what we retrieve with the parameters:

• ?sort=column1,direction1 : sorting single column String[] sort is an array with 2 elements: [“column1”, “direction1”]
• ?sort=column1,direction1&sort=column2,direction2 : sorting multiple columns String[] sort is also an array with 2 elements: [“column1, direction1”, “column2, direction2”]

That’s why we need to check if the first item in the array contains "," or not.

We also need to convert "asc" / "desc" into Sort.Direction.ASC / Sort.Direction.DES for working with Sort.Order class.

controller / TutorialController.java

How about controller that brings pagination and sorting together? Please visit: Spring Boot Pagination and Sorting example

In this post, we have learned how to sort/order by multiple columns in Spring Boot application using Spring Data JPA, Sort class and Pageable interface.

We also see that JpaRepository supports a great way to make sorting, paging and filter methods without need of boilerplate code.

You can also know how to: – find by multiple Columns using JPA Repository – paging and filter in this article . – handle exception in this post . – deploy this Spring Boot App on AWS (for free) with this tutorial .

Happy learning! See you again.

• Spring Data JPA Reference Documentation
• org.springframework.data.domain.Sort
• Secure Spring Boot App with Spring Security & JWT Authentication

For pagination and sorting together: Spring Boot Pagination and Sorting example

You can find the complete source code for this tutorial on Github .

You can use the code as an additional feature for following Posts: – Spring Boot, Spring Data JPA, H2 example – Spring Boot, Spring Data JPA, MySQL example – Spring Boot, Spring Data JPA, PostgreSQL example – Spring Boot, Spring Data JPA, SQL Server example – Spring Boot, Spring Data JPA, Oracle example

Associations: – Spring Boot One To One example with JPA, Hibernate – Spring Boot One To Many example with JPA, Hibernate – Spring Boot Many to Many example with JPA, Hibernate

Unit Test: – Spring Boot Unit Test for JPA Repository – Spring Boot Unit Test for Rest Controller

5 thoughts to “Spring Data JPA Sort/Order by multiple Columns | Spring Boot”

Thx for the tutorial!

This is great bezkoder concise and to the point.

I just want to thank you for this tutorial.

Very thanks to you , the best tutorials

THE JAVA series is excellent with spring

Comments are closed to reduce spam. If you have any question, please send me an email.

• Json Formatter

Maintaining List Order in Jpa

If you want to maintain the order of a list of objects retrieve from the database using hibernate/jpa, use the @OrderColumn annotation. An additional column will be created in the database (if ddl is set to update) that will keep track of the order/position of an item in a list.

CAVEAT: If you change the position of an item in a list OR delete an item besides the last one, it will cause a multi update across the list to update all other positions. Be aware of this intensive operation for large lists.

JpaRepository findAll Order By

Order by clause is used to select from the database in two orders(ascending and descending) based on the column name. We can use findAll order by in JpaRepository by adding methods starting with findAllBy followed by OrderBy with property_name of JPA Entity class Asc or Desc keyword suffix[findAllByOrderByIdAsc() and findAllByOderByIdDesc()]. In this topic, we will learn how to use findAll in order by in JpaRepository using the Spring Boot application with Maven, Spring Web, Spring Data JPA, Lombok and H2 database.

Let’s create a Spring Boot restful web services application to implement findAll() query method with order by keyword in the JpaRepository step-by-step These are the following steps:

• Creating a Spring Boot Starter Project
• Keep the IDE ready
• Maven Dependency
• Defining the configuration
• Creating a JPA Entity
• Creating a JPA Repository
• Creating a Service Interface
• Creating a Service class
• Creating a Rest Controller class
• Run the Spring Application and Check

1. Creating a Spring Boot Starter Project

We are creating a Spring Boot Application from the web tool Spring Initializr or you can create it from the IDE(STS, VS Code etc.) you are using.  Add the following dependencies:

• Spring Data JPA
• H2 Database

2. Keep the IDE ready

We are importing this created application into our Eclipse IDE or you can import it into another IDE you are using. You can refer to this article to create and set up the Spring Boot Project in Eclipse IDE.

Project Structure of findAll Order By

3. Maven Dependency

Here is the complete pom.xml file for the Spring Boot Application. pom.xml

4. Defining the configuration

We are configuring the H2 database configuration in the application.properties file. application.properties

5. Creating a JPA Entity

We are creating a JPA entity class User with these properties(id, name, email and active). User.java

• This @Data annotation is used to a constructor, setter method, getter method, etc.
• This @Entity annotation is used to create a table through Java code in the database. 

6. Creating a JPA Repository

We are creating a JPA Repository to interact with the JPA Entity class. UserRepository.java

• findAllByOrderByIdDesc(): Adding this method to fetch the list of users in descending order based id property of the User entity class. 
• findAllByOrderByIdAsc(): Adding this method to fetch the list of users in ascending order based id property of the User entity class. 

7. Creating a Service Interface

We are creating a Service interface with some method declaration[saveAll(List userList), getAllOrderByIdDesc() and getAllOrderByIdAsc()]. So the implementation class of this interface overrides these declared methods. UserService.java

8. Creating a Service class

We are creating a Service class UserServiceImpl and this class is implementing the UserService interface. This class is annotated with @Service annotation to act service.  UserServiceImpl.java

• We used @Autowired annotation to inject UserRepository in this service class.
• We used saveAll() findAllByOrderByIdDesc() and findAllByOrderByIdAsc() query methods of that JPA Repository.

9. Creating a Rest Controller class

We are creating a RestController class UserController in which all methods are created for API endpoints for handling requests from the clients.  UserController.Java

• This class is annotated with @RestController annotation to make this class act as Rest Controller for giving response in JSON form.
• We used @RequestMapping annotation to define the base URL for the application.
• We used @PostMapping and @GetMapping annotations to handle HTTP requests from the client.
• We used ResponseEntity to represent the entire HTTP response.
• We used @Autowired  annotation to inject UserService in the class.
• We used @RequestBody annotation to take JSON object in the save() method as the List of User class parameter.
• We have created two restful web services handling methods[save(), getUserListDesc() and getUserListAs].
• save() : This saves the list of user records into the database.
• getUserListDesc() : This method is used to get the list of users in descending order based on the id from the database.
• getUserListAsc() : This method is used to get the list of users in ascending order based on the id from the database.

10. Run the Spring Boot Application and Check

Right-Click this Spring Boot application on the DemoApplication.java, then click Run As , and select Java Application.  

Check H2 Database

Check the H2 database console and browse this URL “http://localhost:8080/h2-console”.

See the below table here:

Testing API on the Postman

Saving the user data POST : http://localhost:8080/api/user/save-all

Check the table:

After this API hit Spring Data JPA (internally uses Hibernate as a JPA provider) generated SQL statement in the console below here:

Getting the list of users in descending order based on the id GET : http://localhost:8080/api/user/find-all-order-by-desc

Getting the list of users in ascending order based on the id GET : http://localhost:8080/api/user/find-all-order-by-asc

In this topic, we learnt how to use the findAll() query method with Order By in JpaRespository using Spring Boot Restful web services application.

Leave a Comment Cancel reply

Save my name, email, and website in this browser for the next time I comment.

Robert Niestroj's blog

Ordering columns in a Table in JPA/Hibernate

Starting with hibernate 6.2 it is now possible to order columns in tables generated by hibernate. the new concept is called columnorderingstrategy..

The order of columns in a Table does matter?

Most of the time it does not matter. However, the order of columns in a DB might impact the physical storage of the data. Columns are ordered in the way they were added to the table.

For example in PostgreSQL if you have a table like this:

The smallint column will be padded to the same size as the bigint column due to a mechanism called alignment padding . This wastes both storage and performance since the additional bytes need to be read and written. Of course, the impact on smaller databases will be negligible. But in big databases, this might be a noticeable difference. If you now put the bigint column first you save 6 bytes per row.

Keep in mind that after a table is created columns cannot be reordered. Most of the times the only way is to create a new table with the desired column order and SELECT the data INTO it.

Hibernate 6.2 ColumnOrderingStrategy

Hibernate v6.2 introduced a new interface ColumnOrderingStrategy which has two implementations:

ColumnOrderingStrategyLegacy

ColumnOrderingStrategyStandard

ColumnOrderingStrategyLegacy is essentially a no-op implementation and should resemble the behavior before Hibernate v6.2 where columns were basically ordered alphabetically.

ColumnOrderingStrategyStandard is the new default used strategy from v6.2 onwards. It sorts columns roughly by this algorithm:

order by max(physicalSizeBytes, 4), physicalSizeBytes > 2048, name

If you want to go back to the old behavior you can set the strategy by setting the hibernate configuration property hibernate.column_ordering_strategy the the value legacy . If you are configuring your hibernate properties in Java code you can use the AvailableSettings.COLUMN_ORDERING_STRATEGY constant.

Own implementations

You can create your own ColumnOrderingStrategy and use it.

One way to implement our own ColumnOrderingStrategy is to implement the interface ColumnOrderingStrategy and its 4 methods:

This is the way that gives us the most control over the ordering process. We can define sorting for all columns in a Table, Constraint columns (PKs, FKs), UserDefinedType columns and temporary tables.

The methods are easy to implement. The methods returning List<Column> can return null and the last method can be a no-op. This is the way the legacy strategy is implemented - see the source on GitHub .

Thus If we want basic sorting of columns it is enough to extend the ColumnOrderingStrategyLegacy and override the method List<Column> orderTableColumns(Table table, Metadata metadata) . Below you see an example of how to sort columns alphabetically.

Note that the interface HibernatePropertiesCustomizer is a SpringBoot-specific interface that provides the customize method to register the current class as the one to use for ordering the columns.

Testing was done using

Spring Boot v3.1.4

Hibernate v6.2.9

MySQL Community Server v8.1.0

We use this Entity for testing:

The Hibernate 6.2 default behavior

We can set spring.jpa.properties.hibernate.column_ordering_strategy=default or don't set it at all and get the following DDL generated by Hibernate:

The column age is first because an integer in MySQL takes 4 bytes. Next, the two bigint take 8 bytes and last the varchar columns take 16kB each.

The legacy behavior

We set spring.jpa.properties.hibernate.column_ordering_strategy=legacy and get the following DDL generated by Hibernate:

Here the primary key column id is first, the foreign key to the department is last and the remaining columns are alphabetically sorted.

Our own AlphabeticalColumnOrderingStrategy

See the code above. Now we get the following CREATE Statement:

Ordering columns by their physical size on the disk might improve the performance and disk space used in your database if you have lots of data.

Ordering columns might also improve the readability of the data in the tool you use to browse the DB. When you execute a SELECT * FROM MyTable you get the resultset in the order the columns were created/added to the database. With bigger tables, if the columns are ordered alphabetically it is easier to find the data we want. People may have also other requirements for the order of columns.

You might for example name your foreign key columns starting with id . After that, you could sort your columns by first ordering columns starting with id . This way you'd have your primary key and foreign keys first when you open a table in your DB Tool.

• Java Tutorial
• Java Spring
• Spring Interview Questions
• Java SpringBoot
• Spring Boot Interview Questions
• Spring MVC Interview Questions
• Java Hibernate
• Hibernate Interview Questions
• Advance Java Projects
• Java Interview Questions
• JPA - ORDER BY Clause
• MySQL ORDER BY Clause
• SQLite ORDER BY Clause
• Python SQLite - ORDER BY Clause
• JPA - Criteria WHERE Clause
• JPA - Cascade Remove
• JPA - Cascade Persist
• JPA - Criteria GROUP BY Clause
• SQL Server - OVER Clause
• JPA - Criteria SELECT Clause
• How to Custom Sort in SQL ORDER BY Clause?
• PHP | MySQL ORDER BY Clause
• Node.js MySQL Order By Clause
• Python MySQL - Order By Clause
• PostgreSQL - ORDER BY clause
• Group by clause in MS SQL Server
• Python MariaDB - Order By Clause using PyMySQL
• ORDER BY in SQL
• PostgreSQL - LIMIT clause
• Difference between order by and group by clause in SQL

JPA – ORDER BY Clause

JPA in Java can be defined as the Java Persistence API and consists of Java instructions for accessing and managing data between Java objects and related databases. JPA provides ways for us to access object-oriented and complex databases through SQL queries and database connections. There are many clauses in JPA and the ORDER BY clause is one of them. The ORDER BY clause can be used to sort the query results in ascending or descending order based on the fields.

ORDER BY Clause in JPA

The ORDER BY clause in JPA is used to sort query results generated in a JPQL (Java Persistence Query Language) query. This allows us to format the query results in the desired format and simplifies data interpretation and manipulation.

Steps to Implement ORDER BY Clause:

• Define the JPQL query with the SELECT statement of the JPA application.
• We can append the ORDER BY clause to the query and it can specify the fields by which results should be sorted.
• Execute the query and retrieve the sorted results of the program.

1. Sorting in Ascending Order

In the JPA Application, we can sort the query results in ascending order and it can specify the fields in the ORDER BY clause without the additional keywords.

2. Sorting in Descending Order

We can sort the query results in descending order add the DESC keyword after the field in the ORDER BY clause.

3. Sorting by Multiple Fields

We can sort the query results by the multiple fields by the listing in the ORDER BY clause separated by the commas.

4. Using Entity Relationships for Sorting

Entity relationships such as the one-to-many or many-to-one associations and it can be leveraged for the sorting. It can be performed based on the attributes of the related entities.

Sorting the employees by the name of their department or by date of joining where the department information or the joining date is stored in the related entities.

Step-by-Step Implementation of JPA ORDER BY Clause

We can develop the simple JPA application that can demonstrate the ORDER BY clause of the application.

Step 1 : Create the new JPA project using the Intellj Idea named jpa-order-by-clause-demo. After creating the project, the file structure looks like the below image.

Step 2 : Open the open.xml and add the below dependencies into the project.

Step 3 : Open the persistence.xml and put the below code into the project and it can configure the database of the project.

Step 4 : Create the table in MySQL database using the below SQL query:

Step 5 : Create the new Entity Java class named as the Employee .

Go to src > main > java > Employee and put the below code.

Step 6 : Create the new Java main class named as the Main .

Go to src > main > java > Main and put the below code.

Step 7 : Once the project is completed, run the application. It will then show the Employee name and salary by the descending order as output. Refer the below output image for the better understanding of the concept.

By the following the above steps of the article, developers can gain the soild understanding of the how to effectively use the ORDER BY clause in their JPA applications.

Please Login to comment...

Similar reads.

• Advance Java

Improve your Coding Skills with Practice

What kind of Experience do you want to share?

• Send Message
• Core Java Tutorials
• Java EE Tutorials
• Java Swing Tutorials
• Spring Framework Tutorials
• Unit Testing
• Build Tools
• Misc Tutorials
• Address.java
• Employee.java
• ExampleMain.java
• TableMappingMain.java
• persistence.xml

• Meet Our Team
• Judgment Enforcement & Collection
• Collections, Pre-litigation, Litigation, & Remedies
• Spousal Support Enforcement
• Judgment Domestications and Sister State Judgments
• Los Angeles Collection Wins
• Santa Monica/Beverly Hills
• Orange County Wins
• San Fernando Valley Wins
• Ventura County Judgement Collection Wins
• Riverside Judgment Collection Wins
• Fresno County Judgment Enforcement
• Testimonials
• Online Case Submission

Assignment Orders

Assignment orders are like wage garnishments, except they can be used on almost any income stream whatsoever- even if the income is “contingent on future events” (e.g. not even really an income stream yet). (See CCP 708.510 )  Type of income that can be attached through assignment orders include, but are not limited to

*Commissions (e.g. real estate or other commission salespeople’s compensation, not able to be wage-garnished);

*Royalties (e.g. actors/musicians residuals)

*And just about any other monies going to the debtor, for just about any reason.

Assignment orders also have built into them, the remedy of restraining orders ( CCP 708.520 ), preventing the debtor from transferring or otherwise disposing of, the payment stream, to be assigned.

CCP 708.520 restraining orders are much more useful judgment collection tool than regular CCP 527 restraining orders, because the ability to file EX PARTE (meaning the order can be gotten on as little as one days notice, so the debtor doesn’t have a chance to transfer assets or avoid- very useful for judgment enforcement) is built into the statute. This means that, arguably, the standard for getting such orders is less than the usual standard for EX PARTE relief. (Under The Ex Parte Rules of the Rules of Court, usually you must show “ irreparable harm ” to get ex parte relief; but under 708.520, it is likely that one would not need to make this very difficult showing, as the code simply says creditor must show “a need for the order.”)

Assignment orders can be used very broadly also, and if a Court can be convinced that monies being generated are “monies due to the debtor” – even if they are technically not going to the debtor (because they have been re-directed) – the Court may be convinced to re-direct the money to the creditor. In one example, a Debtor settled her lawsuit, but part of the settlement agreement was that the defendants were to pay debtors settlement monies to third parties. Even though the payments had been redirected to third parties, the Court believed the payments were “for the benefit of the debtor” and therefore, redirected the payments to the Creditor. In another case, Debtor redirected his wages to his ex-wife, and the Court re-directed them back to the Creditor. This saved the creditor the need to file a fraudulent transfer lawsuit. In another case, debtor was a touring musician who was going on a world tour. Sources of payment were unknown, but Court ordered debtor to keep an accounting of all payments made, and pay a portion to the creditor after is world tour.

Some Assignment order case law (updated periodically):

Detailed evidence maybe not required for assignment order. ( Innovation Ventures v. N2G )

Blanket Assignment of All Debtor Receivables without naming specific ones might be allowed. ( Phillipine Export v Chuidian ) – Not all courts allow this, it will depend on the judge/court)

Suffice to say that Assignment orders can get very involved, as they are far more versatile judgment collection tools than one might think, by just reading the code. Collection Attorneys in Los Angeles since 2011, The Evanns Collection Law Firm has been enforcing judgments for years and knows the ins and outs of this remedy. Phone calls are always free and no obligation. Call now at 213-292-6888.

• Nationals Designate Víctor Robles For Assignment
• Ronald Acuna Jr. Suffers Torn ACL, Will Miss Rest Of 2024 Season
• Ronald Acuna Jr. Exits Game With Apparent Knee Injury
• Report: MLB Teams Planning For Roki Sasaki Posting This Offseason
• Red Sox Sign Brad Keller
• Garrett Whitlock Likely To Undergo Internal Brace Procedure
• Hoops Rumors
• Pro Football Rumors
• Pro Hockey Rumors

MLB Trade Rumors

Reds Outright Bubba Thompson

By Steve Adams | May 25, 2024 at 12:49pm CDT

TODAY : Thompson has cleared waivers and been outrighted to Double-A Chattanooga, the Reds announced.

MAY 23 : The Reds announced Thursday that they’ve designated outfielder Bubba Thompson for assignment in order to create 40-man roster space for righty Brett Kennedy , whose contract has been selected from Triple-A Louisville. Kennedy will take the 26-man roster spot of reliever Emilio Pagan , who’s being placed on the 15-day injured list due to tightness in his right triceps.

Thompson appeared in 17 games for the Reds but received only 18 plate appearances. He’s among the fastest players in MLB — if not  the fastest — but has long had struggles at the plate, thus relegating him to a defensive replacement and pinch-running role. He went 2-for-18 with a double and five steals in his small handful of plate appearances but also punched out a glaring 11 times (61.1%).

A first-round pick by the Rangers in 2017, Thompson was a multi-sport star and legitimate football prospect as well prior to his selection and the signing of a $2.1MM bonus out of the draft. He’s now seen time in parts of three MLB seasons but is just a .232/.273/.295 hitter (58 wRC+) with a huge 32% strikeout rate and just a 4.2% walk rate. Thompson’s speed is off the charts, and he showed a bit of pop with 16 minor league big flies in 2021 and another 14 homers in 2022.

However, Thompson has still struggled to refine his approach at the plate even in the upper minors. He’d been playing with Cincinnati’s Double-A affiliate at the time of his DFA and, in 37 trips to the plate, carried a .200/.243/.314 slash. Thompson does have a .284/.347/.440 output in 145 Triple-A games, but that comes out to around league-average when adjusting for the electric run-scoring environment in the Pacific Coast League.

This is Thompson’s fifth DFA since last August. He’s yet to make it through waivers. The Royals claimed him off waivers from Texas but subsequently lost him to the Reds in October. When Cincinnati designated Thompson for assignment in late December, the Yankees put in a claim — only to DFA him again just weeks later. The Twins claimed Thompson but, like the Yankees, designated him for assignment after only a couple weeks, at which point the Reds claimed him a second time. He’s been with Cincinnati since that point but will now be traded or placed on waivers yet again within the next five days.

Kennedy, 29, has pitched in parts of two big league seasons: 2018 with the Padres and 2023 with the Reds. He’ll now get a second stint in Cincinnati and hope for better results than he turned in last year, when he was tagged for 13 runs in 18 innings. Kennedy has spent the 2024 season in the Louisville rotation but been roughed up for a 6.86 ERA in 40 2/3 frames (eight starts). His 18.9% strikeout is below-average by around five percentage points, but his excellent 4.7% walk rate is nearly half the league-average rate.

Kennedy will add some length to the bullpen in place of Pagan, who inked a surprising two-year, $16MM deal with the Reds this offseason — one that allows him the opportunity to opt out at season’s end. It was a surprise fit, given Cincinnati’s homer-happy stadium and Pagan’s longstanding penchant for big home run totals but also big strikeout rates. True to form, Pagan has already served up four taters in 19 1/3 innings of work (1.86 HR/9) but also punched out a substantial 30.5% of his opponents. He’s sitting on a 4.19 ERA to begin his Reds tenure, but his season will now be paused for at least the next couple weeks as he lets that ailing triceps mend.

30 Comments

Time to bring back Votto? The Reds could probably acquire him in exchange for their 2 best prospects or possibly just for De La Cruz alone.

Again? In the world of professional comedians the mantra is “never repeat a joke on the same platform”.

“Professional comedians”…Apparently you think more of “Trojan Toss'” comedic ability than do I. In my opinion, he’s more likely a not-ready-for-primetime guy struggling to hold onto his day job.

And working on his act in his parents basement in front of a mirror

Troll. My sister had troll dolls as a kid which were rather cute.

You’re more like a gnat to be swatted away. Please tell me you’re no more than 14 years old …

“He’s 53, not 55. And he has wealth and power.”

Votto Loco? Or big black bubba? Who ya got

Just what they need, another batting practice pitcher.

Yeah why not bring up Tony Santillan or activate Alex Young?

They’ll probably be activating Nick Lodolo soon so whoever they add now is likely to get optioned in just a few days. In any case it doesn’t really matter who’s at the end of the Reds’ bullpen if the team’s bats never wake up.

Santana is doing well in Louisville, good question

Bubba was a major distraction by the Reds. with this dfa, have to give Krall a failure on this move. Hell Sinai or Hopkins could have done no worse. I can see why the Reds didn’t promote Santillan yet. But why not Bruihl, or Kriske? What’s the major loss there? Savng an entire bullpen for 2025? DJ and Krall have to pull their shoes and socks off so they can count past 12 in situations like this.

A good point is that DJ is the blessing and the curse. There are some reclamations but his “unique” coaching style and exercises rub a lot of MLB pitchers the wrong way. IMHO, Bell is fine but DJ should move on to other pastures to everyone’s benefit…

Can’t agree. Team ERA under 4. Reds have good to great pitching prospects at all levels. Hang the hitting instructors by their little toes, but let’s keep Derek

Yes,cguy pitching has improved under DJ. It’s lack of offense causing our demise. 4 injuries/suspension have cost at least a couple runs per game and by my calculations all those one run losses could turn into wins. No lineup in MLB could loose 4 of their best and still be competent.

Can’t bring up Santillan. Put him on the roster and then you can’t send him back to the minors except thru waiver. He would get claimed. Rather have him than Pagan tho. Kennedy LOLOLOL We must be tanking already. Half of the starting lineup is on the DL. Bell won’t be fired and Definitely should be. MLB should force Castellini and Pirate’s owner to sell, and maybe a few others. Lose 7 of 10 years and you’re forced to sell. Rule to re-invest your profits. Bob C has made about 800 million to a Billion on a losing club. Be damned if I’m paying for parking, tickets and food n drinks at their prices. Only place the I spend money is $4 a month on reds minor leagues, and that guys politics have me rethinking that monthly purchase.

Cinredsfan, you point out that half of the starting lineup is on the IL (not to mention the pitching injuries) but then continue on to say that Bell should be fired.

Most the team is not hitting right now. What would you have Bell do?

Are you sure you are not on the Reds payroll? You are all over these sites carrying water for Bob Castellini.

Perhaps firing the manager may show your customer base you have at least a passing interest in winning?

If the manager doesn’t matter at all,as you contend, why not buy a homeless guy a 40 ounce to run the club?

Earm is just being fair. No way is this Bell’s fault. I blame the batboys. Notice how lazy they are? Seriously, we all are disappointed how this season has unfolded but Bell cannot shoulder all of it and firing him would not change the outcome .

Bubby, how exactly am I carrying water for Castellini? I rarely mention him, and when I do it’s not in a positive light.

I took issue with noting that half of the starting lineup is on the IL while calling for Bell to be fired.

And nowhere did I contend that the manager doesn’t matter.

If the team is healthy and still underperforming, you might have a leg to stand on. But the firing of Bell isn’t going to make the team healthy. Empty gestures won’t change this team’s fortunes.

Hitting under Bell has subpar annually. Bell putting Moll in today with diminished velocity worked about how this little league coach told his wife what would happen. I have won the league championship 7 of the last 9 years. I know I’m best in little league. Bell isn’t qualified to coach little league, let alone mlb. FACT!

You say hitting under Bell is subpar annually. Just last year they were 5th in the NL in runs scored, 5th in OBP, and 5th in Slugging %. And that was with a team in transition, starting a bunch of rookies, and losing key players for significant time.

There was widespread condemnation when Moll was sent to the minors because he was pitching well, and now you’re complaining that Bell used him. Fact is that most of the bullpen has underperformed this year and Bell’s choices are thus limited.

Let me take half of your starting little league lineup and sit them. Then I’ll take your best pitcher (Lodolo) and sit him for most of your season. Good luck with that little league championship.

At this point your being an Obtuse A. Bell getting fired would mean another manager who’s got the same injured team and a couple of regressing players on it in Steer and Benson. Along with the obvious fact that Managers are less in control of who’s in the lineup or where and how or who’s available in the bullpen. The FO analysis teams control most of what goes on now. Go read Joe Madden and his book on how managers are expected to operate now. If they take control out of a WS winning managers hand then sure as F they are to Bell. And anyone else they hire.

Never understood why these speedsters don’t learn to bunt. If you’re good at it and fast it’s as good as a single. Billy Hamilton flat out refused to from what I have read. He’d probably have made a lot more money and would be someone’s every day center fielder if he just learned to drop a bunt. Brett Butler made a career out of bunting. Guess it’s not as glamorous as 500 ft home runs, but most guys aren’t Elly De La Cruz and can do both. Learn to bunt Bubba and you just may play for one team for more than a month.

Bunting is overrated. It was important in the deadball era, though, back when the original Slidin’ Billy Hamilton played and where runs were hard to come by. Learning to bunt would not have made any difference to Hamilton’s career. They would have just started bringing the infielders in every time he came up.

Time to extend David Bell into the next millennium.

I never understood this acquisition to begin with. Regardless there are several players at the MLB level who need optioned. It’s a sad world being a Reds fan.

maybe it is time for Bubba to look into football

When they send you down to AA instead of AAA, that is a big sign you aren’t long for the sport.

If I were a GM I’d sign him

Leave a Reply Cancel reply

Please login to leave a reply.

Log in Register

• Feeds by Team
• Commenting Policy
• Privacy Policy

MLB Trade Rumors is not affiliated with Major League Baseball, MLB or MLB.com

Username or Email Address

Remember Me