BestHub
Sign in
Tagged articles

JDBC

208 articles · Page 2 of 3
Java High-Performance Architecture
Java High-Performance Architecture
Dec 4, 2022 · Backend Development

How to Efficiently Import and Export Millions of Records with EasyExcel and POI

This article explains the challenges of large‑scale Excel import/export in Java, compares POI workbook implementations, introduces EasyExcel for high‑performance handling of hundreds of thousands to millions of rows, and provides detailed code examples for batch querying, sheet management, and JDBC batch insertion with transaction control.

Batch ProcessingData ExportEasyExcel
0 likes · 23 min read
How to Efficiently Import and Export Millions of Records with EasyExcel and POI
Java Architect Essentials
Java Architect Essentials
Nov 24, 2022 · Backend Development

How to Efficiently Import and Export Millions of Rows with POI and EasyExcel

This article explains how to overcome the limitations of traditional Apache POI when handling massive Excel import/export tasks by comparing POI workbook types, selecting the appropriate one, and using EasyExcel together with batch database queries and JDBC transactions to process up to three million rows efficiently.

Apache POIBatch ProcessingEasyExcel
0 likes · 23 min read
How to Efficiently Import and Export Millions of Rows with POI and EasyExcel
vivo Internet Technology
vivo Internet Technology
Nov 2, 2022 · Backend Development

Understanding Java SPI: Principles, Implementation, and Applications

Java SPI is a lightweight plug‑in mechanism that decouples service contracts from implementations using a META‑INF/services configuration file and the ServiceLoader class, enabling dynamic loading of providers as demonstrated with simple examples and applied in frameworks such as JDBC, Spring Boot, Apache Commons Logging, and Dubbo.

Dependency InjectionDubboFrameworks
0 likes · 33 min read
Understanding Java SPI: Principles, Implementation, and Applications
Top Architect
Top Architect
Oct 20, 2022 · Databases

Performance Evaluation of Inserting Billion‑Scale Data into MySQL Using Java: MyBatis vs JDBC vs Batch Processing

This article presents a detailed performance test of inserting massive data into MySQL with Java, comparing three strategies—MyBatis lightweight insertion without transactions, direct JDBC handling with and without transactions, and JDBC batch processing—showing timing results for millions of rows and offering practical recommendations for high‑throughput data loading.

Batch ProcessingDatabase OptimizationJDBC
0 likes · 14 min read
Performance Evaluation of Inserting Billion‑Scale Data into MySQL Using Java: MyBatis vs JDBC vs Batch Processing
Programmer DD
Programmer DD
Aug 25, 2022 · Databases

Why MySQL JDBC Driver Misinterprets CST and How to Fix the 13‑Hour Time Shift

This article investigates a puzzling 13‑hour time discrepancy caused by the MySQL 8.x JDBC driver interpreting the ambiguous CST timezone as America/Chicago, explains the underlying driver code and JDK timezone mappings, and provides multiple practical solutions including server settings, driver parameters, and official fixes.

CSTJDBCJava
0 likes · 17 min read
Why MySQL JDBC Driver Misinterprets CST and How to Fix the 13‑Hour Time Shift
Java Tech Enthusiast
Java Tech Enthusiast
May 23, 2022 · Backend Development

Implementing a Simple Java ORM Framework from Scratch

The article walks through building a lightweight Java ORM framework from scratch, showing JDBC drawbacks, defining XML configuration and mapper files, implementing core components like SqlSessionFactory, SimpleExecutor, and reflection‑based parameter and result mapping, and demonstrating a working test that returns POJOs.

JDBCJavaMyBatis
0 likes · 12 min read
Implementing a Simple Java ORM Framework from Scratch
dbaplus Community
dbaplus Community
May 16, 2022 · Databases

Master MySQL 8.0.28: Install, Configure, and Connect via JDBC

This guide walks beginners through downloading, installing, and configuring MySQL 8.0.28 on Windows and Linux, covering environment variables, service management, password recovery, user and role creation, and JDBC connection setup with Maven, providing detailed commands, code snippets, and troubleshooting tips for a complete setup.

ConfigurationInstallationJDBC
0 likes · 29 min read
Master MySQL 8.0.28: Install, Configure, and Connect via JDBC
ByteDance Data Platform
ByteDance Data Platform
May 11, 2022 · Big Data

