BestHub
Sign in
Tagged articles

JDBC

199 articles · Page 2 of 2
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.

JDBCShardingSpheredatabase
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
dbaplus Community
dbaplus Community
Apr 11, 2022 · Databases

Why JDBC executeBatch Sends Single Queries and How to Enable True Batch Execution in MySQL

This article explains why MySQL 8.0’s JDBC driver processes executeBatch() calls as separate statements, demonstrates the root cause in the driver’s rewriteBatchedStatements logic, and shows how configuring rewriteBatchedStatements=true (and optionally allowMultiQueries=true) enables genuine batch execution.

Batch ProcessingJDBCallowMultiQueries
0 likes · 6 min read
Why JDBC executeBatch Sends Single Queries and How to Enable True Batch Execution in MySQL
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.

IO MultiplexingJDBCNon-blocking IO
0 likes · 7 min read
Can IO Multiplexing Replace Connection Pools for Database Access?
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.

Connection PoolJDBCJava
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.

Connection PoolIO MultiplexingJDBC
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
IT Architects Alliance
IT Architects Alliance
Nov 19, 2021 · Backend Development

How SPL Transforms Java Data Processing: From CSV to Multi‑JSON with Embedded SQL

This article introduces SPL, an open‑source Java‑embeddable computation library that outperforms traditional embedded databases and DataFrame tools by handling both tabular and nested JSON data, supporting JDBC, SQL‑like queries, multi‑source integration, and persistent .btx files with concise code examples.

Embedded DatabaseJDBCJava
0 likes · 8 min read
How SPL Transforms Java Data Processing: From CSV to Multi‑JSON with Embedded SQL
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.

JDBCJWKSpring Authorization Server
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.

JDBCShardingSphereSpring Boot
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.

HibernateJDBCJOOQ
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.

JDBCJMeterJava
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.

JDBCShardingSpheredatabase sharding
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.

JDBCJavaSQL
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.

JDBCJavaSQL
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.

HibernateJDBCMyBatis
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.

Connection PoolDruidJDBC
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.

JDBCJavaSentinel
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.

DatabaseConnectionJDBCPublicKeyRetrieval
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.

Data ManagementDatabase ToolsInstallation
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.

Connection PoolDruidJDBC
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.

JDBCOracleResultSetType
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.

Dynamic ProxyJDBCJava
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.

ConfigurationJDBCSSL
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.

JDBCJavaclassloader
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.

JDBCReadWrite SplittingShardingSphere
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.

AOPAnnotationJDBC
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.

JDBCJdbcTemplateREST API
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.

HibernateJDBCJava
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.

DataSourceDruidJDBC
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.

ConfigurationDataSourceHikariCP
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
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.

Backend DevelopmentJDBCJava
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.

Desktop ApplicationJDBCJava
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 ServerJDBCSpring Boot
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.

Connection PoolJDBCJNDI
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.

Backend DevelopmentHibernateJDBC
0 likes · 19 min read
Comprehensive Java Learning Roadmap: From Fundamentals to Advanced Web Development
ITPUB
ITPUB
Jul 21, 2017 · Databases

How to Fix MySQL Emoji Errors with utf8mb4: A Complete Guide

This article explains why MySQL throws "Incorrect string value" when storing emojis, how utf8mb4 solves the problem, and provides step‑by‑step instructions—including table conversion, my.cnf changes, connector upgrades, and runtime workarounds—for reliable emoji storage.

Character SetEmojiJDBC
0 likes · 7 min read
How to Fix MySQL Emoji Errors with utf8mb4: A Complete Guide
Qunar Tech Salon
Qunar Tech Salon
Jun 27, 2017 · Databases

Database Deadlock Cases and Their Resolutions

This article examines three real‑world MySQL deadlock incidents—unique‑key null insertion, concurrent duplicate‑key insertion, and a JDBC parameter bug—detailing their detection, analysis, and the concrete fixes applied to prevent recurrence.

DeadlockJDBCUnique Index
0 likes · 9 min read
Database Deadlock Cases and Their Resolutions
360 Quality & Efficiency
360 Quality & Efficiency
May 15, 2017 · Fundamentals

Special Cases in Java Resource Closing: Utilities, Return Patterns, Non‑Closeable Streams, Nested Streams, JDBC Statements, and Sockets

This article, the fifth in a static code scanning series, explains six special scenarios—custom close utilities, methods returning resources, streams that need not be closed, nested stream closures, JDBC statement/result set relationships, and socket streams—that complicate determining whether Java resources have been properly closed.

CloseableIO StreamsJDBC
0 likes · 9 min read
Special Cases in Java Resource Closing: Utilities, Return Patterns, Non‑Closeable Streams, Nested Streams, JDBC Statements, and Sockets
ITPUB
ITPUB
Feb 16, 2017 · Databases

Mastering Oracle RAC Connect Time Load Balancing: Configurations and Runtime Strategies

This article explains how to configure client‑side and server‑side Connect Time Load Balancing for Oracle RAC across versions, details the role of SCAN, local_listener and remote_listener settings, describes Runtime Connection Load Balancing with FAN and LBA events, and shows how to tune TCP timeout parameters.

Connect TimeJDBCOracle
0 likes · 23 min read
Mastering Oracle RAC Connect Time Load Balancing: Configurations and Runtime Strategies
ITPUB
ITPUB
Apr 29, 2016 · Databases

How to Stream Large MySQL Query Results Without Running Out of Memory

MySQL normally loads an entire query result into memory, which can cause out‑of‑memory errors on large tables, but by adding the -q option in the console, enabling useCursorFetch in JDBC URLs, and setting stmt.setFetchSize(Integer.MIN_VALUE), you can switch to a streaming mode that returns rows one at a time.

JDBCResultSetStreaming
0 likes · 3 min read
How to Stream Large MySQL Query Results Without Running Out of Memory
Architecture Digest
Architecture Digest
Feb 15, 2016 · Databases

Sharding-JDBC: A Lightweight Java Database Sharding Framework

Sharding-JDBC is a client‑side Java framework that provides transparent horizontal sharding for relational databases, offering flexible sharding strategies, SQL parsing and rewriting, multi‑threaded execution, result merging, and high performance while requiring no additional deployment or proxy layers.

JDBCJavaSharding-JDBC
0 likes · 14 min read
Sharding-JDBC: A Lightweight Java Database Sharding Framework