The Leanpub 60 Day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms...
PostgreSQL Migration Survival Guide for Java Teams
Hibernate, JDBC, Liquibase, Type Mismatches, and the Production Traps Generic Tutorials Miss
Debug Java-to-PostgreSQL migration failures from the error outward: column type, JDBC binding, Java type, Hibernate mapping, Liquibase history. Examples smoke-tested on PostgreSQL 18, with the SQLSTATE to expect.
Minimum price
$7.99
$12.99
You pay
Author earns
PDF
EPUB
About
About the Book
Your Java application connects to PostgreSQL and the easy queries work. Then a varchar column meets a Long parameter, a null filter fails with "could not determine data type of parameter", a native IN query breaks on an empty list, or a Liquibase precondition records a change that never ran.
This field guide shows Java and Spring teams how to diagnose those failures from the PostgreSQL error outward (column type, JDBC binding, Java type, Hibernate mapping, Liquibase history) and which fixes are safe. It is for teams moving an existing application from MySQL, Oracle, SQL Server, or another database. It is not a PostgreSQL introduction or a Hibernate reference.
The JDBC and Liquibase examples were smoke-tested on PostgreSQL 18.4 and 16.15 with pgJDBC 42.7.13 and Liquibase 5.0.4, and the book tells you the SQLSTATE to expect. Some results surprise most teams: a typed setNull(..., TIMESTAMP_WITH_TIMEZONE) still fails in a "? is null or col >= ?" filter with pgJDBC; setBoolean into a legacy flag column either fails or silently stores the word "true", depending on column width; a Liquibase MARK_RAN guard that checks only an index name can permanently skip a migration; and an easy-to-write CASE x ... WHEN NULL backfill branch can never match null. The book shows the fixes that work.
Included: worked debugging examples, five field notes on recurring migration patterns, a one-page readiness checklist, and a symptom-to-first-safe-move table. Hibernate guidance is based on the Hibernate ORM 6.6 documentation and is marked as such. All examples are synthetic; no client, employer, or proprietary material is used.
About the author: Ren Calder is the pen name of a backend engineer with more than ten years of experience building production Java services, data pipelines, and PostgreSQL-backed systems.
How this book was made: it is based on the author's own Java-to-PostgreSQL migration project experience. The text was drafted and edited with AI tools, and the JDBC and Liquibase examples were verified by running them.
Feedback
Author
About the Author
Ren Calder
Ren Calder is the pen name of a backend engineer with more than ten years of experience building production Java services, data pipelines, and PostgreSQL-backed systems. This guide collects the checks they use when a Java application meets PostgreSQL's type system.
Get the free sample chapters
Click the buttons to get the free sample in PDF or EPUB, or read the sample online here
Earn $8 on a $10 Purchase, and $16 on a $20 Purchase
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
Learn more about writing on Leanpub
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Write and Publish on Leanpub
You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!
Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.
Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.