How to Build a High‑Performance SparkSQL Server with Hive JDBC Compatibility

This article explains how to design and implement a SparkSQL server that lowers usage barriers and boosts efficiency by supporting standard JDBC interfaces, integrating Hive Server2 protocols, handling multi‑tenant authentication, managing Spark job lifecycles, and providing high‑availability through Zookeeper coordination.

HiveJDBCServer Architecture
0 likes · 15 min read
How to Build a High‑Performance SparkSQL Server with Hive JDBC Compatibility
Top Architect
Top Architect
May 3, 2022 · Databases

ShardingSphere-JDBC Overview, MySQL Master‑Slave Replication Setup, Binlog & Redo Log Review, and Sharding‑JDBC Read/Write Splitting & Sharding Implementation

This article provides a comprehensive tutorial on using ShardingSphere‑JDBC, configuring MySQL master‑slave replication with Docker, explaining binlog and redo‑log mechanisms, demonstrating two‑phase commit, and detailing Sharding‑JDBC read/write splitting and sharding configurations with code examples.

JDBCMySQLShardingSphere
0 likes · 23 min read
ShardingSphere-JDBC Overview, MySQL Master‑Slave Replication Setup, Binlog & Redo Log Review, and Sharding‑JDBC Read/Write Splitting & Sharding Implementation
Top Architect
Top Architect
Apr 2, 2022 · Backend Development

Can IO Multiplexing Replace Connection Pools for Database Access?

The article explains why database connections in Java applications usually rely on connection pools instead of IO multiplexing, discusses the blocking nature of JDBC, outlines how non‑blocking drivers could be built, and examines the practical and architectural reasons that prevent IO multiplexing from becoming the default.

Database Connection PoolIO MultiplexingJDBC
0 likes · 7 min read
Can IO Multiplexing Replace Connection Pools for Database Access?
Architecture Digest
Architecture Digest
Mar 27, 2022 · Backend Development

Why Database Connections Are Not Integrated with IO Multiplexing by Default

The article explains that although IO multiplexing can improve performance, database access in Java typically relies on JDBC and connection pools, which are built on blocking I/O, making it difficult to combine DB connections with IO multiplexing without major architectural changes.

Database ConnectionsIO MultiplexingJDBC
0 likes · 7 min read
Why Database Connections Are Not Integrated with IO Multiplexing by Default
Programmer DD
Programmer DD
Mar 2, 2022 · Databases

Why DBeaver Is the Free Alternative to Navicat After the Malware Scare

Following the Navicat Premium malware incident, this guide introduces DBeaver—a free, open‑source, multi‑platform database management tool, explains its features, installation steps, driver setup, and where to obtain both community and commercial versions.

DBeaverDatabase ManagementJDBC
0 likes · 4 min read
Why DBeaver Is the Free Alternative to Navicat After the Malware Scare
Top Architect
Top Architect
Feb 8, 2022 · Backend Development

Why Database Connection Pools Do Not Use IO Multiplexing

The article explains why traditional Java database connection pools rely on blocking I/O instead of IO multiplexing, covering JDBC's design, session management, resource constraints, and the practical challenges of adopting non‑blocking approaches in mainstream backend systems.

JDBCJavaNIO
0 likes · 9 min read
Why Database Connection Pools Do Not Use IO Multiplexing
Programmer DD
Programmer DD
Jan 21, 2022 · Databases

Why Java DB Connection Pools Skip IO Multiplexing (And What It Means)

This article explains why Java database connection pools typically use blocking I/O and connection pooling instead of IO multiplexing, covering JDBC's design, session management, ecosystem constraints, and the trade‑offs between performance and code complexity.

IO MultiplexingJDBCJava
0 likes · 8 min read
Why Java DB Connection Pools Skip IO Multiplexing (And What It Means)
Big Data Technology Architecture
Big Data Technology Architecture
Nov 28, 2021 · Big Data

Investigation and Resolution of HiveServer2 JDBC Connection Failures and GC‑Induced Hang

The article analyzes why HiveServer2 experiences JDBC connection failures and task execution stalls under high concurrency, reproduces the issues using GC monitoring and large join queries, and presents memory‑ and GC‑tuning solutions including server migration and JVM parameter adjustments to improve stability.

