🏷️ Tech Topics:#MyBatisLog#JPAParameters#SQLBinder#QueryRestore#LogParser#SpringFramework
📖

SQL Log Parameter Binder (MyBatis & JPA Log Parser) Guide

Combine placeholder question marks (?) or binding variables in SQL logs with their actual runtime values. Useful for debugging MyBatis, JPA, Hibernate, or Spring Framework logs instantly.

🔒Technical Specifications & Local Processing Architecture

Extracts values from parameter list lines using regular expressions, detects data types (e.g., String, Long, Integer, Boolean) based on syntax or type indicators (like `(String)`), and replaces target `?` placeholders safely.

✨ Core Capabilities

  • •Auto-detect mode: parse standard MyBatis "Preparing/Parameters" or Hibernate "binding parameter" log dumps.
  • •Split mode: Paste the raw SQL query with placeholders and the parameter values separately.
  • •Proper type escaping: Automatically adds quotes to strings/dates while leaving numeric and null values unquoted.
  • •SQL Beautification: Option to run the resulting bound SQL query through our built-in SQL Formatter.

🚀 Step-by-Step Guide

  1. 1Paste your server log dump containing the query and parameters in the SQL Log Input panel.
  2. 2For manual splitting, switch to "Split Mode" and paste the query into the SQL panel and parameter values in the Parameter panel.
  3. 3Click "Format Bound SQL" if you want the output query formatted and pretty-printed.
  4. 4Review the complete, executable query in the Output panel and click Copy.

💡Technical Deep-Dive & Detailed FAQ Guide

3 questions & detailed answers

Q1.How are different parameter types (String, Date, Numbers) escaped?

Strings and Dates are automatically wrapped in single quotes ('value'). Numbers, Booleans, and NULL constants are left unquoted so the SQL statement is syntax-valid.

Q2.Does this tool support MyBatis log formatting?

Yes. It parses the "Preparing:" line as the base SQL and the "Parameters:" line as the values list, matching them sequence-by-sequence automatically.

Q3.Is it secure to paste production database SQL logs containing PII?

Yes. This tool operates 100% locally in your web browser memory. No text or SQL statements are sent to any server, ensuring complete compliance with data privacy regulations.