GC TuningHadoopHiveServer2
0 likes · 7 min read
Investigation and Resolution of HiveServer2 JDBC Connection Failures and GC‑Induced Hang
Programmer DD
Programmer DD
Nov 18, 2021 · Information Security

Configure Spring Authorization Server with JDBC Persistence in Spring Boot

This tutorial walks through setting up a Spring Authorization Server in a Spring Boot servlet project, adding required dependencies, configuring filter chains, persisting OAuth2 clients, authorizations, and consents with JDBC, and defining JWK sources and provider settings for a complete OAuth2 authorization server.

JDBCJWKOAuth2
0 likes · 18 min read
Configure Spring Authorization Server with JDBC Persistence in Spring Boot
Top Architect
Top Architect
Oct 2, 2021 · Databases

ShardingSphere-JDBC Tutorial: MySQL Master‑Slave Replication, Redo/Binlog, and Sharding Configuration

This article provides a comprehensive guide on using ShardingSphere-JDBC for read‑write splitting, configuring MySQL master‑slave replication with Docker, explaining redo log and binlog mechanisms, demonstrating two‑phase commit, and showing how to implement database sharding and distributed primary keys in a Spring Boot application.

JDBCMaster-Slave ReplicationMySQL
0 likes · 22 min read
ShardingSphere-JDBC Tutorial: MySQL Master‑Slave Replication, Redo/Binlog, and Sharding Configuration
Java Architect Essentials
Java Architect Essentials
Sep 27, 2021 · Backend Development

Comparative Analysis of Java Persistence Frameworks: Hibernate, MyBatis, JOOQ, Ebean, Spring Data JPA and JDBC Template

The article evaluates major Java persistence solutions—Hibernate, MyBatis, JOOQ, Ebean, Spring Data JPA and JDBC Template—by comparing their SQL encapsulation, DSL support, cross‑database portability, performance, and security, ultimately recommending JDBC Template for the author's project.

HibernateJDBCJava
0 likes · 13 min read
Comparative Analysis of Java Persistence Frameworks: Hibernate, MyBatis, JOOQ, Ebean, Spring Data JPA and JDBC Template
Zhongtong Tech
Zhongtong Tech
Aug 16, 2021 · Backend Development

Transform JMeter JDBC Request Output to JSON: A Step‑by‑Step Guide

This article explains how to modify JMeter's source code so that the JDBC Request sampler returns results in a clean JSON format, covering environment setup, code changes, building the custom JAR, integration, and the resulting improvements in readability and automation.

JDBCJMeterJSON
0 likes · 8 min read
Transform JMeter JDBC Request Output to JSON: A Step‑by‑Step Guide
Top Architect
Top Architect
Jul 27, 2021 · Databases

ShardingSphere-Jdbc Overview, MySQL Master‑Slave Replication, Binlog & Redo Log, and Sharding Implementation

This article introduces ShardingSphere‑Jdbc as a lightweight Java JDBC framework, details step‑by‑step Docker‑based MySQL master‑slave replication configuration, reviews redo log and binlog mechanisms, explains two‑phase commit, and demonstrates read‑write splitting and sharding strategies with Spring Boot examples.

JDBCMaster-Slave ReplicationMySQL
0 likes · 28 min read
ShardingSphere-Jdbc Overview, MySQL Master‑Slave Replication, Binlog & Redo Log, and Sharding Implementation
Programmer DD
Programmer DD
Jul 11, 2021 · Databases

Inside MyBatis Transactions: The Real Story of JDBC Commit, Rollback & Close

This article demystifies MyBatis transaction handling by explaining the true JDBC methods—setAutoCommit, commit, rollback—and clarifying common misconceptions about create, begin, close, and suspend, while exploring MyBatis’s Transaction, TransactionFactory, and practical code examples that illustrate how commits, rollbacks, and connection closing behave in various scenarios.

JDBCMyBatisSpring
0 likes · 10 min read
Inside MyBatis Transactions: The Real Story of JDBC Commit, Rollback & Close
Java Backend Technology
Java Backend Technology
Jun 20, 2021 · Databases

Avoid These 10 Fatal SQL Mistakes Every Java Developer Makes

Java developers often mishandle SQL, leading to performance, correctness, and maintenance issues; this article outlines ten common pitfalls—from misunderstanding NULL and misusing UNION to neglecting MERGE and batch inserts—and provides practical solutions to write efficient, reliable database queries.

Best PracticesJDBCJava
0 likes · 11 min read
Avoid These 10 Fatal SQL Mistakes Every Java Developer Makes
Laravel Tech Community
Laravel Tech Community
Jun 15, 2021 · Databases

PostgreSQL JDBC Driver 42.2.21 Release Highlights

The PostgreSQL JDBC Driver (PgJDBC) version 42.2.21 introduces documentation updates for the deprecated DataSource API, ensures primary keys for updatable result sets, adds asynchronous notification handling, rewrites the OSGi bundle activator, and fixes metadata retrieval when search_path is not specified.

Database DriverJDBCJava
0 likes · 2 min read
PostgreSQL JDBC Driver 42.2.21 Release Highlights
IT Xianyu
IT Xianyu
Jun 11, 2021 · Databases

10 Common Mistakes Java Developers Make When Writing SQL

The article outlines ten frequent errors that Java programmers encounter when writing SQL—ranging from misunderstanding NULL handling to misusing UNION, pagination, and batch inserts—and provides practical solutions to improve correctness, performance, and maintainability of database interactions.

Best PracticesJDBCJava
0 likes · 9 min read
10 Common Mistakes Java Developers Make When Writing SQL
Programmer DD
Programmer DD
Jun 11, 2021 · Backend Development

10 Common SQL Mistakes Java Developers Make and How to Fix Them

This article outlines ten frequent errors Java programmers encounter when writing SQL, explains why each mistake occurs, and provides practical solutions to improve correctness, performance, and maintainability of database interactions in Java applications.

JDBCJavaSQL
0 likes · 10 min read
10 Common SQL Mistakes Java Developers Make and How to Fix Them
21CTO
21CTO
Jun 10, 2021 · Databases

Which Java DAO Framework Is Right for Your Project? A Comparative Guide

An in‑depth comparison of popular Java DAO frameworks—including JDBC, JOOQ, MyBatis, Hibernate, and Spring Data—covers their core concepts, code examples, ideal use cases, and limitations, helping developers choose the most suitable data‑access layer for their projects.

DAOHibernateJDBC
0 likes · 7 min read
Which Java DAO Framework Is Right for Your Project? A Comparative Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
May 7, 2021 · Databases

Resolving MySQL wait_timeout Issues with Druid Connection Pool Configuration

This article analyzes the root causes of MySQL 'wait_timeout' related exceptions in a backend system using MHA read/write separation, explains how oversized connection pool timeout settings and MySQL wait_timeout lead to idle connections being closed, and provides practical Druid configuration adjustments and alternative solutions to eliminate the errors.

BackendDruidJDBC
0 likes · 7 min read
Resolving MySQL wait_timeout Issues with Druid Connection Pool Configuration
DeWu Technology
DeWu Technology
Mar 19, 2021 · Databases

TDengine Deployment for Sentinel Flow Control Data at DeWu

DeWu chose the open‑source time‑series database TDengine to store billions of daily Sentinel flow‑control metrics, using a super‑table design with per‑resource tables, a three‑node cluster, Druid/MyBatis pooling, and raw‑SQL writes, achieving 10 ms batch write latency, sub‑millisecond queries, and 90 % compression.

JDBCJavaPerformance
0 likes · 11 min read
TDengine Deployment for Sentinel Flow Control Data at DeWu
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 8, 2021 · Databases

Resolving Intermittent "Public Key Retrieval is not allowed" Errors in Java MySQL 8.0 JDBC Connections

This article explains why Java applications occasionally encounter the "Public Key Retrieval is not allowed" error when connecting to MySQL 8.0, analyzes the role of caching_sha2_password and user authentication cache, and provides practical solutions such as specifying the RSA public key, enabling AllowPublicKeyRetrieval=True, or switching to mysql_native_password.

DatabaseConnectionJDBCMySQL
0 likes · 5 min read
Resolving Intermittent "Public Key Retrieval is not allowed" Errors in Java MySQL 8.0 JDBC Connections
Java Architect Essentials
Java Architect Essentials
Feb 10, 2021 · Databases

Master DBeaver: Free Open‑Source Database Tool and Easy Installation Guide

This article introduces DBeaver, a free open‑source, cross‑platform database management tool that supports numerous databases via JDBC, outlines its rich features such as data editors, ER diagrams, import/export, and provides step‑by‑step installation instructions for Windows, macOS, and Linux, plus tips for creating connections.

Database ToolsInstallationJDBC
0 likes · 5 min read
Master DBeaver: Free Open‑Source Database Tool and Easy Installation Guide
Java Captain
Java Captain
Jan 23, 2021 · Databases

Introducing DBeaver: A Free Open‑Source Database Management Tool and Installation Guide

This article introduces DBeaver, a free open‑source, Java‑based database management and development tool that supports a wide range of databases via JDBC, outlines its rich features, provides installation instructions for Windows, macOS, and Linux, and walks through creating and using a database connection with screenshots.

DBeaverDatabase ManagementInstallation
0 likes · 5 min read
Introducing DBeaver: A Free Open‑Source Database Management Tool and Installation Guide
Big Data Technology & Architecture
Big Data Technology & Architecture
Dec 20, 2020 · Big Data

Getting Started with Apache Zeppelin: Installation, Core Features, and Integration with JDBC, Spark, and Flink

This tutorial introduces Apache Zeppelin, explains REPL and Jupyter concepts, outlines its core features and project structure, and provides step‑by‑step instructions for installing Zeppelin, creating notebooks, and connecting to databases, Spark, and Flink with practical code examples.

Apache ZeppelinFlinkInstallation
0 likes · 11 min read
Getting Started with Apache Zeppelin: Installation, Core Features, and Integration with JDBC, Spark, and Flink
Code Ape Tech Column
Code Ape Tech Column
Dec 11, 2020 · Databases

ShardingSphere Overview, Core Concepts, and Horizontal Sharding Example with Spring Boot

This article introduces Apache ShardingSphere's architecture—including ShardingSphere‑JDBC, ShardingSphere‑Proxy, and the upcoming Sidecar—explains data sharding principles, read/write splitting, and provides a complete Spring Boot example with Maven dependencies, Java source code, and configuration files for horizontal database partitioning.

JDBCRead-Write SplittingShardingSphere
0 likes · 19 min read
ShardingSphere Overview, Core Concepts, and Horizontal Sharding Example with Spring Boot
Top Architect
Top Architect
Nov 25, 2020 · Databases

Understanding MyBatis Transaction Mechanisms and JDBC Transaction Behavior

This article explains the real JDBC transaction methods, clarifies common misconceptions about transaction states in MyBatis, details the MyBatis Transaction and TransactionFactory interfaces, and explores special scenarios such as auto‑commit false, missing commit or close, with concrete code examples.

JDBCJavaMyBatis
0 likes · 10 min read
Understanding MyBatis Transaction Mechanisms and JDBC Transaction Behavior
Top Architect
Top Architect
Nov 16, 2020 · Backend Development

Understanding MyBatis Logging Implementation and LogFactory Mechanism

This article explains how MyBatis loads and categorizes logging implementations, details the role of SLF4J and other frameworks, describes the LogFactory adapter selection process, and shows how JDBC log proxies use dynamic proxies to output SQL execution details.

JDBCJavaLogFactory
0 likes · 8 min read
Understanding MyBatis Logging Implementation and LogFactory Mechanism
Liangxu Linux
Liangxu Linux
Oct 1, 2020 · Databases

Master DBeaver: Install, Connect, and Generate ER Diagrams for Any Database

Learn how to install the open‑source DBeaver tool, configure connections for databases such as PostgreSQL and Oracle via JDBC, manage drivers, and generate entity‑relationship diagrams, with step‑by‑step screenshots and links to official site and GitHub repository.

DBeaverDatabase ManagementER diagram
0 likes · 7 min read
Master DBeaver: Install, Connect, and Generate ER Diagrams for Any Database
Programmer DD
Programmer DD
Sep 26, 2020 · Databases

Master DBeaver: Install, Connect, and Generate ER Diagrams for Any Database

This guide walks you through downloading and installing DBeaver, setting up connections to various databases—including PostgreSQL, Oracle, and NoSQL platforms—using JDBC drivers, and creating ER diagrams, providing step‑by‑step instructions and screenshots to help you manage and visualize your data efficiently.

DBeaverDatabase ManagementER diagram
0 likes · 7 min read
Master DBeaver: Install, Connect, and Generate ER Diagrams for Any Database
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 15, 2020 · Databases

Resolving MySQL wait_timeout and JDBC Connection‑Pool Exceptions with Druid Configuration

This article analyses the root cause of generic "exception" errors during article publishing caused by mismatched MySQL wait_timeout and Druid JDBC pool settings, explains the impact of these parameters, and provides step‑by‑step configuration adjustments and alternative solutions to stabilise the backend database connection pool.

Database OptimizationDruidJDBC
0 likes · 6 min read
Resolving MySQL wait_timeout and JDBC Connection‑Pool Exceptions with Druid Configuration
dbaplus Community
dbaplus Community
Jun 29, 2020 · Databases

How JDBC ResultSetType Settings Trigger SQL Parsing Errors and Performance Issues

The article examines a severe database performance slowdown caused by excessive library cache locks, traces it to improper JDBC ResultSetType settings that introduce unwanted ROWID columns during SQL parsing, and presents systematic experiments across various queries, ResultSetType values, JVM configurations, and database versions to recommend optimal parameter choices.

JDBCMySQLOracle
0 likes · 11 min read
How JDBC ResultSetType Settings Trigger SQL Parsing Errors and Performance Issues
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 7, 2020 · Fundamentals

Introduction to Java Reflection

This article explains Java's reflection mechanism, covering how to obtain Class objects, the java.lang.reflect API, practical code examples, common use cases such as dynamic proxies, JDBC driver loading, Spring bean initialization, and discusses the advantages and performance drawbacks of using reflection.

BackendJDBCJava
0 likes · 13 min read
Introduction to Java Reflection
Aikesheng Open Source Community
Aikesheng Open Source Community
May 14, 2020 · Databases

MySQL 5.7 Upgrade Failure Caused by Default SSL Enablement and JDBC useSSL Parameter Misconfiguration

The article analyzes a MySQL 5.7 upgrade that broke an application due to SSL being enabled by default in version 5.7.28, explains how the JDBC useSSL=true setting triggered handshake errors, and provides several practical solutions such as disabling SSL, adjusting auto‑generation settings, and updating the connection string.

ConfigurationJDBCMySQL
0 likes · 12 min read
MySQL 5.7 Upgrade Failure Caused by Default SSL Enablement and JDBC useSSL Parameter Misconfiguration
Programmer DD
Programmer DD
May 12, 2020 · Backend Development

When Does Class.forName Initialize a Class? Java Class Loading Explained

This article explains the difference between Java's Class.forName and ClassLoader when loading classes, shows how the initialize flag controls static initialization, provides code examples, and discusses practical scenarios such as Spring IoC and JDBC driver registration.

ClassLoaderJDBCJava
0 likes · 7 min read
When Does Class.forName Initialize a Class? Java Class Loading Explained
Architecture Digest
Architecture Digest
Apr 22, 2020 · Databases

Implementing Database Sharding with ShardingSphere‑JDBC in Spring Boot

This article explains how to use ShardingSphere‑JDBC to achieve horizontal database sharding and read/write splitting in a Spring Boot application, covering ShardingSphere concepts, configuration, entity and DAO code, custom sharding algorithm, and practical testing with multiple MySQL instances.

JDBCMySQLReadWrite Splitting
0 likes · 23 min read
Implementing Database Sharding with ShardingSphere‑JDBC in Spring Boot
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Apr 5, 2020 · Backend Development

How Spring’s @Transactional Works Under the Hood and Build Your Own Transaction Annotation

This article explains Spring Boot’s @Transactional implementation, covers transaction isolation levels and propagation, walks through the core source code of TransactionInterceptor and PlatformTransactionManager, and guides you step‑by‑step to create a custom annotation that rolls back on specified exceptions using JDBC and AOP.

AOPJDBCSpring
0 likes · 15 min read
How Spring’s @Transactional Works Under the Hood and Build Your Own Transaction Annotation
Wukong Talks Architecture
Wukong Talks Architecture
Mar 3, 2020 · Databases

Using JDBC in Spring Boot: Dependency Setup, DataSource Configuration, Auto‑Configuration, JdbcTemplate, Swagger Integration, and Common Troubleshooting

This tutorial explains how to integrate JDBC into a Spring Boot project, covering Maven dependencies, MySQL driver setup, application.yml datasource configuration, Spring Boot's auto‑configuration mechanism, JdbcTemplate usage, Swagger documentation, CRUD endpoint implementation, and solutions to typical connection errors.

Auto-configurationJDBCJdbcTemplate
0 likes · 12 min read
Using JDBC in Spring Boot: Dependency Setup, DataSource Configuration, Auto‑Configuration, JdbcTemplate, Swagger Integration, and Common Troubleshooting
Wukong Talks Architecture
Wukong Talks Architecture
Mar 2, 2020 · Backend Development

Using JDBC with Spring Boot: Configuration, Auto‑Configuration, JdbcTemplate, Swagger Integration, and Common Troubleshooting

This guide explains how to integrate JDBC into a Spring Boot project, covering Maven dependencies, datasource configuration, Spring Boot's auto‑configuration mechanism, JdbcTemplate usage, Swagger setup for API testing, CRUD examples on a MySQL department table, and solutions to typical connection errors.

JDBCJdbcTemplateMySQL
0 likes · 13 min read
Using JDBC with Spring Boot: Configuration, Auto‑Configuration, JdbcTemplate, Swagger Integration, and Common Troubleshooting
Programmer DD
Programmer DD
Feb 11, 2020 · Backend Development

Preventing SQL Injection in Java: JDBC, MyBatis, JPA & Hibernate Best Practices

This article explains Java persistence technologies—including JDBC, MyBatis, JPA, and Hibernate—highlights common patterns that cause SQL injection, and provides concrete techniques such as parameterized PreparedStatement, MyBatis #{ } binding, dynamic SQL whitelisting, and proper JPA/Hibernate query parameter usage to securely handle user input.

HibernateJDBCJPA
0 likes · 10 min read
Preventing SQL Injection in Java: JDBC, MyBatis, JPA & Hibernate Best Practices
Programmer DD
Programmer DD
Feb 10, 2020 · Backend Development

How to Configure Druid DataSource and Monitoring in Spring Boot

This guide walks you through adding Alibaba's Druid connection pool to a Spring Boot project, configuring its properties, enabling built‑in monitoring via Actuator, and accessing the Druid dashboard to observe datasource and SQL performance metrics.

BackendDruidJDBC
0 likes · 12 min read
How to Configure Druid DataSource and Monitoring in Spring Boot
Programmer DD
Programmer DD
Feb 6, 2020 · Backend Development

Master Spring Boot DataSource: Configure HikariCP for Efficient DB Access

This article explains the concept of a DataSource, compares it with core JDBC APIs, and provides a step‑by‑step guide to configuring Spring Boot 2.x’s default HikariCP connection pool, including common properties, their meanings, and links to full example projects.

ConfigurationHikariCPJDBC
0 likes · 8 min read
Master Spring Boot DataSource: Configure HikariCP for Efficient DB Access
Programmer DD
Programmer DD
Jan 13, 2020 · Databases

Unveiling MyBatis Transaction Mechanics: From JDBC to Real‑World Scenarios

This article demystifies MyBatis transaction handling by clarifying the true JDBC transaction methods, explaining Spring's propagation concepts, detailing the MyBatis Transaction and TransactionFactory interfaces, showcasing code examples, and exploring special cases such as auto‑commit nuances and connection‑pool interactions.

ConnectionPoolJDBCJava
0 likes · 10 min read
Unveiling MyBatis Transaction Mechanics: From JDBC to Real‑World Scenarios
dbaplus Community
dbaplus Community
Dec 17, 2019 · Databases

Which Database Connection Pool Performs Best? A Real-World Multi-Threaded Test

This article presents a comprehensive multi‑threaded performance and safety evaluation of four popular database connection pools—Druid, JNDI, Tomcat, and Oracle UCP—across Tomcat, WebSphere, and JWS servers, detailing test setup, methodology, results, and best‑practice recommendations for proper pool usage.

Database Connection PoolDruidJDBC
0 likes · 9 min read
Which Database Connection Pool Performs Best? A Real-World Multi-Threaded Test
Programmer DD
Programmer DD
Oct 29, 2019 · Backend Development

Mastering JDBC: Essential Interfaces, Methods, and Best Practices

This article explains JDBC fundamentals, detailing its core interfaces such as Driver, Connection, Statement, PreparedStatement, and CallableStatement, outlines transaction isolation levels, common methods, ResultSet handling, and emphasizes the importance of mastering JDBC for effective use of Java ORM frameworks.

JDBCJavaORM
0 likes · 6 min read
Mastering JDBC: Essential Interfaces, Methods, and Best Practices
DevOps Cloud Academy
DevOps Cloud Academy
Sep 25, 2019 · Databases

How to Connect MySQL and Oracle Databases with JMeter

This guide walks through configuring JMeter to connect to MySQL and Oracle databases via JDBC, covering driver installation, JMeter component setup, request creation, result verification, and troubleshooting common connection errors for performance testing.

Database ConnectionJDBCJMeter
0 likes · 4 min read
How to Connect MySQL and Oracle Databases with JMeter
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 30, 2018 · Databases

Investigation of MySQL Shared Temporary Tablespace Limits and JDBC useCursorFetch Behavior

This article analyzes how MySQL's shared temporary tablespace (ibtmp1) grows when JDBC connections use the useCursorFetch=true parameter, demonstrates the resulting query failures and silent sleeps, compares segment‑fetch and stream‑fetch approaches, and proposes configuration and coding solutions to control temporary space usage and ensure proper error reporting.

JDBCJavaMySQL
0 likes · 10 min read
Investigation of MySQL Shared Temporary Tablespace Limits and JDBC useCursorFetch Behavior
Java Captain
Java Captain
Jul 29, 2018 · Databases

Student Information Management System Using Java Swing and MySQL

This article presents a complete Java Swing‑based student information management system, detailing the MySQL database schema, JDBC CRUD operations, model classes, DAO layer, utility classes, and a Swing UI, providing a practical example for building desktop applications with database integration.

DAODesktop applicationJDBC
0 likes · 15 min read
Student Information Management System Using Java Swing and MySQL
Programmer DD
Programmer DD
Jul 19, 2018 · Backend Development

How to Build a Spring Cloud Config Server with JDBC Storage

This tutorial walks through creating a Spring Cloud Config Server that stores configuration data in a MySQL database, covering project setup, Maven dependencies, database schema creation with Flyway, Java bootstrap code, application properties configuration, and verification using curl commands to retrieve configuration values.

Config ServerFlywayJDBC
0 likes · 10 min read
How to Build a Spring Cloud Config Server with JDBC Storage
dbaplus Community
dbaplus Community
Jun 19, 2018 · Databases

Mastering Sharding-Proxy: Architecture, Performance Tweaks, and Best Practices

This article provides a comprehensive technical overview of Sharding-Proxy, covering its transparent MySQL‑protocol design, internal architecture, PreparedStatement optimization, HikariCP tuning, result‑set streaming, memory‑strict and connection‑strict modes, and practical configuration tips for high‑performance database proxying.

Database ProxyHikariCPJDBC
0 likes · 17 min read
Mastering Sharding-Proxy: Architecture, Performance Tweaks, and Best Practices
Java Captain
Java Captain
Jan 6, 2018 · Backend Development

Database Connection Pooling in Java: Concepts, Implementation, and Configuration

This article explains why creating a database connection for each request is inefficient, introduces the concept and configuration of connection pools, provides a custom Java DataSource implementation, and demonstrates the use of popular open‑source pools such as DBCP, C3P0, and Tomcat JNDI with complete code examples.

JDBCJNDITomcat
0 likes · 24 min read
Database Connection Pooling in Java: Concepts, Implementation, and Configuration
Java Captain
Java Captain
Dec 7, 2017 · Backend Development

Comprehensive Java Learning Roadmap: From Fundamentals to Advanced Web Development

This article presents a detailed Java learning roadmap that starts with front‑end basics, progresses through core Java SE concepts, object‑oriented programming, databases, web technologies, major frameworks, and advanced topics such as JPA, Lucene, and high‑performance architecture, offering a structured path for aspiring developers.

HibernateJDBCLearning Path
0 likes · 19 min read
Comprehensive Java Learning Roadmap: From Fundamentals to Advanced Web Development